Cora Knowledge Center

Support

Create Custom Dashboards in Cora OpsManager

Dashboards in Cora OpsManager can be customized per requirement. However, we recommend Not to modify dashboards in Cora OpsManager as the updates will not get synced to the dashboards on upgrade.

To create custom dashboards:

  1. Create a copy of the Dashboard you want to customize.
  2. Change the name of the container on the copy. It could be any name.
  3. Go to solution and choose container.
  4. Choose the “new container name”.

Note: 
Before creating custom dashboards make sure you are aware of all the relevant SQL tables in Cora OpsManager.

SQL Tables in Cora OpsManager

Following are the SQL tables you need to know before modifying or creating new report/dashboard object:

Table

Description

Table Name

Cases Details Table

Current case status and more info.

UACT31fad8982d3446c79f83c3f7fbde3441 

Closed Cases View

For each Closed or Pending Closure case, the close date and the user who closed the case.

Available from version 1.7.

vw_OpsCenter_BI_ClosedCases

Status History Log

For each case, what is the status history i.e. who changed the status and when.

UACT1eb8ce0f0566496c8be117f9e0f19d7b 

Statuses Table

Cases statuses codes and names.

UTCMB8230dbb471b54872b8beb67bdd7c463c 

Category Table

Cases category codes and names.

UTCMBfb0df735ae3e4715a3c0b28953bb586e

Types Table

Cases type codes per category and type names.

UTCMB6d55c1086e1c4a3ba8a19a321c89f8bc

Sub Types Table

Cases sub types codes per type and sub type names.

UTCMBe96dd72769b049dcaee9c705acb96e2d

Priorities Table

Cases priorities code and names.

UTCMB327e788a1ee6456eba43bda317e3ac24

Case Audit Table

Audit details for each case.

UACTa79fc0da0d83440aaae1941a68959c0f 

Tasks Table

Tasks details per case.

USLf197425dadd5446a95fab04374f91784_Tasks

Tasks Assigned To Employees

For each case, who are the employees working on it.

USLf197425dadd5446a95fab04374f91784_TaskEmployeeAssignments 

Allocated Cases

For each case, to which group it has been allocated.

USLf197425dadd5446a95fab04374f91784_AllocatedCases

QA Table

Case that has been sent to QA, and its results.

UACT9bd6705efa414c47b5f377bc31cfa019

Case Attachments Table

All attachments information per case.

UACT6e0fd6cfcb564f5bb9ed12bf15840bc7

Reasons Table

Reason codes and Reason text.

UTCMBdc32b2249b7f416bab328def86b3fd3f