What are the entries or tables stored in update set, as per servicenow core and ITSM perspective?

[Priyam Sharma]

What are the entries or tables stored in update set, as per servicenow core and ITSM perspective?

[EssakyM]

Hi @Priyam Sharma 

• sys_update_set stores the Update Set record itself. [servicenow.com]
• sys_update_xml stores the actual customer updates (tracked configuration changes) and is the table used to track what was captured in an Update Set
  

  Each record in sys_update_xml represents a configuration change captured by the platform.

  Examples:

  Platform/Core Configuration

  • Tables (sys_db_object)
  • Dictionary entries (sys_dictionary)
  • Choice values (sys_choice)
  • Form layouts
  • Related lists
  • Application menus
  • Modules
  • ACLs
  • UI Pages
  • UI Actions
  • UI Policies
  • UI Scripts

  Development Components

  • Script Includes
  • Business Rules
  • Client Scripts
  • Notifications
  • Email Templates
  • Scheduled Jobs
  • Flows and Subflows
  • Workflow definitions

  ITSM Components

  • Catalog Items
  • Record Producers
  • Catalog Variables
  • Variable Sets
  • Assignment Rules
  • SLA Definitions
  • Change Models
  • Incident Forms
  • Problem Forms

  These are configuration records tracked because the underlying tables have update tracking enabled (update_synch) or special handlers configured. [servicenow.com], [servicenow.com]

  
  

  Please accept the solution if it assisted you with your question & Mark this response as Helpful.

  Regards

  
  
  

[Ankur Bawiskar]

@Priyam Sharma 

not just ITSM this is a generic platform feature

Whichever table has update_synch=true in Collection type Dictionary table, records for that table are captured in update set

Checking which records will be captured within an Update Set 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Priyam Sharma 

Just following up to see whether my suggested link worked for you. If you're still facing any issues, I'd be happy to help further.

[Tanushree Maiti]

Hi @Priyam Sharma 

Primary Update Set Tables

•  (sys_update_xml): The core table that stores the actual entries—such as Business Rules, UI Policies, Client Scripts, form layouts, and table schema alterations—as XML records.
•  (sys_update_set): Stores the parent update set records that group the individual XML entries together

Following components gets captured in update set :

• Business Rules, Client Scripts, and Script Includes
• Table schemas, new fields, and dictionary modifications
• Forms, Lists, Views, and layout changes
• Access Control Lists (ACLs) and security rules
• Workflows, Flows, and UI Actions
• System properties and Choice lists