How to get Azure VM operating sytsem detail version by Powershell

Hi @Mike Zhang

Try with the below script to get OS type.

$reportName = "myReport.csv"  
  
$report = @()  
$vms = Get-AzVM  
$publicIps = Get-AzPublicIpAddress   
$nics = Get-AzNetworkInterface | ?{ $_.VirtualMachine -NE $null}   
foreach ($nic in $nics) {   
    $info = "" | Select VmName, ResourceGroupName, Region, VirturalNetwork, Subnet, PrivateIpAddress, OsType, PublicIPAddress   
    $vm = $vms | ? -Property Id -eq $nic.VirtualMachine.id   
    foreach($publicIp in $publicIps) {   
        if($nic.IpConfigurations.id -eq $publicIp.ipconfiguration.Id) {  
            $info.PublicIPAddress = $publicIp.ipaddress  
            }   
        }   
        $info.OsType = $vm.StorageProfile.OsDisk.OsType   
        $info.VMName = $vm.Name   
        $info.ResourceGroupName = $vm.ResourceGroupName   
        $info.Region = $vm.Location   
        $info.VirturalNetwork = $nic.IpConfigurations.subnet.Id.Split("/")[-3]   
        $info.Subnet = $nic.IpConfigurations.subnet.Id.Split("/")[-1]   
        $info.PrivateIpAddress = $nic.IpConfigurations.PrivateIpAddress   
        $report+=$info   
    }   
$report | ft VmName, ResourceGroupName, Region, VirturalNetwork, Subnet, PrivateIpAddress, OsType, PublicIPAddress   
$report | Export-CSV "$home/$reportName"  

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

Hi,

If the machine is running, add switch -status to the call to Get-AzVM. Then the properties OSName and OSVersion are populated with information of the current OS. The information reflected in the StorageProfile contains the OS of the initial deployment. If an in-place upgrade or windows Updates have been performed, the StorageProfile does not reflect this, where OSName and more specifically OSVersion will reflect this.

$vms = Get-AzVM -Status

Sample of results