KQL Search

Query Details

HomeAI ToolsDevice Query

Azure Resource Count

Query

# Function: ResourcesCount()

## Query Information

#### Description
Count the number of Azure Resources for each subscription.

#### References
- https://learn.microsoft.com/en-us/azure/governance/resource-graph/overview
- https://learn.microsoft.com/en-us/azure/governance/resource-graph/samples/starter?tabs=azure-portal

## Log Analytics (Sentinel)
```
let ResourcesCount = () {
    arg("").Resources
    | summarize TotalResources = count() by subscriptionId
};
ResourcesCount()
```

Explanation

This query counts the number of Azure Resources for each subscription in Log Analytics (Sent) using the ResourcesCount function.

Details

Bert-Jan Pals profile picture

Bert-Jan Pals

Released: March 22, 2024

Tables

Resources

Keywords

Azure,Resources,SubscriptionId,TotalResources

Operators

arg("")Resourcessummarizecount()by

Actions