Scoreboard node table definitions

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

Within SDM, there is a concept of scoreboard nodes and queries.  This article discusses their definitions within the backend database.

Environment

Release : 17.3

Component :  CA Service Desk Manager Stored Queries

Resolution

The relevant tables are:

Cr_Stored_Queries (crsq Object)
Table Cr_Stored_Queries store the defined stored query definitions, such as "All Assigned Tickets" or "Priority 4 Tickets"

User Query (usq Object)
Table User Query is the actual Scoreboard Queries and nodes that are assigned or defined for a given user or role.  In this table, there is the column/attribute "query" which points to the Cr_Stored_Queries.code field.