0 Replies Latest reply on Jan 18, 2016 4:58 AM by valter

    Table to access Peak_Transmit / Peak_Received columns

    valter

      Hi all.

       

      I need to create a report to produce, among other fields, the Peak_Transmit / Peak_Received for some elements, in the last 12 months, using SWQL.

       

      So far i´ve had success displaying Node Name, Interface Name, Interface Caption and Speed using the following query:

      select I.Node.DisplayName, InterfaceName, I.Caption, round(Speed/1000000000,0) as Speed_Gbps

      from Orion.NPM.Interfaces I

       

      Does anyone knows how can i add the columns Peak_Transmit and Peak_Received (in the last 12 months) to this query or if i need to search in a different table?

       

      Thanks in advance.

       

      Valter