dolevshor / azure-orphan-resources Goto Github PK

"includeAll": true
this should be
"includeAll": false

in order to respect users configured filter/view, or those with 1000+ subscription this required to be changed every time when this great workbook is updated manually

In case you use ASR for Disaster recover AND the VMs were created with availability sets configured, ASR creates AVAILABILITY SETS with a suffix "-asr" at DR region.
Those AVSETs have no VMs associated BUT are created in case you restore the VMs at DR, so I think the workbook should not list that resources.
from MS docs,
Target availability sets
Availability set in which replicating VMs are located after failover.

Site Recovery creates an availability set in the target region with the suffix "asr", for VMs that are located in an availability set in the source location. If an availability set exists, it's used and a new one isn't created.

should VMs with PowerState/stopped be considered for orphaned resources reporting?

Resources | where type =~ 'microsoft.compute/virtualmachines' and properties.extended.instanceView.powerState.code =~ 'PowerState/stopped'

Public IPs associated to NAT Gateways are currently considered to be orphans.

These can be excluded by adding an extra filter:

Resources
| where type == "microsoft.network/publicipaddresses"
| where properties.ipConfiguration == "" and properties.natGateway == ""
| extend Details = pack_all()
| project Resource=id, resourceGroup, location, subscriptionId, sku.name, tags, Details

Hello,

Is there a feature that can be added for discovery of virtual machines that have been in deallocated state for a specified ammount of time? Let's say i have a vm that hasent been powered on for 30 or more days for example.

Hi , Hope you are doin good,

I have a use case where I want to add one of the values of the Subscription Tag as a Column Field in the workbook.
Say I have subscription tag as "user" with some name, I would like to have a column header as 'user' and fetch this value. Kindly assist.

Hi folks, what do you think to get IP prefix with no allocation for more than 30 days ?

Looking for Orphan azure private endpoint in this workbook
Please share your inputs on this

a cool feature might be to clean up resource by type.

If we want to know the cost incurred by these orphan resource how to do that ?

I noticed that in the "file" https://raw.githubusercontent.com/dolevshor/azure-orphan-resources/main/Workbook/Orphan%20Resources.workbook on Line 2804 there is a small typo.

It is set as "json": "# Orphan Reource Groups" but should be "json": "# Orphan Resource Groups"

Awesome job on this - might be cool to maybe have an orphaned or non assigned reservations view?

Hello! Awesome dash, appreciate it very much. I would like to request a view of resources without Tags and possibility to see which RGs they belong to. Thanks!

Is there any way to calculate and display the costs associated with those orphaned objects which have a cost ($)?

If so, this would be a great enhancement.

Thank you in advance!

I was testing your code and I realized that the Overview of each resource is always empty:

All other fields (Activity Log, Access Control, Tags, etc...) are all populated.

The workbook shows the amount of subnets with no resources but does not list them out.

Hey,
could you please also include Application Gateways without backend target(s).
Please list them in the workbook "Overview" and create additionally an own tab for the Application Gateways.

Thanks a lot.

I think a query under compute would be nice to see the amount of virtual machines that are shutdown and possibly the option to pick how long they have been turned off.

Where it says Replace the JSON in the gallery template to the orphan resources JSON (step 2)

I would change the text to make sure people change it to use the workbook json file and not the json file in your repo - save some people some time :)

Firstly thanks for creating this, it has really helped clean up our environment and save us some money.

Hope you can help with this small issue:
In the Overview tab I can see the Subnets total
I then select Networking and click the ellipses ... and Subnets item is not listed. This prevents me to see the details of the orphaned Subnets

Hope this is an easy fix and appreciate your time on building this useful tool.

Best regards, Paul

Hi Daniel,

Hope you are doing good.

I wanted to test this Azure Monitor Workbook to get the Orphan resources but i am unable to import, its saying this workbook has no content. Seems some syntax issue with the workbook.json file. Pls suggest.

Add all Virtual private networks Gateways without connections.

This resource saves cost.

Unable to see the Subnet details under the Networking Tab. Please find the attached screenshot

Hello! I would like to request a view of all orphaned backups that have missing resources. For example, a deleted/decommissioned VM that has backups still attempting to run. So a list of all Backup items in the various backup management types. Examples SQL in Azure VM, Azure Virtual Machine, Azure Storage. Thanks!

Great Work On this.

What you think add Private DNS Zones without Vnet Links? Does this makes sense?
This is a resource with cost.