Create a list of Azure VMs across all subscriptions

In case it helps anyone else… I needed to create a list of all the VMs across all my Azure subscriptions and put into a CSV file (so I can add to Excel, do a VLOOKUP, etc.)

Get-AzSubscription | ForEach-Object{
    Set-AzContext -Subscription $_.Name  | Out-Null
    foreach ($VM in Get-AzVM) {
        [PSCustomObject]@{
            VM = $VM.Name
            Subscription = $_.Name
        }
    }
} | Export-Csv ~\path\to\VMList.csv -Force -NoTypeInformation

Get-AzSubscription | ForEach-Object{

Set-AzContext -Subscription $_.Name | Out-Null

foreach ($VM in Get-AzVM) {

[PSCustomObject]@{

VM = $VM.Name

Subscription = $_.Name

}

} | Export-Csv ~\path\to\VMList.csv -Force -NoTypeInformation