How to clone exclude a group of tables? ie. All the archive tables.

[Luiz Guilherme]

We have identified that archive tables are being cloned during the clone process, which generates hundreds millions of data that should never be cloned to a sub-prod instances. Once identified the issue we start to understand how to clone exclude all the archive tables and we were told by ServiceNow team that the only way to clone exclude a table is listing one by one, which is truly a massive work to list one by one of the archive table and also which will require a workload to keep a track on any new archive table that comes up.

This doesn't seem to be a smart solution and neither feasible. All tables from archive starts with "ar_" and following simple it rules it should be reasonable to have something like clone exclude "ar_*", which doesn't work as we have tried it without success.

Therefore I please ask help from the community on how to solve this problem or may be have the community support on an idea to have ServiceNow implementing a solution for this.

ps: Cleaning Script or Cleaning API should not be a solution.

Thank you,

[GusPosadaFlorez]

Hello @Luiz Guilherme  ,

Use "ar_.*"

You can use wildcards to exclude several tables from cloning with one entry. For example, sys_script.* excludes all tables starting with sys_script.

Follow the link https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/managing-dat...