How to get the list of the unused Azure Resources from the portal/powershell?

Suri007 0
Viewed 60

I am working to delete the unused azure resources which are not used since last 3 months to save the cost. I tried to find in internet but not getting the proper answer.

Is any one know how to get the list though powershell or can export the details from the azure portal?

powershell script azure
2 Answers

"Unused" means a lot of different things when you look at different resource types. Maybe you are looking for VMs which are deallocated? Or for a SQL DB which had zero per cent CPU util? Or....

So, there is no general way to determine this through the ARM APIs.

silent0

or can export the details from the azure portal?

Yes, you can get the status of Vms as it is deallocated or not by using Azure resource graph as below and i followed SO-thread as below:

Resources
        | project name, location,     PowerState=tostring(properties.extended.instanceView.powerState.code),
        type
        | where type =~ 'Microsoft.Compute/virtualMachines'
        | order  by name desc

enter image description here

As you asked that you want Vms if its not used in 3 months by using Azure log Analytics Worksapce query and followed M-QandA as below:

AzureActivity
 |  where  TimeGenerated  >= ago(90d)
|  where  _ResourceId contains "Microsoft.Compute/disks"  or  _ResourceId contains "Microsoft.Compute/virtualMachines"
| distinct _ResourceId
RithwikBojja0
Related