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.

Can I create a report to display whenever there is an update made to specific fields?

User393503
Tera Expert

I want to get a report created whenever there is a change or an update to specific fields and specific CIs that are on the same table. When I try to create certain conditions...I am confused as to what I should make the conditions.

3 REPLIES 3

Sylvain Lacombe
Tera Contributor

I would go to the table in question and ensure the Audit is set to true on the specific columns you wish to track changes against. (In this example, the table is Base Configuration Item, ensure to use the table you wish to set auditing on/track field changes against).

find_real_file.png

You can then run a report that will tell you if, and when a CI had those attributes updated. 

--------------------------------------------------------------------------------------------------------------------------

 

You can use Notifications as well to generate notifications when a record is updated, by going to system notifications and creating a new notification for the table in question, setting the conditions based on the fields you wish to track changes against. You would setup 'when to send', 'who will receive', and the script that is sent in the notification. This will send an email notification on each record update if they meet your conditions. 

 

--------------------------------------------------------------------------------------------------------------------------

You can also create a Dashboard with tiles (reports) that are displaying a count of records  (the tiles refresh automatically). 

find_real_file.png

For example, in the CI's Updated This Week tile, the report is looking for Created 'at or before' Last week(seeking existing CI's), and Updated 'at or after' This week (seeking CI's that have been updated during this week).

find_real_file.png

You would need to monitor the dashboard regularly to see the CI's that have been updated.

Clicking on the tile will give you a list of the CI's that were updated. 

Select a CI record that was updated from the list, and then click on the menu in the top left and change the view to 'CMDB Workspace'.

This will list all of the activities for that record at the bottom of the page, you can scroll to see what was changed, who changed it, and when. 

find_real_file.png

You can see the attributes that were collected when the CI was created, and the ones that were changed over time. 

find_real_file.png

 

I hope this information is helpful. 

 

Cheers, 

Sylvain

Have you tried if this solution works? As I know the history /audit trail on a record is dynamically populated when user search/view the history of a record in ServiceNow. If there are changes made on a record however no user search the history for this record before then the changes will not show up in the history report on the sys_history_line? or do you have a separate solution for this?

Lior Rudel
Tera Contributor

Maybe someone is using a script to simulate the event of touching the history record to produce the history line records?