Impact of the Use Stricter Rules option in the MDB

Products

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

Issue/Introduction

How does the use of the survey 'Use Stricter Rules' option affect the survey data recorded in the MDB for reporting purposes?

Environment

SDM 17.3 / 17.4

Resolution

The use of the survey 'Use Stricter Rules' option impacts which CA Service Desk Manager (CA SDM) survey data is written to the MDB.

When you use 'Use Stricter Rules' option, CA SDM is able to track when there is an entry in the database for a survey via the survey_tracking MDB table.

If the 'Use Stricter Rules' option is not used, there will be no entry in the MDB database and no mechanism to track the survey.

For example, if the "Use Stricter Rules' option is enabled, then there will be data written in the MDB for the 'notif_dt' column.

The same principle may apply to other CA SDM survey related data.

Additional Information

Survey information is stored in the tables listed below:

Survey (survey): Stores survey information.

Survey_Template (survey_tpl): Template for surveys.

Survey_Question (survey_question): Stores survey questions.

Survey_Stats (survey_statistics): Controls when a survey is issued.

Survey_Answer (survey_answer): Stores survey responses.

Survey_Tracking (survey_tracking): Tracks when a response was received to a survey, and when "Use Stricter Rules" is checked, is used to determine if the survey was already completed by that user.

Survey_Answer_Template (survey_atpl): Template for survey responses.

Survey_Question_Template (survey_qtpl): Template for survey questions

Managed_Survey (managed survey): Tracks Managed Surveys