I am working with my arch on designing remote pollers and we are trying to come up with a complete list of ports we need open on the remote side. We use app insights for SQL for example, does that use the agent to collect?
Yes, the Agent supports AppInsight applications. The only notable exception being SQL Clusters. These should be polled agentlessly. Agent requirements, including port/s used, are referenced in Administrator's Guide at the link below.
http://www.solarwinds.com/documentation/en/flarehelp/SAM/default.htm#samagorionagentreqs.htm