Excluding tables from system clone

[adrianblakey]

Hi - we've been asked to exclude all our HR module data (hr cases, tasks, attachments etc) from our sytem clones

I understand from the documentation that you cannot exclude a table inherited from the task table.

https://docs.servicenow.com/bundle/istanbul-servicenow-platform/page/administer/managing-data/task/t...

THe queston is whether anyone has found a way to only partially exclude data from the task table (i.e. where task type is HR task or HR case)?

I've just spent the whole day running a background script to delete the data after the clone, and I think this will become more of a time issue hte more data is intered ito our system.

Also, I added a simple exclude on the sys_attchments table which doesn't seem to have worked either..

Has anybody encountered or overcome anything like this?

[adrianblakey]

HI - no way to exclude form the clone, I think this is because you cannot exclude tables that are inherited from the Task table. I've been running a post-clone script to remove cases , tasks, any remaining attachments and metrics.

// clean out HR case and HR task tables
new GlideTableCleaner('hr_case', 1, 'sys_created_on').clean();
new GlideTableCleaner('hr_task', 1, 'sys_created_on').clean();

// delete any remaining attachments
  var gratt = new GlideRecord("sys_attachment");
  gratt.addQuery('table_name', 'IN', 'hr_case, hr_task');
  gratt.query();
  gratt.deleteMultiple();

// delete any metrics for HR cases or HR tasks
  var grmtr = new GlideRecord("metric_instance");
  grmtr.addEncodedQuery('definition.table=hr_case^ORdefinition.table=hr_task');
  grmtr.query();