2 Replies Latest reply on Jan 21, 2015 11:52 AM by tjreeddoc

    Report of the current Application and Service Ports monitored by NTA?

    tjreeddoc

      All,

       

      Looking at Application and Service Ports (Settings>NTA Settings>Application and Service Ports), I can view all the current application which NTA is monitoring.  Is there an easy way to export this information to an Excel spreadsheet?

       

      Thank you,

       

      T.J.

        • Re: Report of the current Application and Service Ports monitored by NTA?
          ice

          There is no way on the web console. But work-around is:

           

          1. Remote access your Orion server
          2. Start >> All programs >> Solarwinds Orion >> Advance Features >> Database Manager
          3. Add default server >> Expand your database >> Look for the table NetFlowApps >> right click and query table
          4. Click Execute query >> there is a column that says AppName >> Copy and paste it to your spreadsheet

           

          for its port per application you will see on that same table AppID column, then go to the NetFlowAppPorts and copy the Ports column, that match it as both table is sorted per AppID.

            • Re: Report of the current Application and Service Ports monitored by NTA?
              tjreeddoc

              ICE,

               

              Thank you!

              The steps you gave me really helped out.

              I tweaked them to meet my SolarWinds Orion environment.

               

              1. Access the Application and Service Ports (Settings>NTA Settings>Application and Service Ports)

              2. Record the number of Applications NTA is monitoring.  (On 1-21-2015 it was 5927)

              3. RDP to your Orion server

              2. Access the Database Manager (Start >> All programs >> Solarwinds Orion >> Advance Features >> Database Manager)

              3. Add default server (Click Add default server )

              4. Expand Your database (Click the + in front of NetPerMon)

              5. Search for NetFlowApps, right click NetFlowApps, and query table

              6. Change the default records returned from 1000 to whatever the number found in step 2. (On 1-21-2014 it was 5927)

              7. Click Execute query

              8. Click Export to CSV

              9. Save the CSV file