Need help with an Azure Powershell script

[utkarshdemon]

Need a count and names of Windows 2012 VMs using "Azure Hybrid Benefit for Windows" as "OS licensing benefit" type

[kilasuit]

This is the starting point in the document using this example

You'd need to get all vms in all subscriptions that you have access to which means that your end code could look like this

$allSubscriptions = Get-AzSubscription
$hybridVMs = @()

foreach ($subscription in $allSubscriptions) {
    Set-AzContext -Subscription $subscription.Id
    $subscriptionVMs = Get-AzVM | Where-Object {
        $_.LicenseType -eq "Windows_Server" -and
        $_.StorageProfile.OsDisk.ImageSKU -like "*2012*"
    }
    $hybridVMs += $subscriptionVMs
}
$hybridVMs

[utkarshdemon]

also, I'm just getting subscriptions details from this, whereas I need VM names from all the subscriptions.

[utkarshdemon]

@kilasuit can you please help here

[kilasuit]

I don't have an azure sub with VM's in it so this is as far as I can help right now but should be a good starting point

[utkarshdemon]

@kilasuit can you please add a line in which we can get the details all in a .csv file

[kilasuit]

@utkarshdemon You can do this by making used of the Export-Csv cmdlet easily enough.

Please have a read up on Export-Csv cmdlet documentation for more information on how to use this going forward