Exclusion List in Clone Profile for User Table Not Working

green jason · ‎03-04-2025

I set the preserve conditions on the User, User_has_role, and Grmember tables, and also excluded these tables to prevent their data from being overwritten by the Source instance.

However, while the preserve conditions worked, the exclusions did not. Does anyone have any ideas on why this might be happening?

Shivalika · ‎03-10-2025

Hello @green jason

No, as I mentioned in my above answer it completely depends on conditions you specified in your preserved and exclude which data you want to keep and which data you want to hamper. So be very specific with handling conditions.

So when you said Domain A is in preserver - means it's data will be preserved and not overwritten but added if there is no excluder.

But if you have added excluder as well then this table will be excluded from clone alltogether means no data added or overwritten nothing. Data will be kept as it is for ONLY domain A. Not the same for domain B and Domain C or other whatever conditions of data.

I hope this clears your queries.

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwN

eEISQCY

View solution in original post

J Siva · ‎03-05-2025

Hi @green jason
Preserve list is used to prevent the data being overwritten by Production data.
Exclude list is used to prevent importing PROD data into Non prod instances.

So, Exclude property doesn't prevent data being overwritten.
Please verify the config again. If you configured properly, then it must be worked as expected.

green jason · ‎03-09-2025

Sorry, but what do you mean exclude property? I did not mention anything about Property, can you help to explain more clear. Thank mate

J Siva · ‎03-10-2025

I meant to say exclude list.

If you include any table in the exclude list, then no new data will be imported from the production.

Shivalika · ‎03-09-2025

Hello @green jason

Here is some clarification on what preserve and exclude means in servicenow -

Preserve - keep what data is already there on the target instance, but add to it.

Exclude : If no preserve, don't even bring data to the target instance, but instead make it empty.

If perserved, but excluded, then keep what is there, but don't touch it.

Now back to your question,

if you added preserve on these tables - then the data what is there will be there, and additionally you added exclusions also on these tables - then it will not be included in cloning and be left as it is.

Resultant, There should be no change on your tables if you have given the conditions also correctly.

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

Regards,

Shivalika

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY