Statistics on KB documents

Products

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

Issue/Introduction

What database queries are done to gather KB statistics such as KB hits, KB vote counts, solution count etc.?

Environment

CA Service Desk Manager

Resolution

KB hits, KB vote counts, and Solution Count are all stored on the kt_report_card MDB table under the total_hits, total_votes, and total_solution_count columns.

Additional Information

Anytime you wish to see the exact database query CA SDM is running when you preform any action within the application, you can run the following command (either from the Primary Server or the Background server):

pdm_logstat -f sqlclass.c milestone

This will output the exact query into the CA SDM NX_ROOT\log\stdlog as soon as the action is performed within the UI.

Then run the following command to turn the logging off:

pdm_logstat -f sqlclass.c