In smart assessment questionnaires, can we store both previous and original responses somewhere?

[sushma53]

I have a requirement: if an internal user changes responses for any questions on internal questionnaires, they should be able to see the previous responses as well. How do we enable this?

Thanks in advance.

[Tanushree Maiti]

Hi @sushma53 

I believe this is technically feasible via Audit tracking; However, enabling auditing on questionnaire response tables is not recommended, as it can generate a significant volume of audit data and potentially impact system performance.z

Instead of relying on auditing, it would be better to use standard reporting to review the data currently stored in asmt_metric_result and asmt_assessment_instance_question, or alternatively create database views to join these tables with the related target record (for example, Incident).

If the requirement is for internal users to view previous responses when questionnaire answers are modified in ServiceNow, this can be achieved by leveraging the platform’s audit tracking and activity stream capabilities on the survey response tables.

You can enable auditing as follows:

1. Navigate to sys_dictionary_list.do from the Application Navigator.
2. Filter the Table column for asmt_metric_result (or the specific table extending it).
3. Open the corresponding record, enable the Audit checkbox, and save the changes.

That said, questionnaire auditing is typically not standardized and should only be enabled after carefully considering the associated performance and data volume implications.