Perform Advanced Service Record Analytics
This job involves performing analytical queries on SysAid service records, including filtering, grouping by various fields, handling date and user information, and providing error reporting and pagination.
-
Overview
This job involves performing analytical queries on SysAid service records, with advanced grouping and filtering options. It supports filtering by various criteria such as status, priority, and user names, and allows grouping results by fields like ‘insertTime’ and ‘closeTime’, including flexible date grouping. The role also includes handling list field captions, fetching user names, detailed error reporting, and pagination of results.
-
Key capabilities
* Performs analytics queries on SysAid service records with enhanced grouping capabilities.
* Supports filtering by status, priority, location, urgency, assignee name, request user name, time ranges, assignment counters, and source.
* Allows grouping results by ‘insertTime’, ‘closeTime’, ‘updateTime’, and other selected fields.
* Implements ‘dateGroupBy’ configuration for grouping by date/datetime fields (day, week_of_year, month, year).
* Handles list field captions by fetching and mapping to display values.
* Includes user’s first and last name when grouping by ‘assigneeName’ or ‘requestUserName’.
* Provides detailed error reporting.
* Supports pagination of results.
Popular use cases
Use this AI agent and the others to make AI work for you and make you more productive!
