Discovers, per tenant, workloads that create a licensing impact for Service Now ITOM

service-now-discovery-azure.kql

Resources
| where type in ('microsoft.sql/servers', 'microsoft.dbformysql/servers', 'microsoft.dbforpostgresql/servers', 'microsoft.documentdb/databaseaccounts', 'microsoft.cache/redis', 'microsoft.web/sites', 'microsoft.compute/virtualmachines', 'microsoft.containerinstance/containergroups' )
| extend resourceType = case(
    type == 'microsoft.compute/virtualmachines', 'Virtual Machines',
    type == 'microsoft.containerinstance/containergroups', 'Containers',
    type in ('microsoft.sql/servers', 'microsoft.dbformysql/servers', 'microsoft.dbforpostgresql/servers', 'microsoft.documentdb/databaseaccounts',
    'microsoft.cache/redis', 'microsoft.web/sites', 'Unknown' ), 'PaaS',
    'Unknown'
)
| summarize count() by resourceType