0

I need to be able to search for SQL objects (logins, etc). With a smaller number of servers, I would connect to them all via a registration group in SSMS and do the search.

Does anyone have a better way with a large number of instances?

Thanks

Alonzo Hess
  • 13
  • 4

1 Answers1

1

You can use SQL Power doc for this .

SQL Power Doc was written by Kendal VanDyke. It is a command line PowerShell manifest consisting of several PowerShell modules that will help you build a solid foundation to Discover, Document and Diagnose SQL Server instances and Windows Operating system details. Additionally, you’ll gain some insight into what directions you can go for future exploration. It basically invokes PowerShell cmdlets and give you the necessary details front and center.

How to use has been described here

You can just filter out in the report for the objects you want or even before executing PS you can adjust the parameters as needed.

KASQLDBA
  • 7,203
  • 6
  • 30
  • 53