Table Related Changes

Owned by manikandan.subbiah (Unlicensed)
Last updated: Apr 22, 2024 by Shilpa K (Deactivated)Version comment

Read Complete Release Notes

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.