/servicenow-aggregate | Type: Application | PCID required: Yes
Tools
| Tool | Description |
|---|---|
servicenow_aggregate_get_statistics | Compute aggregate statistics on a table |
servicenow_aggregate_get_statistics
Compute aggregate statistics on a table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableName | string | Yes | — | Name of the table to aggregate (e.g., incident, change_request, task) |
sysparm_query | string | No | — | Encoded query to filter records before aggregating (e.g., ‘state=1^priority=2’) |
sysparm_count | boolean | No | — | Set to true to return the total record count |
sysparm_avg_fields | string | No | — | Comma-separated fields to compute the average for |
sysparm_sum_fields | string | No | — | Comma-separated fields to compute the sum for |
sysparm_min_fields | string | No | — | Comma-separated fields to find the minimum value for |
sysparm_max_fields | string | No | — | Comma-separated fields to find the maximum value for |
sysparm_group_by | string | No | — | Comma-separated fields to group results by (e.g., ‘state,priority’) |
sysparm_having | string | No | — | Filter on aggregated results (e.g., ‘COUNT(sys_id)>5’) |
sysparm_order_by | string | No | — | Order results by field or aggregate (e.g., ‘state’ or ‘COUNT(sys_id)‘) |
sysparm_display_value | string | No | — | Return display values (true), actual values (false), or both (all) |
Show inputSchema
Show inputSchema
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID for the authenticated connection"
},
"tableName": {
"type": "string",
"description": "Name of the table to aggregate (e.g., incident, change_request, task)"
},
"sysparm_query": {
"type": "string",
"description": "Encoded query to filter records before aggregating (e.g., 'state=1^priority=2')"
},
"sysparm_count": {
"type": "boolean",
"description": "Set to true to return the total record count"
},
"sysparm_avg_fields": {
"type": "string",
"description": "Comma-separated fields to compute the average for"
},
"sysparm_sum_fields": {
"type": "string",
"description": "Comma-separated fields to compute the sum for"
},
"sysparm_min_fields": {
"type": "string",
"description": "Comma-separated fields to find the minimum value for"
},
"sysparm_max_fields": {
"type": "string",
"description": "Comma-separated fields to find the maximum value for"
},
"sysparm_group_by": {
"type": "string",
"description": "Comma-separated fields to group results by (e.g., 'state,priority')"
},
"sysparm_having": {
"type": "string",
"description": "Filter on aggregated results (e.g., 'COUNT(sys_id)>5')"
},
"sysparm_order_by": {
"type": "string",
"description": "Order results by field or aggregate (e.g., 'state' or 'COUNT(sys_id)')"
},
"sysparm_display_value": {
"type": "string",
"description": "Return display values (true), actual values (false), or both (all)",
"enum": [
"true",
"false",
"all"
]
}
},
"required": [
"PCID",
"tableName"
]
}