Azure Policy

Cost Optmization in the Wild

Cost Optmization in the Wild

A collection of code used in presentation of Cloud Optimization in the wild

Erlend Rushfeldt
Here is a collection of snippets of code used in the “Cost Optimization in the wild! - Experiences from reducing costs” presentation. If you are missing any snippets of code used in a demo, or if you have any other question, feel free to message me on Twitter or LinkedIn. Orphaned disks Old Snapshots App Gateways and Load Balancers Storage v1 App Service Plans Orphaned disks KQL to find disks resources | where type == "microsoft.
Query Azure Policy Compliance results using KQL

Query Azure Policy Compliance results using KQL

How do you get more information about your Azure policy compliance?

Erlend Rushfeldt
Last blogpost I showed you an Azure Policy that checked for a SQL server firewall rule. The results would be a compliance view in Azure Policy. After the blogpost, me and Dennes Torres had a chat about the results you get in the compliance view. The problem: you don’t get the resource ID or resource name for the SQL server with the setting on. This isn’t really a problem if you have only one not-compliant resource, but if you have several, it becomes tedious.