Where can I get the provisioning date of an instance?

Albert Franques
Tera Contributor

Is there a query I can do to get the provisioning / installation date of an instance?

+ How can I know the first version it had   without having to go through the sys_upgrade table?

(not using HI )

thanks!

1 ACCEPTED SOLUTION

adilrathore
ServiceNow Employee
ServiceNow Employee

You need to check the Updated field of instance_id or instance_name property on sys_properties table.


View solution in original post

10 REPLIES 10

Did you check the Updated field of the instance_name property in System Property [sys_properties] table?


Hi Adil,



Thanks. Yes, the updated field works exactly the same as looking for it at the upgrade history, I get the same result (last zboot or installation date).



Kind regards,


Rajesh Mushke
Mega Sage
Mega Sage

Please Refer Below article might be helpful :



ServiceNow KB: Using the HI Service Portal (KB0547103)




Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke

tony_barratt
ServiceNow Employee
ServiceNow Employee

HI Albert,


On the instance you can go to the Upgrade history module and   filter on [From][is not][n/a] and get the upgrade info since the last zboot like so:


https://instance_name.service-now.com/sys_upgrade_history_list.do?sysparm_query=from_version!%3Dn/a%...



Screen Shot 2017-09-10 at 8.10.56 PM.png


OK, I think I see the problem now... I know an instance that is older than the first record that appears on the upgrade history (2014). But I think it was a zboot then, so that would be the reason. I understand then that there is no way to see when it was provisioned for the very first time, even in the case of later zboots. Perhaps in HI but I was interested to see it in the instance.



Thanks Anthony.