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.