sn_aggregate
Compute COUNT, SUM, AVG, MIN, or MAX statistics and grouped aggregates directly on a ServiceNow table, answering how many or how many per group without pulling records.
Instructions
Aggregate over a table. action=stats (COUNT/SUM/AVG/MIN/MAX) or action=group (grouped statistics). One call answers 'how many', 'how many per group' without pulling records.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | No | ||
| table | No | ||
| action | No | stats | |
| group_by | No | ||
| aggregate | No | COUNT | |
| group_by_2 | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||