Servicenow Get Stats

Retrieves aggregate statistics for a specified ServiceNow table, including COUNT, AVG, MIN, MAX, and SUM calculations. Use this action when you need to perform aggregate queries on ServiceNow tables to get statistical summaries (e.g., count of incidents by state, average priorit…

मूल्य

मुफ़्त Action

एकीकृत भुगतान

अभी समर्थित नहीं

• table_namestring

  आवश्यक
  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

  आवश्यक
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  आवश्यक
  Whether or not the action execution was successful or not

अभी कोई सत्यापित संबंधित उपयोग मामला लिंक नहीं है।