Home Forums Programming Powershell Query local SSMS server group with Powershell? RE: Query local SSMS server group with Powershell?

  • Well, if you can get the information out of the file, registered servers are stored in

    C:\Users\username\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml

    But I'd be much more tempted to set up my own text file or db table to store the server/database information.

    Easy enough once you've got the list to run your query in a foreach loop.