I have 100+ sql server instances (from sql 2005 to sql 2016) installed in my environment, is there a good way to find when an instance was initially installed?
I tried to check the [master] database creation date, and found (for sql 2012 onward at least) it is always Apr 8, 2003.
The only possible date is [msdb] creation date, which I see it changing for different sql server instances. (I am not sure about this is because I am not sure whether a service patch will change the [msdb] creation date?)
Is there any other reliable way that can indicate the sql server instance creation date? I am open to use of t-sql or powershell to figure it out.
Thanks in advance.