How to find log analytics work space with commitment tier

Question

Hello,

Hope you are doing well !

One of our customer has 300+ log analytics workspaces in his subscription. How can we find the log analytics work space with commitment tier via a query not manually checking each LA work space.

Appreciate your help. Thank you!!

Answer 1

I'd suggest using the Azure Resource Graph to query/filter metadata properties of your workspaces.

This query should get you most of the way there;

Resources
| where type == 'microsoft.operationalinsights/workspaces'
| project name, resourceGroup, properties.sku.name, CapRes=properties.sku.capacityReservationLevel