Scoreboard is garbled after changing the Access Type from Analyst to Employee Role

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Scoreboard of the users is garbled after their access type is changed

 

 

Environment

Service Desk Manager 17.x

Resolution

The following commands should be run on the Primary server for each users who is facing this problem.

1. Service Desk stores its Scoreboard Queries and the links from the users to the Scoreboard Queries in two tables:
   
   Cr_Stored_Queries and User_Query.
   
   Take a backup of the User_Query and Cr_Stored_Queries tables by running the below commands from the command prompt of the Primary server:
   
   pdm_extract User_Query > usq.txt
   pdm_extract Cr_Stored_Queries > crsq.txt
   
   
2. Obtain the uuid/persid of the contact who has the problem ex:"ServiceDesk" by running the command below from the Primary Service Desk server:
   
   pdm_extract -f "select id from ca_contact where userid = '<user's Service Desk login>'"
   
   This will return output like the following:
   
   {"##################################" }
   
   
3. Then extract the queries associated for that same user by running the commands below from the Primary Server:
   
   pdm_extract -f "select * from User_Query where:
   obj_persid='cnt:##################################'" > sdquery.txt
   
   Note, it is required to add the 'cnt:' before the uuid.
   
   
4. Remove the stored queries for the Contact:
   
   pdm_load -r -f sdquery.txt
   
   
5. Refresh the Application's cache on the User_Query table
   
   pdm_cache_refresh -v -t User_Query
   
   
6. Next, login again with the same user. This user will now get the default scoreboard.