I want to create a custom dashboard showing netflow data (as a chart) for a particular interface for last 24 hours. I want to show netflow from router interfaces connecting to different sites. Can anyone help me with the query and how i can get it done.
I tried below query but it show me data for 24hrs which is not upto the current time. For example if current time is 9:00 AM the query will show last 24 hrs starting from 5:00 AM.
SELECT
timestamp as time,
NodeID as node,
InterfaceIDRx as Interface,
EgressBytes AS eBytes,
IngressBytes AS iBytes,
TotalBytes AS TotalBytes
FROM Orion.NetFlow.Flows AS flow
WHERE
nodeid = xxx and InterfaceIDRx = xxx
GROUP BY time,node,eBytes, iBytes,TotalBytes,Interface
Would appreciate if anyone could help me on this.