Azure Virtual Machines Power State (Resource Graph Query)

VM-PowerState-ARG.PS1

$Query = "Resources
| where type =~ 'microsoft.compute/virtualMachines'
| project id, VMName = tostring(name), Location = tostring(location), 
    ResourceGroup = tostring(resourceGroup), 
    SubscriptionId = tostring(subscriptionId), 
    OSType = tostring(properties.storageProfile.osDisk.osType),
    PowerState = iff(
    tostring(
    split(
    properties.extended.instanceView.powerState.code, '/'
    )[1]
    ) != '', tostring(split(properties.extended.instanceView.powerState.code, '/')[1]), 'transitioning'
    )"
$PageSize = 1000
$Iteration = 0
$SearchParams = @{
    Query = $($Query)
    First = $PageSize
}
[System.Collections.ArrayList]$Results = @()
do {
    $Iteration += 1
    $PageResults = Search-AzGraph @searchParams -Verbose
    $SearchParams.Skip += $pageResults.Count
    $Results.AddRange($pageResults)
} while ($PageResults.Count -eq $PageSize)
$Results