How to get the last cloned date/time of the "current" instance via server-side script?

doctorjim · ‎04-20-2017

I am needing to retrieve the date/time that the last clone was performed on the current (target) instance via server-side script. Is there some hidden System Property I can fetch with gs.getProperty() or by using some other means? The date/time only needs to be approximate (+/- 12 hours). Querying the Clone History table would be very easy on my Production instance except that I need to do this on a non-Production instance.

doctorjim · ‎05-04-2017

Thanks Matthew! Sorry for the delayed response. Great info.

I am now considering using the System Upgrades record shown below for determining the clone date/time.

This record is generated from the out-of-the-box Clone Cleanup Script shown below. I am hoping that this cleanup script will be around for the long hall so I can rely on the System Upgrade record it generates above. Do you have any concerns on the reliability of using this record?

I am actually using the Upgrade finished date/time value to retrieve a list of Customer Updates created since the last clone was performed. Here is the URL: sys_update_xml_list.do?sysparm_query=application=javascript:gs.getCurrentApplicationId()^sys_updated...

View solution in original post

BALAJI40 · ‎04-20-2017

it will be available in clone history, form here you get by gliderecord on that table and make query as last updated

System Clone > Clone History

check this for viewing clone history concept in the link,

http://wiki.servicenow.com/index.php?title=System_Clone#Viewing_Clone_History

doctorjim · ‎04-20-2017

Thanks, however our clones are performed from backups and therefore do not include the recent clone details recorded in the Production instance. I need to run the script on the target instance to determine when it was last cloned over.

Mwatkins · ‎04-20-2017

I looked for anything that is available out-of-the-box that could give you this information but couldn't find anything.

There's probably other ways to do this, but here is one way:

Create a Clone Cleanup Script that updates a custom Property you create with a date value.

doctorjim · ‎04-20-2017

Thanks Matthew. I considered such an approach, and may have to resort to that. But I'm trying to avoid such a solution. I even considered querying an Audit table to retrieve the oldest record (assuming the table is excluded from the clone) but that is not terribly reliable. Any other ideas are welcome!