sn_aggregate
Run COUNT, SUM, AVG, MIN, or MAX on any ServiceNow table with optional grouping. Returns statistical results without fetching individual records.
Instructions
Run COUNT/SUM/AVG/MIN/MAX on any table with optional group_by. Returns stats without fetching records.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| field | No | Field for SUM/AVG/MIN/MAX | |
| query | No | ||
| table | Yes | ||
| group_by | No | Group by field | |
| aggregate | No | COUNT, SUM, AVG, MIN, MAX | COUNT |