SELECT

SERVERPROPERTY(‘ProductVersion’) AS “Sql ProductVersion”,

SERVERPROPERTY(‘ProductLevel’) AS “Sql ProductLevel”,

SERVERPROPERTY(‘Edition’) AS “Sql Server Edition”;

select
create_date as ‘SQL Server Install Date’,
DATEADD(DD, 180 , create_date) as ‘SQL Server Expiry Date’
from sys.server_principals
where name = ‘NT AUTHORITY\SYSTEM’