Powershell query to find all SQL Instance names alone and export to .Txt

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 4, 2015 at 9:40 am

  #315882

  I am writing a query to find the SQL Servers which are all UP & Running. While doing so, I find that each instance has multiple SQL Instances. How to write a good powershell query to export all the SQL Instance details and export to Excel and .TXT so that at a next step I can check for tge ping status using win32_pingstatus Get-WMIObject class.

  Please suggest.

  Thanks in advance

  Thanks.

• Gary Varga

  SSC Guru

  Points: 82166

  More actions

  March 4, 2015 at 11:05 am

  #1781709

  How about you come up with an attempt and then we help you with specific issues?

  Gaz

  -- Stop your grinnin' and drop your linen...they're everywhere!!!