I have a list of sql server deployed in different server and version in range from 11 to 19 and I need away to see when is the purchased license will expire? All these sql server are origination owned not personal use. Any help, please? It does not matter if its power shell script or through SSMS.
Here are what I have tried:
SELECT @@VERSION
SELECT SERVERPROPERTY('LicenseType') as Licensetype,
SERVERPROPERTY('NumLicenses') as LicenseNumber,
SERVERPROPERTY('productversion') as Productverion,
SERVERPROPERTY ('productlevel')as ProductLevel,
SERVERPROPERTY ('edition') as SQLEdition,@@VERSION as SQLversion
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0206e532-efe9-40d9-a5db-e2f0b759030d/sql-server-license-key-checking?forum=sqltools