Azure resources metrics and their utilizations to Google sheet

Mohammed Shaik 20

Hello,

In order to identify whether the Azure resources/services is Idle/underutilized I am looking for a solution to fetch all the key metrics for all the resources types to a google sheet and automate the sheet to decide whether the resource is Idle/Underutilized.

Since there will be different metrics to be considered to analyze the utilization of different resource types. How we can identify which metrics to be considered for which resource type. Is it even possible to achieve when we have 1000s of resources in our azure subscription.

Final output I am trying to achieve:

Automate all the Azure Key metrics of all the resource types to a Google sheet
Automate the Google sheet to decide whether the resource is Idle/underutilized based on the metrics average
automate to send an email/alerts to the resource owner to take actions if any resources is Idle/underutilized

Thanks

Rahul Podila 595 Reputation points Microsoft Vendor

2024-12-03T06:33:46.28+00:00

Hi @Mohammed Shaik,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

First, each type of resource has different things we can monitor, such as CPU usage or how much space is being used. We can use Azure tools to collect this data ourselves.

Once we have the data, we can upload it to a Google Sheet so it’s all in one place. In the document, we can code items as non-functional or misused. For example, if a virtual machine uses less than 10% of its CPU for a month, we flag it as inactive.

If a product is misused or doesn’t work, we can automatically email the person in charge, so that he or she can take action.

If you have a lot of content, we can solve that by aggregating the data in small batches and scheduling regular updates, so you don’t have to worry about that.

This approach will save you time, reduce costs, and ensure you only pay for things you really need.

If you have any further queries, do let us know

If the answer is helpful, please click "Accept Answer" and "Upvote it"
Rahul Podila 595 Reputation points Microsoft Vendor

2024-12-04T01:36:08.95+00:00

Hi @Mohammed Shaik,
If you had a chance to see my comment to your question. If it was helpful, please click "Upvote" on my post let us know Thank you...!

Share via

Azure resources metrics and their utilizations to Google sheet

Your answer