How to check VM ready status for multiple VM's using a powershell script (around 120 VM's)

Question

How to check VM ready status for multiple VM's using a powershell script (around 120 VM's)

Ravi Kiran Moole 60

Siva Pavuluri 490 Microsoft External Staff Moderator

I understand your requirement: you want to add 120 VMs to a file (such as a CSV), and after the DR activity is completed, you need to check the status of those VMs. To replicate this, I reproduced the scenario in my environment. I created a CSV file containing a list of VMs across resource groups and ran the PowerShell script below. User's image Powershell script is:

$vmList = Import-Csv -Path "./VM_Status_Report.csv"
# Array to collect VM status results
$vmStatusList = @()
# Loop through each VM in the list
foreach ($vm in $vmList) {
    try {
        # Get VM with status
        $vmInfo = Get-AzVM -ResourceGroupName $vm.ResourceGroup -Name $vm.Name -Status
        # Extract PowerState from the Statuses array
        $powerState = ($vmInfo.Statuses | Where-Object { $_.Code -like "PowerState/*" }).DisplayStatus
        # Store result in array
        $vmStatusList += [PSCustomObject]@{
            Name              = $vm.Name
            ResourceGroup     = $vm.ResourceGroup
            Location          = $vmInfo.Location
            PowerState        = if ($powerState) { $powerState } else { "Unavailable" }
            ProvisioningState = $vmInfo.ProvisioningState
        }
    }
    catch {
        # In case the VM is not found or an error occurs
        $vmStatusList += [PSCustomObject]@{
            Name              = $vm.Name
            ResourceGroup     = $vm.ResourceGroup
            Location          = "Unknown"
            PowerState        = "Error"
            ProvisioningState = "Error"
        }
    }
}
# Display output
$vmStatusList | Format-Table -AutoSize
# Export to CSV
$vmStatusList | Export-Csv -Path "./DR_VM_Status_Report.csv" -NoTypeInformation

The output was successfully generated, and the CSV file was created as expected. User's image

If you have any further queries, let me know. If the information is helpful, please click on Upvote.

Thank you.

Siva Pavuluri 490 Reputation points Microsoft External Staff Moderator

2025-06-11T00:37:06.09+00:00

Hi Ravi Kiran Moole,

Just checking in to see if you have got a chance to see my response to your question in resolving the issue.

If it was helpful, please click "Upvote" on this post to let us know.

Thank You.
Ravi Kiran Moole 60 Reputation points

2025-06-11T01:55:39.5333333+00:00

Hi Siva,

what will be the content of the csv file, if you can give the screenshot that will also help, however i want to get the output of "Agent status" as well along with the above details

Siva Pavuluri 490 Microsoft External Staff Moderator

Hi Ravi Kiran Moole,

I have added the agent status to the script, and it worked successfully. This ensures we can now track whether the Azure VM Agent is running and properly reporting inside each VM.

please find the screenshot below:
User's image

Powershell script is:

$vmList = Import-Csv -Path "./VM_Status_Report.csv"
$WarningPreference = "SilentlyContinue"
# Array to collect VM status results
$vmStatusList = @()

# Loop through each VM in the list
foreach ($vm in $vmList) {
    try {
        # Get VM with status
        $vmInfo = Get-AzVM -ResourceGroupName $vm.ResourceGroup -Name $vm.Name -Status
        # Extract PowerState from the Statuses array
        $powerState = ($vmInfo.Statuses | Where-Object { $_.Code -like "PowerState/*" }).DisplayStatus
        # Extract VM Agent Status
        $agentState = $vmInfo.VMAgent.Statuses | Select-Object -ExpandProperty DisplayStatus
        # Retrieve VM Location using Get-AzResource
        $resourceInfo = Get-AzResource -ResourceGroupName $vm.ResourceGroup -ResourceType "Microsoft.Compute/virtualMachines" -Name $vm.Name -ErrorAction SilentlyContinue
        $vmLocation = if ($resourceInfo) { $resourceInfo.Location } else { "Unknown" }

        # Store result in array
        $vmStatusList += [PSCustomObject]@{
            Name              = $vm.Name
            ResourceGroup     = $vm.ResourceGroup
            Location          = $vmLocation
            PowerState        = if ($powerState) { $powerState } else { "Unavailable" }
            ProvisioningState = $vmInfo.ProvisioningState
            AgentStatus       = if ($agentState) { $agentState } else { "Unavailable" }
        }
    }
    catch {
        # In case the VM is not found or an error occurs
        $vmStatusList += [PSCustomObject]@{
            Name              = $vm.Name
            ResourceGroup     = $vm.ResourceGroup
            Location          = "Unknown"
            PowerState        = "Error"
            ProvisioningState = "Error"
            AgentStatus       = "Error"
        }
    }
}

# Display output
$vmStatusList | Format-Table -AutoSize
# Export to CSV
$vmStatusList | Export-Csv -Path "./DR_VM_Status_Report.csv" -NoTypeInformation

If you have any further queries, let me know. If the information is helpful, please click on Upvote.

Thank you.

Ravi Kiran Moole 60 Reputation points

2025-06-11T04:00:37.32+00:00

Hi Siva

Can you also please share the content of VM_Status_Report.csv how it looks like ? i want to use the same format
Siva Pavuluri 490 Reputation points Microsoft External Staff Moderator

2025-06-11T04:04:49.9866667+00:00

Hi Ravi Kiran Moole,

my csv file format screenshot.

If you have any further queries, let me know. If the information is helpful, please click on Upvote.

Thank you.

Accepted answer

4 additional answers

Your answer

Siva Pavuluri 490 Reputation points Microsoft External Staff Moderator

2025-06-10T08:15:13.82+00:00

Hi Ravi Kiran Moole,

I understand your requirement: you want to add 120 VMs to a file (such as a CSV), and after the DR activity is completed, you need to check the status of those VMs. To replicate this, I reproduced the scenario in my environment. I created a CSV file containing a list of VMs across resource groups and ran the PowerShell script below. Powershell script is:

$vmList = Import-Csv -Path "./VM_Status_Report.csv" # Array to collect VM status results $vmStatusList = @() # Loop through each VM in the list foreach ($vm in $vmList) { try { # Get VM with status $vmInfo = Get-AzVM -ResourceGroupName $vm.ResourceGroup -Name $vm.Name -Status # Extract PowerState from the Statuses array $powerState = ($vmInfo.Statuses | Where-Object { $_.Code -like "PowerState/*" }).DisplayStatus # Store result in array $vmStatusList += [PSCustomObject]@{ Name = $vm.Name ResourceGroup = $vm.ResourceGroup Location = $vmInfo.Location PowerState = if ($powerState) { $powerState } else { "Unavailable" } ProvisioningState = $vmInfo.ProvisioningState } } catch { # In case the VM is not found or an error occurs $vmStatusList += [PSCustomObject]@{ Name = $vm.Name ResourceGroup = $vm.ResourceGroup Location = "Unknown" PowerState = "Error" ProvisioningState = "Error" } } } # Display output $vmStatusList | Format-Table -AutoSize # Export to CSV $vmStatusList | Export-Csv -Path "./DR_VM_Status_Report.csv" -NoTypeInformation

The output was successfully generated, and the CSV file was created as expected.

If you have any further queries, let me know. If the information is helpful, please click on Upvote.

Thank you.
Siva Pavuluri 490 Reputation points Microsoft External Staff Moderator

2025-06-11T00:37:06.09+00:00

Hi Ravi Kiran Moole,

Just checking in to see if you have got a chance to see my response to your question in resolving the issue.

If it was helpful, please click "Upvote" on this post to let us know.

Thank You.
Ravi Kiran Moole 60 Reputation points

2025-06-11T01:55:39.5333333+00:00

Hi Siva,

what will be the content of the csv file, if you can give the screenshot that will also help, however i want to get the output of "Agent status" as well along with the above details
Ravi Kiran Moole 60 Reputation points

2025-06-11T04:00:37.32+00:00

Hi Siva

Can you also please share the content of VM_Status_Report.csv how it looks like ? i want to use the same format
Siva Pavuluri 490 Reputation points Microsoft External Staff Moderator

2025-06-11T04:04:49.9866667+00:00

Hi Ravi Kiran Moole,

my csv file format screenshot.

If you have any further queries, let me know. If the information is helpful, please click on Upvote.

Thank you.

Answer 1

Hi @Ravi Kiran Moole ,

to get the PowerStatus and the Agent Status please try this script using the same text file for your VM list:

$output = @()
$list = Get-Content -Path "<path to your file\<name of the text file>.txt"
foreach ($item in $list){
$VMs = Get-AzVM -Name $item -Status
foreach ($VM in $VMs) {
        $VM_status = Get-AzVM -Name $VM.Name -ResourceGroupName $VM.ResourceGroupName -Status
        $Row = "" | Select-Object Name, PowerState, ProvisioningState, VMAgent_Status, VMAgent_Version
        $Row.Name = $VM_status.Name
        $Row.PowerState = $VM.PowerState
        $Row.ProvisioningState = $VM.ProvisioningState
        $Row.VMAgent_Status = $VM_status.VMAgent.Statuses.DisplayStatus
        $Row.VMAgent_Version = $VM_status.VMAgent.VmAgentVersion
        $output += $Row
     }
}
 $output | Format-Table

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

Regards

Andreas Baumgarten

Answer 2

Andreas Baumgarten 123.4K MVP Volunteer Moderator

Hi @Ravi Kiran Moole ,

maybe this helps to get started:

Get-AzVM -status | Select-Object Name, PowerState, ProvisioningState

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

Regards

Andreas Baumgarten

Answer 3

Ravi Kiran Moole 60

Hello @Andreas Baumgarten

Could you please share more details on how to add around 120 VM's to the script and pull the required data or readiness state?

Like i have a list of 120 VM's included in the DR activity and i want to check the status after the DR, so i need to add these list of 120 selected VM's only

Ravi Kiran Moole 60 Reputation points

2025-06-10T07:32:44.2733333+00:00

Like i have a list of 120 VM's included in the DR activity and i want to check the status after the DR, so i need to add these list of 120 selected VM's only
Ravi Kiran Moole 60 Reputation points

2025-06-10T07:51:47.94+00:00

I am getting this error as in screenshot:
Andreas Baumgarten 123.4K Reputation points MVP Volunteer Moderator

2025-06-10T07:55:26.9866667+00:00

Hi @Ravi Kiran Moole ,

you are missing at least one line break in your try.

In front of foreach you need a line break.

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

Regards

Andreas Baumgarten
Ravi Kiran Moole 60 Reputation points

2025-06-10T08:00:46.22+00:00

Sorry for that mistake, however even if i give a line break, no results are showing up?

Can you share one screenshot of yours, how you are running ? so i can follow the same?
Andreas Baumgarten 123.4K Reputation points MVP Volunteer Moderator

2025-06-10T08:10:46.11+00:00

Hi @Ravi Kiran Moole ,

after login PowerShell with Azure (Connect-AzAccount) I run the lines like this and getting this output of the 3 VMs in my list:

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

Regards

Andreas Baumgarten
Ravi Kiran Moole 60 Reputation points

2025-06-10T08:18:06.7266667+00:00

i am running from the Azure Portal Powershell and i see this, let me check and update you
Andreas Baumgarten 123.4K Reputation points MVP Volunteer Moderator

2025-06-10T08:48:54.4733333+00:00

Hi @Ravi Kiran Moole ,

how the content of the text file looks like?

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

Regards

Andreas Baumgarten
Ravi Kiran Moole 60 Reputation points

2025-06-10T08:55:04.67+00:00

this is the content of text file
Andreas Baumgarten 123.4K Reputation points MVP Volunteer Moderator

2025-06-10T09:00:23.16+00:00

Hi @Ravi Kiran Moole ,

the file looks good. -> It's important the VM in the text file really exists with the same name in Azure!

Please try to run the script locally on your computer.

You need to install the AZ PowerShell module on your computer, if not already done.

Sing-in with Azure in a PowerShell session (Connect-AzAccount)

Run the script (maybe you have to adjust the path to the file).

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

Regards

Andreas Baumgarten
Ravi Kiran Moole 60 Reputation points

2025-06-11T02:04:13.82+00:00

Hi Andreas

i was able to run the script now and get the results Thank you

However Agent Status is missing it, can you add it?

i am trying to add this Agent Status in the script, but i am not able to , i need this status as well:

Answer 4

Andreas Baumgarten 123.4K MVP Volunteer Moderator

Hi @Ravi Kiran Moole ,

if you have text file with the VM name in each line you can try this:

$list = Get-Content -Path "<path to your file\<name of the text file>.txt"
foreach ($item in $list) {
Get-AzVM -Name $item -status | Select-Object Name, PowerState, ProvisioningState
}

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

Regards

Andreas Baumgarten

Answer 5

Ravi Kiran Moole 60

Thanks so much Andreas, that worked like charm!

Ravi Kiran Moole 60 Reputation points

2025-06-11T06:13:47.8966667+00:00

Can you also help me in getting the results in an excel sheet to the existing script ?
Andreas Baumgarten 123.4K Reputation points MVP Volunteer Moderator

2025-06-11T06:26:50.6633333+00:00
Hi @Ravi Kiran Moole ,

just add the following line at the end of the script.

This will create a CSV file which can be opened with Excel.

$output | Export-Csv -Path c:\Temp\vmstatus.csv -NoTypeInformation -Encoding UTF8

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

Regards

Andreas Baumgarten
Ravi Kiran Moole 60 Reputation points

2025-06-11T06:27:56.3266667+00:00

Thank you very much

Share via

How to check VM ready status for multiple VM's using a powershell script (around 120 VM's)

4 additional answers

Your answer