2 Replies Latest reply on Dec 3, 2013 4:41 PM by matt.matheus

    UDT Port Usage Report

    matt.matheus

      I'm trying to create a report (or query) that will list the number of ports being used per NPM node.  Ideally this would only show the most current data and could be expanded or changed to show number of unused ports as well.  I attempted, unsuccessfully, to tweak existing reports to give me this data.  I'm able to generate a percentage, but this doesn't help me, as I'm trying to get an actual count so I can plan for expansion during our next network refresh project.

       

      Any help would be greatly appreciated!!

       

      Thanks,

      Matt

        • Re: UDT Port Usage Report
          dkeyser

          I was thinking you could just use something like this:

          SELECT Nodes.Caption

                , DateTime

                ,PortCount as 'Port Count'

                ,ActivePortCount as 'Active Port Count'

                ,(PortCount - ActivePortCount) as 'Inactive Port Count'

            FROM UDT_PortUsage_Detail

            join Nodes on Nodes.NodeID = UDT_PortUsage_Detail.NodeID

            where DateTime >= DATEADD(HOUR,-1,getdate())

          But I'm running into the issue where I'm seeing DateTime enteries in the future.

            • Re: UDT Port Usage Report
              matt.matheus

              I think I'll go with that, after a few minor alterations.

               

              SELECT Nodes.Caption

                    , DateTime

                    ,PortCount as 'Port Count'

                    ,ActivePortCount as 'Active Port Count'

                    ,(PortCount - ActivePortCount) as 'Inactive Port Count'

                FROM UDT_PortUsage_Detail

                join Nodes on Nodes.NodeID = UDT_PortUsage_Detail.NodeID

                where DateTime between '12-03-2013 13:30:00' AND '12-03-2013 14:30:00'

               

              I'm only going to run this report manually, so putting in the dates by hand won't be too bad versus having 24 lines per node to wade through.