Just an option using the registry, I have found it can be quicker on some of my systems: $inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances foreach ($i in $inst) { $p = (Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL').$i (Get … Using PowerShell to discover information about your Microsoft … For more details, check the T-SQL: Get SQL Server Instance Information Using SERVERPROPERTY. This method works to retrieve the SQL Server product key from an existing installation on your client or Server machine. This information is stored in the HKeyLocalMachine hive of the registry. Can some guide how to check multiple KB patches on list of servers using powershell ? Open a Powershell window on your system "as administrator" Check the Powershell version: $psversiontable.Psversion I previously wrote a post about how you can Check/Get a list of BizTalk Server 2013 R2 Cumulative Updates installed in your machines (see here) and why we cannot rely on documentation if they exist, to be accurate, special regarding the status of the machines present in the environment. Open Windows 7 Registry Editor by typing and executing RegEdit in Run command. How to Check This can be imported as below from the PowerShell gallery. "c:\temp\secure_str.txt" can only be processed by the account that creates it and on the same computer where the secure string is created, i.e. SQLPS. Raw. I had to come up with this today when working with a SQL Server compliance item in SCCM 2012 using a script detection method. powershell.exe -command C:\ ServiceCheck.ps1. Install and Configure SQL Server using PowerShell $inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Micro... 1. Here is a version I cobbled together from some sources here and there*. This version does not hit the registry, does not hit SQL, and doesn't even...