Recently I got a request where I have to check the SQL Server installation date and SQL Server authentication mode. I have write the below script and execute it against all the servers registered in CMS.
Here is the script
select createdate as InstallationDate ,
CASE SERVERPROPERTY('IsIntegratedSecurityOnly')
WHEN 1 THEN 'Windows Authentication'
WHEN 0 THEN 'Windows and SQL Server Authentication'
END as [AuthenticationMode],
SERVERPROPERTY('servername') as svrName
from master..syslogins where name like 'NT AUTHORITY\SYSTEM'
