Deletion of bulk records for the Legacy sn_hr_core_case_relations table

[Simanta27]

Hi everyone,

We are not using the legacy sn_hr_core_case_relations table in our instance anymore, but we have bulk records from the legacy sn_hr_core_case_relations table in our instance which was migrated in a data migration process, any idea on how can we delete these records? Background scripts or manual deletion is not working as it's unable to find the table in the instance.

Thank you in advance. 🙂

[Sayali Gurav]

Dou you want to delete all records or specific records from that table?

https://www.servicenow.com/community/platform-analytics-forum/delete-multiple-records-using-backgrou... - Refer this link for solution.

[Simanta27]

Specific records of that table.

[Sayali Gurav]

https://www.servicenow.com/community/platform-analytics-forum/delete-multiple-records-using-backgrou...- try this solution.

[Shaqeel]

Hi @Simanta27 

You can use script.

javascript

var gr = new GlideRecord('sn_hr_core_case_relations');

gr.addQuery('field_name', 'field_value'); // replace field_name and field_value with the actual field name and value gr.query();

while (gr.next())

{ gr.deleteRecord();

}

Kindly mark helpful/Solution.

Regards

Shaqeel