Skip to main content

SQL_Instances

Summary​

This document describes a method to gather all SQL instances installed on an endpoint.

Settings​

Detection StringComparatorResultApplicable OS
`%\{@powershell -c "$rp = 'HKLM://SOFTWARE//Microsoft//Microsoft SQL Server';$sb = [scriptblock]::Create('$in = gp -ErrorAction SilentlyContinue ///"$rp//Instance Names//SQL///"; ///"$((gp -erroraction silentlycontinue ///"$rp//$($in.$)//Setup///").Version) - $((gp -erroraction silentlycontinue ///"$rp//$($in.$)//Setup///").Edition)///"'); (((gp -erroraction silentlycontinue $rp).InstalledInstances)foreach -Process $sb) -join ', '"@%Regex^/d\\\{2,}./d\\\{1,}./d\\\{4,}./d\\\{1,}/s-/s/w*/s