6 Replies Latest reply on Oct 17, 2019 11:31 AM by ralexander

    Switch Port Report

    emunizaga

      I need to show a report of all the switch ports in our environment.  All switch ports are not in NPM but they are in UDT.  Is there a way to get this info and show a total number at the bottom?  Thanks.

        • Re: Switch Port Report
          tony.johnson
          1 of 1 people found this helpful
          • Re: Switch Port Report
            ralexander

            Just curious - do you have NCM? This will allow you to report on every switchport via the NCM Inventory

            1 of 1 people found this helpful
              • Re: Switch Port Report
                emunizaga

                I do have NCM.  How would I do that?  Thanks.

                1 of 1 people found this helpful
                  • Re: Switch Port Report
                    tony.johnson

                    UDT is required to poll and report on the port status and utilization over time.

                    1 of 1 people found this helpful
                    • Re: Switch Port Report
                      ralexander

                      Assuming you have all your nodes in NCM and a scheduled "Network Inventory" job running on them (I think there's a "Nightly Network Inventory" job by default in NCM > Jobs)

                      You should be able to create a report on the following:

                      (Site_ID is one of our custom properties so we can run the report on just one site if we wanted to. Omit it for all sites)

                       

                      Then make a custom table with the following database columns (or whatever you want to see):

                      Node/Caption
                      Interfaces/Interface Names
                      Interfaces/Interface Description

                      Interfaces/Interfaces Alias

                      Interfaces/Operational Status

                      Interfaces Last Change

                       

                       

                      When ran, or better yet, when emailed as a csv file, you get the following information for every Ethernet switchport:

                       

                      The colours have been manually added using conditional formatting in Excel to show UP ports (green) and DOWN ports (red).

                      The "Last Change" column tells you how long ago the port went up or down, this comes directly from the switch's own stats, not from Solarwinds DB

                      I have this report run daily and emailed to me so if someone ever asks me for capacity in a site, I can easily see which switches are under-utilised or at max etc.

                       

                      Not sure if this is the sort of thing you're looking for but its one way we do things. We don't use UDT.
                      You do NOT have to monitor every single port in NPM because this info is collected from the devices using the Inventory job.

                      1 of 1 people found this helpful