Export Azure VMS to csv file

Question

Hi All

i have 10 subscriptions and i want to export all the VMS to csv file.
i am using the below syntax to connect to Azure powershell. when i use this syntax it connects me only to one subscription.
Connect-AzAccount -Credential (get-credential -UserName myuser@Company portal .com)
When i use the syntax Get-AzVM i am getting only limited information. i want to export the below information of all VMs from all subscriptions to csv file.
experts guide me on this.

Subscription
Name
Location
Status
Resource Group
VMType
Core
Mem (MB)
OS
IP
Zone
Created

Answer 1

Maybe this will help.

$report = @()
$subs = Get-AzSubscription
Foreach ($sub in $subs)
    {
    select-AzSubscription $sub | Out-Null
    $subName = $sub.Name

    $vms = Get-AzVM
    $publicIps = Get-AzPublicIpAddress 
    $nics = Get-AzNetworkInterface | ?{ $_.VirtualMachine -NE $null} 
    foreach ($nic in $nics) { 
        $info = "" | Select VmName, ResourceGroupName, Region, VmSize, VirtualNetwork, PrivateIpAddress, OsType, PublicIPAddress, Subscription, Cores, Memory, CreatedDate
        $vm = $vms | ? -Property Id -eq $nic.VirtualMachine.id 
        foreach($publicIp in $publicIps) { 
            if($nic.IpConfigurations.id -eq $publicIp.ipconfiguration.Id) {
                $info.PublicIPAddress = $publicIp.ipaddress
                } 
            } 
            [string]$sku = $vm.StorageProfile.ImageReference.Sku
            [string]$os = $vm.StorageProfile.ImageReference.Offer
            $osDiskName = $vm.StorageProfile.OsDisk.Name
            $info.VMName = $vm.Name 
            $info.OsType = $os + " " + $sku
            $info.ResourceGroupName = $vm.ResourceGroupName 
            $info.Region = $vm.Location
            $vmLocation = $vm.location 
            $info.VmSize = $vm.HardwareProfile.VmSize
            $info.VirtualNetwork = $nic.IpConfigurations.subnet.Id.Split("/")[-3] 
            $info.PrivateIpAddress = $nic.IpConfigurations.PrivateIpAddress 
            $info.Subscription = $subName
            if ($vmLocation)
                {
                $sizeDetails = Get-AzVMSize -Location $vmLocation | where {$_.Name -eq $vm.HardwareProfile.VmSize}
                }
            $info.Cores = $sizeDetails.NumberOfCores
            $info.Memory = $sizeDetails.MemoryInMB
            $osDisk = Get-AzDisk -ResourceGroupName $vm.ResourceGroupName -DiskName $osDiskName
            $info.CreatedDate = $osDisk.TimeCreated
            $report+=$info
            } 
    }
$report | ft VmName, ResourceGroupName, Region, VmSize, VirtualNetwork, PrivateIpAddress, OsType, PublicIPAddress, Subscription, Cores, Memory, CreatedDate

---

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Hi @Glenn Maxwell ,

Once you connect to your Account, you can pull the data for each of the subscriptions that your account has access to. This medium article has an example of someone doing just that. You could tinker with this script to write the data out to a CSV file.

Here is another example to get VM usages across subscriptions, again the process is the same once you have authenticated your account you can view the data for all subscriptions your account has access to.