Need to find Mass Operational Status Update Made By My Team Member

[VinodKumarG9272]

Hi Everyone,

Greetings of the Day!!!

we have an issue related to mass / Bulk Update that made in ServiceNow.

For Two Classes Network Gear & Switch we have made around 13,000 CI's Bulk for Owned By & Managed By Fields using Parent Table (cmdb_ci) while Bulk Load As CI ID as a Parent.

We found the Few of the CI's have moved from Retired to Non - Operational Status after Bulk Load.

we cannot access sys_audit table as it was throwing error.

Could someone help us to find those CI's which are updated Operational status from Retired to non-operational. I have tried multiple filters but not got any result.

[GlideFather]

Hi @VinodKumarG9272,

You said: "we cannot access sys_audit table as it was throwing error.", 

- can you please specify what was the error about?

Also, if you want to find changes to set of data and you cannot use the audit table, then go to the desired table(s) and check the time of update and then set the conditions (e.g. Updated on [date of update] && State is "Non-operational"). I know it's not optimal but at least you can get an idea on how many records are there and you can then update it (script or Update job)...