Is it possible to reset the User Votes rating on a Knowledge Document?

Document ID : KB000066198
Last Modified Date : 24/05/2018
Show Technical Document Details
Question:

Is it possible to reset the User Votes rating on a Knowledge Document?

article_issue.JPG

Environment:
CA Service Desk Manger 14.1 and 17.0
All Supported Operating Systems
Answer:

The data is stored within the KT_REPORT_CARD MDB table. In particular, the user votes data is stored within the TOTAL_VOTES field.

Information within this table is stored based on the KT Document ID. 

Please refer to the CA Service Desk Manager Technical Reference Guide for further information regarding the schema for this table.

https://docops.ca.com/ca-service-management/14-1/en/reference/ca-service-desk-manager-reference-commands/data-element-dictionary/knowledge-management-tables

https://docops.ca.com/ca-service-management/17-1/en/reference/ca-service-desk-manager-reference-commands/data-element-dictionary/knowledge-management-tables

Proceed to perform a pdm_extract of this table (i.e. pdm_extract KT_REPORT_CARD > ktreportcard.txt), make the necessary changes and then perform a
pdm_load.

Please ensure that a backup is made of the KT_REPORT_CARD MDB table prior to any changes being made.

As always, we recommend testing all changes in a non-PROD environment first.