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:
- Create a copy of the Dashboard you want to customize.
- Change the name of the container on the copy. It could be any name.
- Go to solution and choose container.
- Choose the “new container name”.
Before creating custom dashboards make sure you are aware of all the relevant SQL tables in Cora OpsManager.
Following are the SQL tables you need to know before modifying or creating new report/dashboard object:
Cases Details Table
Current case status and more info.
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.
Status History Log
For each case, what is the status history i.e. who changed the status and when.
Cases statuses codes and names.
Cases category codes and names.
Cases type codes per category and type names.
Sub Types Table
Cases sub types codes per type and sub type names.
Cases priorities code and names.
Case Audit Table
Audit details for each case.
Tasks details per case.
Tasks Assigned To Employees
For each case, who are the employees working on it.
For each case, to which group it has been allocated.
Case that has been sent to QA, and its results.
Case Attachments Table
All attachments information per case.
Reason codes and Reason text.