Why would I use PowerShell when the information you need can be collected with T-SQL scripting. Maybe you could create the PowerShell and post the script?

Personally I'm not into PowerShell, feel like is a programming language for System administrators and Database administrators.