dolevshor / azure-orphan-resources Goto Github PK
View Code? Open in Web Editor NEWCentralize orphan resources in Azure environments
License: MIT License
Centralize orphan resources in Azure environments
License: MIT License
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.
Great Work On this.
What you think add Private DNS Zones without Vnet Links? Does this makes sense?
This is a resource with cost.
Hi @dolevshor
I hope your doing well !!!!
Do you have any plans or working on something that will automate the cleanup of Orphaned Resources using the workbook that you have created.
Thank You.
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! 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!
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.
The workbook shows the amount of subnets with no resources but does not list them out.
Add all Virtual private networks Gateways without connections.
This resource saves cost.
Hello @dolevshor
I want to verify if the Workbook located at https://github.com/dolevshor/azure-orphan-resources/tree/main/Workbook contains any commands that will retrieve data from the Azure Environments in which it is utilized, allowing you to view the data.
I want to confirm with you before configuring this workbook in my environments. I hope in this workbook you haven't configured to pull information on which azure environments it was configured.
If you can able to confirm that I can able to configure this in my environment and test it out . As I need to be save as the code is in Public Repos and other security reasons.
Please confirm Awaiting your valuable feedback..
Thank You....
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 , 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.
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.
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!
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!
Hi folks, what do you think to get IP prefix with no allocation for more than 30 days ?
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.
If we want to know the cost incurred by these orphan resource how to do that ?
Awesome job on this - might be cool to maybe have an orphaned or non assigned reservations view?
"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
Response payload size is 24813879, and has exceeded the limit of 16777216. Please consider querying less data at a time and make paginated call if needed...."
How to fix it?
a cool feature might be to clean up resource by type.
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'
Looking for Orphan azure private endpoint in this workbook
Please share your inputs on this
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 :)
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"
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.
We would like to have a seperate tab for taking the old snapshot
The query is:
Resources
| where type =~ 'Microsoft.Compute/snapshots'
| where properties.timeCreated < now(-30d)
But we are not able to group it properly. Its reflecting in all the tabs.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.