How to check if SQL is installed on any of my multiple windows servers

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  October 6, 2023 at 5:55 am

  #4302509

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

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  October 6, 2023 at 6:05 am

  #4302510

  Can I use a script to find that info please? Thx

• Jo Pattyn

  SSC-Dedicated

  Points: 32416

  More actions

  October 6, 2023 at 9:29 am

  #4302628

  System administrators usually have an inventory tool

  You could start with the Microsoft assessment toolkit https://www.mssqltips.com/sqlservertip/7428/microsoft-assessment-and-planning-toolkit-inventory-sql-servers/

  Scripting: probably using wmi

• Jo Pattyn

  SSC-Dedicated

  Points: 32416

  More actions

  October 6, 2023 at 9:31 am

  #4302629

  Scripting: using dba-tools https://docs.dbatools.io/Find-DbaInstance.html

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  October 6, 2023 at 5:52 pm

  #4302912

  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

  }

  }