SQLPS.exe (PowerShell mini-shell) means business. You want a quick way to get information about your SQL Server logins, then here it is:
1: cd SQLServer:\SQL\YourSQLServer_Name\Default_or_YourSQLinstance_Name\Logins
2: dir
TWO LINES…. is that GREAT!!
The more you discover how productive PowerShell can be, then you go crazy and want to learn more. Hey!! Learning to use SMO with PowerShell add more ammunition to your scripting arsenal.
Here’s a screenshot showing the logins results:
Now, to keep growing these two liner… you could add the list of SQL Server and do a “Foreach” cmdlet to build a nice report.
This is just a starting point to start using SQLPS and extending it with PowerShell v2.
Enjoy!!