I got another great comment today on the last two posts: Good article today on searching out SQL servers with PS. The combination of your and Ben’s methods work best though. In Ben’s example, you have to pull back all the Win32_Service objects and then are filtering locally
Here is the original post:
… and yet another way to find SQL Server Instances with PowerShell …