How to find source of system updating a record

Ryan M
Giga Guru

We are trying to find the source of some records being deactivated.  The system is changing active to false on a nightly basis.  This is happening on certain records (not all active records) in the sn_imt_diagnosis_request table.  It happens at the same time the night it does happen.  There are no scheduled jobs at this time for this table.  There is a business rule that deactivates records but the conditions do not match and the rule also updates the comments (which is not showing for these).  

Is there a way to figure out what process/script is making this update?

 

find_real_file.png

1 ACCEPTED SOLUTION

Ryan M
Giga Guru

All good information in the replies here, particularly the code search tool, that will be helpful in the future.  In the end we found the source as a System Scheduler -> Scheduled Jobs not realizing that you could have an entry there without having one in System Definition -> Scheduled Jobs. 

View solution in original post

7 REPLIES 7

Ashutosh Munot1
Kilo Patron
Kilo Patron

Hi,

Ryan can you tell me which application is this?

Thanks,
Ashutosh

This is Emergency Exposure Management. 

Mohammad Danis1
Giga Guru

Hi Ryan,

Did you get a chance to look into Transaction log (syslog_transaction) ? 

find_real_file.png

You can check if transactions are related to user actions on the form or it's a scheduler etc .

Kind Regards,
Mohammad Danish 

 

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Ryan,

possible things to check

1) check the transaction logs for background

URL: https://instanceName.service-now.com/syslog_transaction_list.do?sysparm_query=sys_created_onONYesterday%40javascript%3Ags.beginningOfYesterday()%40javascript%3Ags.endOfYesterday()%5EurlSTARTSWITHJOB&sysparm_view=

2) Also check any workflow schedule is configured which triggers a workflow and possibly does the update

3) is there any flow configured; not pretty sure on this part though

If my answer solved your issue, please mark my answer as Correct & 👍Helpful based on the Impact.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader