What is the "update_guid" field used for?

[bonsai]

The "update_guid" in the update set data contains a sys_id.

Which record is this sys_id?

Which TBL is it managed in?

[Deepak Shaerma]

hi @bonsai 

update_guid field typically said as a sys_id that references to the record associated with the update that was captured in that update set.

What is the update_guid sys_id referencing?

update_guid is the sys_id of the record that was updated/inserted/deleted in the platform as part of the update set.
For example, if you changed a business rule, the update_guid would be the sys_id of that business rule.
also if you modified a UI policy, the update_guid would be the sys_id of that UI policy.

Which table does the update_guid point to?

It points to the actual record in the table where the update happened, not to the update set record itself.
For example:
Business Rule changes: update_guid references a record in sys_script table.
UI Policy changes: update_guid references a record in sys_ui_policy.
So, the table of the record the update_guid points to depends on the type of object that was changed.

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Deepak Sharma

[bonsai]

@Deepak Shaerma 

I checked, and the Update guid value "af5f6baf28212210ac516f33679faa67" in the following capture seems to be different from the sys_id in the update set data (system property [glide.login.home]).

sys_id in system property [glide.login.home]: b2520661c61122810109f28b849bc1a6

[Deepak Shaerma]

hi @bonsai 

Target name or Target table fields in the same sys_customer_update record usually contain the exact record or table that was updated.
Use the update_guid value to query sys_customer_update to find the record’s target.
Basically, update_guid is the id generated in the customer updates for reference the exact record to find out. the use is to just copy the update_guid and for a particular record, 
open your list of update set table and paste the guid in the filter to identify the record update.
Look at the Target name and Target table columns to find exactly which record or table was updated.
Table : sys_update_xml

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Deepak Sharma

[bonsai]

I tried searching for the [sys_update_xml] table but couldn't find it.