Servicenow Get Stats

• table_namestring

  Required
  The name of the table to aggregate statistics from (e.g., 'incident', 'sys_user', 'task').
• sysparm_countboolean
  Set to true to return the count of records matching the query.
• sysparm_querystring
  Encoded query string to filter records before aggregating. Syntax: <col_name><operator><value>. Operators: = (equals), != (not equals), ^ (AND), ^OR (OR), LIKE, STARTSWITH, ENDSWITH. Example: active=true^priority=1
• sysparm_havingstring
  Having clause to filter aggregated results based on aggregate values. Syntax: <aggregate_function><operator><value>. Example: 'count>10' returns only groups with count greater than 10.
• sysparm_group_bystring
  Comma-separated list of fields to group results by. When specified, aggregate functions are calculated per group. Example: 'state,active' groups results by state and active status.
• sysparm_avg_fieldsstring
  Comma-separated list of numeric fields to calculate average for. Example: 'priority,urgency' calculates average priority and urgency values.
• sysparm_max_fieldsstring
  Comma-separated list of fields to calculate maximum value for. Example: 'priority,state' returns maximum priority and state values.
• sysparm_min_fieldsstring
  Comma-separated list of fields to calculate minimum value for. Example: 'priority,state' returns minimum priority and state values.
• sysparm_sum_fieldsstring
  Comma-separated list of numeric fields to calculate sum for. Example: 'priority' returns sum of all priority values.
• sysparm_display_valuestring
  Display value options for stats query responses

• data

  Required
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  Required
  Whether or not the action execution was successful or not

No verified related use cases are linked yet.

No published Skills explicitly reference this Action yet.