Check how records created

[Utkarsha]

Hello All,

I am facing a major issue in prod instance...one of our clients reported that when he checked in core_company table, he figured out that around 74 records got created at different instance of time in a specific view, with only name and type selected and no other information filled in...and for all of these records system is showing created by 'System' 
I suspect these records got created by some script.....but how can I make myself sure? I checked in node logs I got current month's log only since records created before that...also had a check in transactions module but of no use.... Is there any way I can find out which script has created this mess so that I can prevent the same from happening in future?

Any sort help here is greatly appreciated.

Thank you,

[Amit Gujarathi]

HI @Utkarsha  ,
I trust you are doing great.
Please find the below steps to debug on the same.
1. Enable audit logging for the core_company table.
2. Review audit logs for core_company creation events to identify the script or process.
3. Check for scheduled jobs or background scripts related to core_company.
4. Investigate background scripts and scheduled jobs in System Definition.
5. Take steps to prevent similar incidents in the future.

[Dhananjay Pawar]

Hi,

Check if any BR or Script Include or Schedule Job is creating those records.

Thanks.

[Ravi Chandra_K]

Hello @Utkarsha  

When these records are created. even though you checked node logs, the record transaction might have stored in different node.

Create a support case, Support can help you find the root cause.

Please mark this answer as helpful and correct if helped.

Kind Regards,

Ravi Chandra 

[Prerna_T]

Hello @Utkarsha  

Please check any schedule job that is active for creating these records. As the records are being generated after some time intervals. If possible also check script that includes Schedule job in it.