Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Track and Monitor changes to tables fields and scripts

joshuastanley
Tera Expert

Hello All,

 

I have a requirement to track and monitor the changes which occurs in an organization. Not willing to use the audit facility provided by ServiceNow. I am thinking to use the version table provided by ServiceNow which provides the UpdateSet name, Application, updated by, updated, Type, name and other valuable fields. Since this is not a straight forward report / dashboard generation. I now have to dynamically switch the second table based on the type ( table, fields, business rule, client script, script include etc ). I need string extraction from the field name to fetch the table name and sys_id to locate the record in second table. Does anyone have idea about generating this report / dashboard to quick view at objects modified by users.

 

Thanks in advance.

 

Regards, Josh

1 REPLY 1

andy449holland
Kilo Contributor

Hello All,

I have a requirement to track and monitor changes occurring within our organization, but I do not want to use the audit facility provided by ServiceNow. I am considering leveraging the version table in ServiceNow, which provides valuable information such as the Update Set name, Application, updated by, updated date, Type, Name, and other relevant fields. However, generating a report or dashboard from this data is not straightforward. I need to dynamically switch the secondary table based on the type of record (table, fields, business rule, client script, script include, etc.). This requires extracting the table name and sys_id from the field name to locate the corresponding record in the second table. I am looking for guidance or ideas on how to generate a report or dashboard that allows a quick view of objects modified by users.