Clone tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2019 07:58 PM
Hi Everyone,
This is the first time i am raising the request for cloning DEV and TEST .
Here rather than OOB tables , what list of tables i have to include in exclude tables.
We are having LDAP integration which we use for AD and sccm so what tables i have to exclude.
Other than this which list i have to add as apart of system configurations along with that i would like to know as i need to know is it mandatory to make all the users inactive ?
I have gone through few community answers , iam unable to understand it clearly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2019 08:26 PM
Hi,
1->You should be able to do an Export XML to get the records and all meta data on that table.
Exporting Data - ServiceNow Wiki
2->To what I understand is that you cannot exclude a table inherited from the task table.
The System Clone > Exclude Tables module lists the tables that are not copied during a system clone. By default, the system excludes tables for logging, auditing, notifications, and license usage.
The system cannot exclude tables that extend the Task table and are also flattened into it as part of the table per hierarchy extension model. Since these extended tables are actually part of the same physical database table, the system clones the data when it clones the Task table. You can exclude tables that extend the Task table under two conditions. Either the system stores the tables in their own physical tables as part of the table per class extension model, or you exclude the Task table itself.
To preserve the existing data on the target instance, see Create a data preserver. Data on tables that reference the table, such as business rules, is not excluded.
Source: Link
Please mark reply as Helpful/Correct, if applicable. Thanks!