http://powershell.com/cs/forums/230.aspxModerated by PowerShell MVP <a href="http://powershell.com/cs/content/experts.aspx#thomas-lee">Thomas Lee</a> and PowerShell expert <a href="http://powershell.com/cs/content/experts.aspx#jakub-jares">Jakub Jareš</a>enCommunityServer 2008.5 (Build: 30929.2835)http://powershell.com/cs/forums/thread/16180.aspxWed, 25 Apr 2012 13:38:25 GMTf421715f-7aba-45f0-8a8d-44de5318a3a7:16180Don Jones0http://powershell.com/cs/forums/thread/16180.aspxhttp://powershell.com/cs/forums/commentrss.aspx?SectionID=230&PostID=16180<p>Prior to Win8, there are no cmdlets for querying the firewall or modifying it. And prior to SQL2012 I&#39;m not aware of any that could be used to gather that SQL information. I&#39;m not a SQL PowerShell expert, though.</p><div style="clear:both;"></div>http://powershell.com/cs/forums/thread/16172.aspxWed, 25 Apr 2012 06:44:59 GMTf421715f-7aba-45f0-8a8d-44de5318a3a7:16172virtuallynothere0http://powershell.com/cs/forums/thread/16172.aspxhttp://powershell.com/cs/forums/commentrss.aspx?SectionID=230&PostID=16172<p>I am trying to find a way to use powershell to query a sql server and provide back the instance names with the port numbers used, then ideally get the port numbers and add them to specific rules I create for the Windows firewall.</p> <p>Currently I use the netsh commands for the firewall config and go to the gui to locate the ports.</p> <p>&nbsp;</p><div style="clear:both;"></div>