ServiceNow Administration

[vidyajadhav]

As an admin, I want to automate auditing on key tables so that all changes are tracked for compliance and troubleshooting. Where this option of making auditing enable I can find in ServiceNow

[GlideFather · Accepted solution]

Alright @vidyajadhav!

Then please update the URI below and navigate to system dictionary, filter Type: Collection for the particualr table (in this case sys_user_group) and mark the Audit field to TRUE:

https://your-instance.service-now.com/sys_dictionary_list.do?sysparm_query=internal_type%3Dcollection%5Ename%3Dsys_user_group&sysparm_view=

From that moment, changes made to records from that table (e.g. Group renaming, activation or deactivation will be available in the sys_audit table).

Sys Audit table with all the changes made (to be filtered):

Or the one particular record:

It does not work retrospectively, so changes made before marking the Audit true will not be trackable, only afterwards.

And from that point you can create a report or any other method to see the changes.

Please, let me know if this helped to solve your issue and if possible Accept as solution. Thank you

[GlideFather]

Olá @vidyajadhav,

• It is important to define what do you mean "key tables" - is it task, cmdb, some of their child tables, some custom tables or what exactly?
• What is your ambition to find in the audit, there is the table [sys_audit] in ServiceNow where you can find some interesting details, but I do not know what is your expectation to find out.
• What is the desired outcome from the audit - an excel sheet, or a graphical representation in a dashboard, email notification...
• Also, do you want to perform the audit just once and you are good or do you aim to do it regularly (weekly, monthly, half-yearly, once a 100 years).
  

Please, try to think of the details and then we can help you build it, but your question is too abstract lacking some real use case. Thank you very much.

EDIT: another useful tables for you might be:
[sys_history_set]
[sys_history_line]

[vidyajadhav]

Hi Kamil, 

Thank you for your response. Actually we want to enable auditing on table like sys_user_group so that if any changes are being done by developers, we can track those.

[GlideFather · Accepted solution]

Alright @vidyajadhav!

Then please update the URI below and navigate to system dictionary, filter Type: Collection for the particualr table (in this case sys_user_group) and mark the Audit field to TRUE:

https://your-instance.service-now.com/sys_dictionary_list.do?sysparm_query=internal_type%3Dcollection%5Ename%3Dsys_user_group&sysparm_view=

From that moment, changes made to records from that table (e.g. Group renaming, activation or deactivation will be available in the sys_audit table).

Sys Audit table with all the changes made (to be filtered):

Or the one particular record:

It does not work retrospectively, so changes made before marking the Audit true will not be trackable, only afterwards.

And from that point you can create a report or any other method to see the changes.

Please, let me know if this helped to solve your issue and if possible Accept as solution. Thank you

[Mark Manders]

Open the 'Collection' dictionary entry of the table and set 'audit' to true. Your  table will be audited and you can track it in the history of the table/records.