- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2017 04:01 AM
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2017 04:14 AM
You need to check the Updated field of instance_id or instance_name property on sys_properties table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2017 04:14 AM
You need to check the Updated field of instance_id or instance_name property on sys_properties table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2017 05:47 AM
Hello Albert,
Please Navigate to Stats.do
You will get every information about instance like instance build date and current version instance and current patches etc.....
Please verify and let me know if you need more help...
If you are satisfied with my response, please mark my response as Like & Helpful and mark as correct based on your impact.
Thanks in advance.....
Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2017 07:44 AM
Hello Albert,
Please Follow below screen shot :
Thanks,
Rajashekhar Mushke
Rising star : 2022 - 2024
Community Leader -2018
Connect me on LinkedIn : Rajashekhar Mushke
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2017 09:59 AM
Hi Rajesh,
thanks, but this is the installation date of the release/version/patch. I was looking for the provisioning date of the instance, that is, the very first date it was installed and all the history of versions behind.
regards,