Update Get-InstallationDate.sql

nullbind · web-flow · commit 54d73c340611 · 2022-12-26T16:59:48.000-06:00
diff --git a/templates/tsql/Get-InstallationDate.sql b/templates/tsql/Get-InstallationDate.sql
@@ -1,6 +1,5 @@
 -- Option 1: createdat FROM master.sys.syslogins 
--- $server.VersionMajor -ge 9
--- Tested version: 2022, 2016, 2014
+-- Tested version: 2022, 2016, 2014, 2012
 -- Requirements: sysadmin
 -- Reference: https://www.dbrnd.com/2016/03/sql-server-script-to-find-installation-date-time-and-authentication-mode/
 SELECT 
@@ -13,16 +12,21 @@ SELECT
 FROM master.sys.syslogins 
 WHERE name LIKE 'NT AUTHORITY\SYSTEM'
 
+
 -- Option 2: create_date FROM sys.server_principals
 -- $server.VersionMajor -ge 9
+-- Tested version: 2022, 2016, 2014, 2012
+-- Requirements: sysadmin not required
 -- Reference: https://github.com/dataplat/dbatools/blob/6cae0dd18bda3ad8efd60404c2d05b402cc4a785/functions/Get-DbaInstanceInstallDate.ps1
 /*
 $sql = "SELECT create_date FROM sys.server_principals WHERE sid = 0x010100000000000512000000"
 [DbaDateTime]$sqlInstallDate = $server.Query($sql, 'master', $true).create_date
 */
 
 -- Option 3: schemadate FROM sysservers
---$server.VersionMajor -le 9
+-- $server.VersionMajor -le 9
+-- Tested version: 2022, 2016, 2014, 2012
+-- Requirements: sysadmin not required
 --Reference: https://github.com/dataplat/dbatools/blob/6cae0dd18bda3ad8efd60404c2d05b402cc4a785/functions/Get-DbaInstanceInstallDate.ps1
 /*
 $sql = "SELECT schemadate FROM sysservers"
