Azure Powershell Query to return VM details

Question

Im trying to write a powershell query to return the following table:

NAME    STATUS  RESOURCE GROUP  VMSIZE  SIZEREASON (TAG)    LOCATION    PUBLIC DNS NAME

I can use Get-AzureRmVM | Select-Object Name, ResourceGroupName, Location but when I try to add on VmSize, the column is there but without values.

If I run just Get-AzureRmVM then I get the VmSize, so I don't understand why I can't select it.

I also need to work out how to add in Status, SIZEREASON (TAG),PUBLIC DNS NAME

Any guidence is most appreciated.

Its also worth noting, that my table also needs to contain both Resource Managed VM's and Classic VM's (So all VM's)

UPDATE

My Powershell query is currently:

Get-AzureRmVm `
  | Select-Object ResourceGroupName `
                , Name `
                , Location `
                , @{Name="VmSize"; Expression={$_.ToPSVirtualMachine().HardwareProfile.VmSize}} `
                , @{Name="SizeReason(Tag)"; Expression={$_.ToPSVirtualMachine().Tags.Values}} `
                , FullyQualifiedDomainName `
   | Format-Table

The outstanding problems are:

FullyQualifiedDomainName does not work
I am also missing the status (Eg: Running, Stopped (Deallocated) etc..)

I had also done that but I can not see a property called VmSize, even though just running 'Get-AzureRmVM' gives me VmSize — Jeffrey

gvee gvee · Accepted Answer · 2018-09-17T11:25:36

This was trickier than I expected....

Get-AzureRmVm | Select-Object @{Name="VmSize"; Expression={$_.ToPSVirtualMachine().HardwareProfile.VmSize}}

Azure Powershell Query to return VM details

1 Answers