Update set clarification

tushar_ghadage
Tera Contributor

Hi All, 

If I want to check if some table gets captures in update set or not, 

how to check this?? 

(as its imp interview question)

 

thanks 

1 ACCEPTED SOLUTION

@tushar_ghadage 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

Nilesh Pol
Tera Guru
Tera Guru

@tushar_ghadage 

To check if changes to a specific table are captured in an update set, you can follow these steps:

  • Navigate to System Update Sets > Local Update Sets in the ServiceNow application navigator.
  • Select the update set you are interested in.

find the related list "Customer Updates" where you can see the list of all changes.

 

Note: data changes (i.e., records in tables) are generally NOTcaptured in update sets. This means that if you are making changes to the data within a table (like adding, modifying, or deleting records), these changes will not be included in an update set.

Update sets focus on capturing configuration changes rather than data changes, we also verifies the  dictionary attribute have value update_synch=true for your table.

 

Ankur Bawiskar
Tera Patron
Tera Patron

@tushar_ghadage 

Steps to check

1) go to sys_db_object

2) open collection type dictionary

3) if update_synch=true is there it means Table changes will get captured in update set

AnkurBawiskar_0-1759127966228.png

this is how it will look in update set once capture

AnkurBawiskar_1-1759128093535.png

 

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@tushar_ghadage 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Nawal Singh
Tera Guru

Hi @tushar_ghadage ,

 

Example Use Case (Interview-style):

Q: “Let’s say I created a custom table u_employee. How would I know if it gets tracked in an update set?”

Ans:

* I would navigate to System Definition → Tables, find the u_employee table.

* Then I’d open its record and check the Update Synchronization field.

* If it’s set to True, the changes will be tracked in the update set.

* If it’s set to false, then it won't be captured, and I’d need to handle it manually or change that setting.

 

If you found my response helpful, please mark it as helpful and accept it as the solution.

Thank you
Nawal Singh