On The Service Desk Manager usq Table, What Do obj_persid And role_persid Signify, And How Are They Related?
search cancel

On The Service Desk Manager usq Table, What Do obj_persid And role_persid Signify, And How Are They Related?

book

Article ID: 115510

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction



What values can users expect to see in the obj_persid and role_persid columns on the usq table in the Service Desk Manager MDB, and how are they related? 

Environment

Release:
Component: USRD

Resolution

The item obj_persid will show either the contact uuid or role id, based on what the scoreboard query was created for.
The item role_persid will show the role related to the contact or role the scoreboard query was created for.
 
For example, if you create a query for a specific contact, it'll show their uuid as obj_persid, and their role as role_persid.

A visual example of creating test Scoreboard Queries and viewing related information on the usq table:

<Please see attached file for image>

Test Scoreboard Queries and Their References 
 

Additional Information

The following articles provide examples of how one could leverage the obj_persid and role_persid columns with regards to stored queries

Most Common Issues When Working with Scoreboard
https://comm.support.ca.com/kb/most-common-issues-when-working-with-scoreboard/kb000023072

Cannot save my personal search filter
https://comm.support.ca.com/kb/cannot-save-my-personal-search-filter/kb0001152973

Procedure to reset user scoreboard
https://comm.support.ca.com/kb/procedure-to-reset-user-scoreboard/kb000027219

Attachments

1558695394182000115510_sktwi1f5rjvs16i4r.png get_app