Azure - Orphaned Resources dashboard

 

Introduction

Hello Everyone, 

Back to one more article with Azure Orphaned resources. As we all working in azure and we keep creating the resources as many as want based on the requirement, but sometimes we forget to delete those resources which will cost you without knowing it. This cost may be a smaller but if you calculate it for a year then it'll be a huge. 

So thought of creating the dashboard one, but before i create i wanted to know whether anyone published an article on how to fetch the same. Interestingly, I got lot of quite good articles but the content was same, So i've additionally added few tiles which will address the additional resource types.

I took the developed one from the following site and added additional content. 

Thanks to @Dolev Shor for developing this workbook.

https://github.com/dolevshor/azure-orphan-resources

Additionaly, Clone the new tile from the workbook and use the below Resource graph query to create new dashboards.

Snapshots:

resources

| where type == 'microsoft.compute/snapshots'

| extend TimeCreated = properties.timeCreated

| where TimeCreated < ago(30d)

| summarize count(type)

VM:

resources

| where type == 'microsoft.compute/virtualmachines'

| extend vmstatus = properties.extended.instanceView.powerState.displayStatus

| where vmstatus != 'VM running'

| summarize count(type)

Alerts: 

resources

| where type contains 'microsoft.insights/scheduledqueryrules' or type contains 'microsoft.insights/activitylogalerts' or type contains 'microsoft.insights/metricalerts'

| extend alertstatus = properties.enabled

| where alertstatus == 'false'

| summarize count(name)

LB:

resources

| where type == "microsoft.network/loadbalancers"

| where properties.loadBalancingRules == "[]"

| summarize count(type)

Certificate Expiration(Defined 30 days as an example)

resources

| where type == 'microsoft.web/certificates'

| extend expiry = todatetime(properties.expirationDate)

| where expiry between (now().. ago(-30d))

| project CertName=properties.subjectName, expiry

Virtual Networks without Subnet

resources

| where type == "microsoft.network/virtualnetworks"

| where properties.subnets == "[]"

Finally, the Dashboards would be like the below one, 

Let me know your comments if any.