Trying if check if SQL is installed on my multiple windows servers

Question

I have about 200 windows servers. How can I check if SQL Server is installed on any of those servers? Thanks.

Answer 1

What for a script do you mean?

You can use the tool MAP = "Microsoft Assessment and Planning" to create an inventory, also with SQL Server informations.

See https://www.mssqltips.com/sqlservertip/7428/microsoft-assessment-and-planning-toolkit-inventory-sql-servers/

Answer 2

Hi @SQLDev,

Also check this thread to see if it is helpful.

https://stackoverflow.com/questions/42278128/how-to-check-if-an-application-is-installed-on-multiple-server-powershell

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Thanks everyone! How can I export the output to a csv file please? I tried the below export-csv -append -path but I don't see the servername and instancename columns being written to the output. Any ideas please? Thanks.

$SQLInstances = Import-Csv C:\server_test.csv |% { Invoke-Command -ComputerName $_.ServerName {
 (Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances
 }
 }
    foreach ($sql in $SQLInstances) {
       [PSCustomObject]@{
           ServerName = $sql.PSComputerName
           InstanceName = $sql | Export-Csv -Append -Path C:\output.csv -NoTypeInformation
       }
   }