run_aggregate_query
Execute grouped aggregate queries (COUNT, SUM, AVG, MIN, MAX) on ServiceNow tables to analyze data by categories like priority or assignment group.
Instructions
Run a grouped aggregate (COUNT, SUM, AVG) query on any table (latest release: /api/now/stats/{table})
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table to query (e.g., "incident", "task_sla") | |
| group_by | Yes | Field to group results by (e.g., "priority", "state", "assignment_group") | |
| aggregate | No | Aggregate function: COUNT (default), SUM, AVG, MIN, MAX | |
| query | No | Optional encoded query filter | |
| limit | No | Max groups (default: 20) |