run_aggregate_query
Run grouped aggregate queries on any ServiceNow table to count, sum, average, min, or max grouped data by a specified field.
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) |