SWQL: Totalbytes transferred this/last month?

Question

Hi, I'm trying to generate a chart showing the total number of bytes transferred over specific interfaces on a monthyly level. I can grab this info from Orion.NPM.Interfacetraffic. I'm having trouble figuring out how i can sum all the bytes based on the time stamp though. 
 
 My query is: 
 SELECT DATETRUNC('month', DATETIME) AS MonthOfYear, SUM(TotalBytes) AS Sumbytes FROM Orion.NPM.InterfaceTraffic ONIT WHERE ONIT.Interface.Node.CustomProperties.Site LIKE 'AWS' GROUP BY DATETIME 
 
 I think i'm on the right track, but i have no experience writing SQL let alone SWQL. Any help would be much appreciated.

KMSigma.SWI · Accepted Answer

SELECT DATETRUNC('month', DATETIME) AS MonthOfYear
 , SUM(TotalBytes) AS Sumbytes
FROM Orion.NPM.InterfaceTraffic AS ONIT
--WHERE ONIT.Interface.Node.CustomProperties.Site LIKE 'AWS'
GROUP BY DATETRUNC('month', DATETIME)
ORDER BY DATETRUNC('month', DATETIME) 
 I don't see how that's possible. I'm running the above query and getting this result (I don't have a custom property, so I'm pulling everything for all interfaces in a small lab).

SWQL: Totalbytes transferred this/last month?

Top Replies