Is there a way to export skipped records in Upgrade Monitor to excel?

sterrell24
Mega Expert

When we go to Upgrade Monitor then click the link to review skipped records, the normal list export option on the list is not available. Is there a way to export all of the records to excel?

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

Hi Jeromy,



The answer is 'yes', you can export this because it's in a table. The table you are looking for is sys_upgrade_history_log. Type sys_upgrade_history_log.list in the application menu filter and you can get an entire list of all records that you can then filter to your choosing (e.g. for the latest upgrade.)


View solution in original post

8 REPLIES 8

Thanks for posting.

Just wanting to update this for New York as one of the choices has changed, you'll want your query to look like this, which netted us the same result:

find_real_file.png

 

disposition=4^ORdisposition=9^upgrade_history=785ce522db333300e20c2736059619d3^changed=true

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Les1
Tera Guru

Is this information still valid in Orlando? i'm seeing behavior that doesnt seem to let me do the suggestion.

 

when i bring up the upgrade log, the Upgrade History column shows like this:

find_real_file.png

When i try to filter on Upgrade History = (our last orlando upgrade) it results empty.

find_real_file.png

Maybe i'm just doing something wrong but i thought i'd performed these steps in past versions so am just confused 

 %)

kkswamy
Tera Expert

@Chuck Tomasi @Pradeep Sharma  Is there any way to export only the "skipped changes to review" records only from the upgrade monitor in Orlando release?

Please see the attachment.

 

perkinsarm
Mega Guru

It is still possible to export the skipped updates in Orlando. See Chuck's original comment for the table to use and my comment from a few years ago for suggestions on what criteria to specify.

We are preparing our upgrade to Orlando and did this last week.Since our skipped updates have changed over time we now have a few additional 'Skipped ...' disposition types, I had to slightly modify the search criteria from my previous example to get he same skipped items that appeared in the Upgrade Monitor.

If your upgraded instance has been patched since upgrade the Upgrade Monitor will probably show no skipped upgrades. In that case view Upgrade History to determine which Upgrade history to use in your filter (Hint: filter on Changes Skipped > 0). 

 

Filtering the sys_upgrade_history_log table:

find_real_file.png

The revised query filter:

upgrade_history=3dfae2001b3110109e54ea4ce54bcbc3^disposition=4^changed=true^NQupgrade_history=3dfae2001b3110109e54ea4ce54bcbc3^disposition=9^NQupgrade_history=3dfae2001b3110109e54ea4ce54bcbc3^disposition=10^changed=true