Hi Dolev_Shor
thanks for sharing the workbook. I have a couple of suggestions for consideration and to share with the community
On the Load balancers tab include the sku.name in the table to distinguish between basic & standard as the standard sku will incur cost.
resources
| where type == "microsoft.network/loadbalancers"
| where properties.backendAddressPools == "[]"
| extend Details = pack_all()
| project subscriptionId, Resource=id, resourceGroup, location, tags, Details, tostring(sku.name)
And possibly supplement with an additional pie chart based on SKU adjacent to the locations chart above the table
resources
| where type == "microsoft.network/loadbalancers"
| where properties.backendAddressPools == "[]"
| summarize count(type) by tostring(sku.name)
Also ad a new tile/tab for Orphaned Azure Frontdoor WAF polices, this is the query I've been using:
resources
| where type == "microsoft.network/frontdoorwebapplicationfirewallpolicies"
| where properties.frontendEndpointLinks== "[]" and properties.securityPolicyLinks == "[]"
| project id, name, location, resourceGroup, managedBy, tostring(sku.name), plan, tags
Thanks
Paul
Microsoft