example json query

inventoryjsonquery.ps1

$inventory = Get-Content -Path .\vcen_inventory.json | ConvertFrom-Json

# update the datacenters with what is available in the vcenter
Update-ComboBox -ComboBox $combobox2 -Items ($inventory.vcenters | ?{ $_.name -eq $vcenter }).datacenters.

# update the clusters with what is available in the datacenter
Update-ComboBox -ComboBox $combobox3 -Items (($inventory.vcenters | ?{ $_.name -eq $vcenter }).datacenters | ?{ $_.name -eq $datacenter }).clusters.

# update the datastores with what is available in the cluster
$datastores = ((($inventory.vcenters | ?{ $_.name -eq $vcenter }).datacenters | ?{ $_.name -eq $datacenter }).clusters | ?{ $_.name -eq $cluster }).datastoresclusters | select @{ Name = "value"; Expression = { "$($_.name), $([math]::Round($_.freespacegb, 0)) GB free" } }
Update-ComboBox -ComboBox $combobox4 -Items $datastores.value

# update the portgroups with what is available in the cluster
$portgroups = ((($inventory.vcenters | ?{ $_.name -eq $vcenter }).datacenters | ?{ $_.name -eq $datacenter }).clusters | ?{ $_.name -eq $cluster }).vdportgroups | ?{ $_.VlanConfiguration -notlike "*trunk*" } | Select Name, VlanConfiguration, @{ Name = 'VlanID'; Expression = { [int]$_.VlanConfiguration.split(' ')[1] } } | Sort-Object -Property vlanid | select @{ Name = 'value'; Expression = { "$($_.VlanConfiguration), $($_.name)" } }
Update-ComboBox -ComboBox $combobox8 -Items $portgroups.value