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