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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.