Mass Deleting CIs, need to suppress that they were deleted on the User Record

[Donovan B]

I need to delete about 18,000 CIs that were created when an Intune import went wild, but I don't want them to enter a note on the Activity feed of the users it just causes noise, and some users have 185 Cis that need to be deleted.

You can see in this screenshot I deleted a Camera and a Dock from the sys_cmdb_peripheral table, and this caused 6 entries for those two items on this user's record.

I tried adding the attribute "No audit delete" to both the sys_user table and the sys_cmdb_peripheral table, but that didnt work...

Any ideas?

[Sai_Charan_K]

Hi @Donovan B ,

Did you try using gr.setWorkflow(false) and gr.autoSysFields(false) ?

If not then please use these in your fix script or background script so that you have the below things covered:

gr.setWorkFlow(false) - helps in doing data changes without triggering any underlying business rules.

gr.autoSysFields(false) - helps in doing data changes without updating the system fields.

Please mark this answer as "Helpful" if this helped you in anyway.

Thanks and Regards,

K. Sai Charan

Sr. ServiceNow Developer

Deloitte India

[Donovan B]

thanks for the idea, I tried that and it did suppress one of the items, the expense item, but it still adds the 2 CI deletions (one is Unknown)

[Sai_Charan_K]

Hi @Donovan B ,

Can you please provide the script so that I can check and revert back?

Thanks and Regards,

K. Sai Charan

Sr. ServiceNow Developer 

Deloitte India

[Donovan B]

Here is what I have so far, this does accomplish the main goal which is to delete a specific type of Peripheral, but like I mentioned above it puts an entry in the user record for every peripheral deleted, and some users have hundreds.

var duplicate = new GlideRecord('cmdb_ci_peripheral');
duplicate.addQuery('type', '=', 'Dock');
//duplicate.addNullQuery('serial_number'); // Add a query to check for blank serial numbers
duplicate.setLimit(10); // Set a limit of records to be processed
duplicate.query();
duplicate.setWorkflow(false);
duplicate.autoSysFields(false);

while (duplicate.next()) {
    duplicate.deleteRecord();
}

Thanks for the help!

Donovan