8 Replies Latest reply on Jun 24, 2015 5:51 AM by Deltona

    Max Port Usage by Day Report (Web-based)

    Deltona

      Hi guys,

       

      I'm trying to build a report in the new web based reports but it is proving to be more difficult, the more time i spend trying to figure it all out.

      What i'm trying to achieve is creating a report that will provide the following bits of information:

       

      Custom Property.Location | Node Name | Number of Ports Active/Up (Max)

      Time-based by Last 24 hours

      Grouped by CP.Location

      Sorted by # Active Ports Descending

       

      Basically, how many ports have been found to be active in the past 24 hours per Node, per CP.Location.

      Example:

       

      Location                Node Name             Active Ports (Max)

      San Diego            SD-SW03.lab.com              12

       

      Any kind souls care to point me in the right direction?

      UDT v3.2.2

       

      TIA

        • Re: Max Port Usage by Day Report (Web-based)
          peter.ksenzsigh

          Thor,

          UDT still doesn't support the web-reporting so you need to use the old report writer for this.

          Peter

            • Re: Max Port Usage by Day Report (Web-based)
              Deltona

              Hi Peter,

               

              Thanks, that explains alot! Although i still need to create this report one way or the other, Report Writer is either missing selectable fields for UDT or the data i need just isn't there.

              I was using the UDT: Capacity report as baseline to build upon but can't select actual port count, only percentage of ports used.

               

              Here's what i got so far, though without Grouping by Custom Property or actual MAX Port Count.

               

              SELECT  TOP 10000 UDT_PortCapacity.NodeName AS NodeName,
              MAX(UDT_PortCapacity.PortPercentUsed) AS MAX_of_PortPercentUsed

              FROM
              UDT_PortCapacity

               

              GROUP BY UDT_PortCapacity.NodeName

               

              I can't find the table UDT_PortCapacity

               

              I did find UDT_PortUsage_Daily, which is almost exactly what i need but with Max port count instead of AvgPortCount.

               

              Would it be possible to create this type of report?