Feature released in SummitAI Service Management (Denali, Service Management )
What's New?
Few changes related to tables are made. These changes capture some additional data, which are useful for more accurate calculations and improving the reporting functionalities.
Service Management DN Tables
Following DN tables are added for Incident Management, Service Request Management, Problem Management, and Change Management modules.
Incident Management
IM_RPT_DN_Workgroup_Bounce_Detail: A new table is added to capture the Incident Workgroup hop details.
Service Request Management
New Tables
SR_RPT_DN_ServiceRequestEffort: A new table is added to capture the Service Request effort details.
SR_RPT_DN_Workgroup_Bounce_Detail: A new table is added to capture the Service Request Workgroup hop details.
A new DN process is added to capture the records of Multi-valued Group Custom Attributes. To view the table, type in SR_RPT_DN_Custom_<Tenant ID>_<Group Display Name>_<Group Name>_Multi_Valued in the SQL Server Management Studio.
Example:
select * from SR_RPT_DN_Custom_Info_Default_Area_mvgroup_Multi_Valued
where <Tenant ID> is Info
<Group Display> is Default_Area
<Group Name> is mvgroup
New Columns
The following new columns are added in the SR_RPT_DN_ServiceTicketMaster table:
- [Sub Workgroup Name]
- [Sub Workgroup Display Name]
- [Last User Communication Updated On]
- [Private Log Updated On]
- [Total pending Duration SLA Minutes]
- [Total Pending Duration]
Change Management
CM_RPT_DN_Task_Master: A new table is added to capture the Change Request task details.
A new DN process is added to capture the Multi-valued Group Custom Attributes. To view the table, type in CM_RPT_DN_<Tenant ID>_<Category>_<Classification>_Multi_Valued in SQL Server Management Studio.
Example:
select * from CM_RPT_DN_Info_Large_Emergency_Multi_Valued
where <Tenant ID> is Info
<Category> is Large
<Classification> is Emergency
Work Order
- WO_RPT_DN_WorkOrderEffort: A new table is added to capture the Work Order effort details (in mins).
Gamification
- ADM_RPT_DN_Gamification_UserPoints: A new table is added to capture the Gamification User Points.
- ADM_RPT_DN_Gamification_Achievement_Earned: A new table is added to capture the records of Achievements Earned.