Update date on all sys_reports set to the upgrade date of Yokohama

[Sean van Lier]

Hi All

We have an issue on our instance where all the reports in the sys_report table had their UPDATED date set to the same date and time when the Yokohama upgrade happened. I couldn't find information on this. Is there a way to fix this issue and revert the dates back?

Thanks in advance

[Ankur Bawiskar]

@Sean van Lier 

Did this happen to the custom ones also?

If it happens for OOTB then it makes some sense

Fortunately "sys_report" table is audited so you can get the previous date/time value and you can update it

Search your record into "sys_audit" table and you will have to write script for this

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

[Sean van Lier]

Hi Ankur, it happened to every report in the sys_report table, even the customer reports. I'll write a script if I need to but wondered if anyone else had perhaps raised this with ServiceNow and got a response. 

Update: Even though our sys_report table is audited, all these changes that were made by the updgrade weren't tracked. I'll raise a HI ticket for it.