Hi,
This post is to simplify things on getting Azure classic VM report in a nice format. I wrote PowerShell script to collect azure VM information in html format.
You can download script from here.
https://onedrive.live.com/redir?resid=2976E7AE701BC07C!158&authkey=!AE-BWeCcsiGHwvo&ithint=file%2cps1
Make sure you have Azure PowerShell module installed.
1. To check the module
Get-Module -ListAvailable
You should be able to see Azure module
ModuleType Version
Name
ExportedCommands
---------- -------
----
----------------
Manifest 1.2.3 Azure {Disable-AzureServiceProjectRemoteDesktop,
Enable-AzureServiceProjectRemoteDesktop, Get-AzureServiceProjectRoleRuntime,
Save-AzureServiceProject...
2. Login to Azure classic subscription.
Run
Add-AzureAccount
You will
be popped up with login windows. Provide your Credential
You will see your Azure
subscription ID and tenants ID.
3. Select-AzureSubscription -SubscriptionName 'your
sub. name'
4. Before extracting VM report you will have to know the name
of your cloud service.
Check your cloud service you want to take VM report from.
Check your cloud service you want to take VM report from.
5. Create folder
structure “C:\temp\Reports\Azure_VM_Info” this is
the location where will we save your report.
6. Change you cloud service name and run your PowerShell
command to get the nice report.
$cloudsname = 'Your azure cloud
service name'
$getvm = Get-AzureVM -ServiceName
$cloudsname |
select -Property
Name,IpAddress,InstanceSize,Status | ConvertTo-Html -Fragment
$getvm = $getvm | foreach {
$_ -replace "<td>ReadyRole</td>","<td
style='color:green'>Running</td>"
}
$getvm = $getvm | foreach {
$_ -replace "<td>StoppedDeallocated</td>","<td
style='color:red'>Stopped</td>"
}
$date = Get-Date -UFormat "%m-%d-%y"
$filename = "AzureVM_Info"+"$date"
$HTML = ConvertTo-Html -Body "<H2> AzureVMInfo - </H2>", "$getvm" -Head "<style>
body {background-color: lightblue; } table {background-color: white; margin
5px; float: left; top: 0px; display: inline-block; padding: 5px; border: 1px
solid black} tr:nth-child(odd) {background-color: lightgray}
</style>"
$HTML | Out-File C:\temp\Reports\Azure_VM_Info\$filename.html
Invoke-Item C:\temp\Reports\Azure_VM_Info\$filename.html
Hope this post will be informative to you.
“Have a nice day”
Digvijay
