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

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

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