jpann
/ Get-SqlServerKeys.ps1
Last active
January 24, 2024 18:11
— forked from mtrimarchi/Get-SqlServerKeys.ps1
Get-SqlServerKeys with support for SQL Server 2019
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Function Get-SqlServerKeys { | |
| <# | |
| .SYNOPSIS | |
| Gets SQL Server Product Keys from local and remote SQL Servers. Works with SQL Server 2005-2019 | |
| .DESCRIPTION | |
| Using a string of servers, a text file, or Central Management Server to provide a list of servers, this script will go to each server and get the product key for all installed instances. Clustered instances are supported as well. Requires regular user access to the SQL instances, SMO installed locally, Remote Registry enabled and acessible by the account running the script. | |
| Uses key decoder by Jakob Bindslet (http://goo.gl/1jiwcB) | |