Tracing a table create to a specific update set

[lentzm1]

If you do a  sys_db_object.list and find a table(s), a custom table, not an out of the box/default table, and you want to track its creation and any/all updates after creation to an Update Set sys_id, how would I do that?  I would like to track down the specific update set ID - and then connect it to a JIRA request (if properly related) to find out who (which business unit and which person/team) requested it.   I want to figure out the purpose of the table and use within the ServiceNow space.  The table could be Global or Scoped - I really don't distinguish for my mission - I want to chase why folks created tables "X", "Y" or "Z" - and then, figure out which internal utilities leverage it.  (Glides, Includes, Fix Scripts, Workflows, Flow Designer, Business Rule, UI Policy....whatever).  Actually, I'd ultimately like to create a utility (script) that refreshes and logs all of this info into another table...or a report, if it's that simple.

[Bert_c1]

Hi @lentzm1,

You can get the sys_id value of the sys_db_object record then search sys_update_xml for name = 'sys_db_object_[sys_id_value]' and then view the value of the "Update set". I can't help with Jira integration. Nor determine where that table is "leveraged".

[lentzm1]

Excellent - That worked to get me any/all update sets that have anything to do with the sys_id (table)

Thank you - 

Two more things:   Yeah, the JIRA "link" would be nice - but I think that my next critical piece is now to find any place where this sys_id is leveraged (used or referenced)

[Bert_c1]

Hi lentzm1,

you can query the sys_update_version table too, that shows a "version history". the 'Source' field shows the Update Set. Perform a Google search for "Global Script search" script that you can use in Scripts Background.  do the same for Jira integration.

[lentzm1]

Also found the answer to my other question - It looks like this SN utility will get me where I need to go - (data mining and researching.....)

"slashcommands"