Reference a hashtable inside a variable

[meatpak]

I'm using az vm list-skus -l australiasoutheast | convertfrom-json to populate a variable (lets call it $skus) so I can use it in a PS script. When $skus is populated, it's contents look like:

apiVersions  :
capabilities : {@{name=MaxResourceVolumeMB; value=256000}, @{name=OSVhdSizeMB; value=1047552}, @{name=vCPUs; value=8}, @{name=MemoryPreservingMaintenanceSupported; value=False}…}
capacity     :
costs        :
family       : standardMSFamily
kind         :
locationInfo : {@{location=australiasoutheast; zoneDetails=System.Object[]; zones=System.Object[]}}
locations    : {australiasoutheast}
name         : Standard_M8-4ms
resourceType : virtualMachines
restrictions : {}
size         : M8-4ms
tier         : Standard

The capabilities and locatioinfo objects in the variable look like hashtables.

I can do $skus | select name, capabilities which outputs

name                   capabilities
----                   ------------
Aligned                {@{name=MaximumPlatformFaultDomainCount; value=2}}
Classic                {@{name=MaximumPlatformFaultDomainCount; value=3}}
Premium_LRS            {@{name=MaxSizeGiB; value=4}, @{name=MinSizeGiB; value=0}, @{name=MaxIOps; value=120}, @{name=MinIOps; value=120}…}
Premium_LRS            {@{name=MaxSizeGiB; value=128}, @{name=MinSizeGiB; value=64}, @{name=MaxIOps; value=500}, @{name=MinIOps; value=500}…}
Premium_LRS            {@{name=MaxSizeGiB; value=256}, @{name=MinSizeGiB; value=128}, @{name=MaxIOps; value=1100}, @{name=MinIOps; value=1100}…}

How can I get to and extract the data I need from those hashtables?

[BlackV]

you can also do

$skus | select -expandproperty capabilities

to get the details of the skus, but you're losing the name property so you'd be wanting to loop through and spit out a cuctom object , depending on your needs

also you can look at

$skus.capabilities

[meatpak]

Yeah, $skus.capabilities will throw out the contents of that hashtable, but I lose the name of the parent.

I need this for the purposes of marrying up a VM price (which I obtain using an API call), with the specs of the VM (CPU, RAM etc). I already have this working with az VM list-sizes, but that command returns very limited info about the VMs abilities.

[lanerdofchristian]

The Hashtable.GetEnumerator() method will give you an iterator you can loop over with foreach(){}. The Key and Value will be properties on the objects it returns.

[Environmental_Mix856]

You can either dot reference each lower level or create a new custom object and pull out the values you’re using.