DateTime Logic for SWQL

Did you look at Date/Time Functions on the Orion SDK wiki?

Yes, and frankly it just frustrates me that SWQL is so similar, yet different.

What are you specifically looking for?  I'm seeing minutes and months above, but I'm not 100% what the WHERE clause should show.  (Sorry - I'm only an accidental SQL person)

He said 'Last month, so maybe:

SELECT i.INTERFACEID,i.OutPercentUtil,i.Datetime
FROM Orion.NPM.InterfaceTraffic i
--WHERE i.interfaceid = '10075' AND ((i.DateTime BETWEEN DATEADD(MONTH,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) AND DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) <- SQL
WHERE i.interfaceid = '10075' AND (i.DateTime BETWEEN (adddate ('month',-1,GETDATE())) and GETDATE()) -- <- SWQL
ORDER BY DATETIME DESC

SELECT i.INTERFACEID,i.OutPercentUtil,i.Datetime
FROM Orion.NPM.InterfaceTraffic i
--WHERE i.interfaceid = '10075' AND ((i.DateTime BETWEEN DATEADD(MONTH,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) AND DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) <- SQL
WHERE i.interfaceid = '10075' AND (i.DateTime BETWEEN (adddate ('month',-1,GETDATE())) and GETDATE()) -- <- SWQL
ORDER BY DATETIME DESC

Ah - I was curious if you wanted 'this past month of time" (April 4 - May 4) or "last month" (April 1 - April 30).

Yup, last month. So in the example above, The OutpercentUtil for Interface 10075 between April 1 and April 30.

I think this is the logic you'd want for the WHERE clause:

SELECT i.InterfaceId
     , i.OutPercentUtil
     , i.Datetime
     , AddDate('month', -1, GETDATE()) AS [OneMonthAgo]
     , DATETRUNC('month', AddDate('month', -1, GETDATE())) AS [BeginDate]
     , DATETRUNC('month', GETDATE()) AS [EndDate]
FROM Orion.NPM.InterfaceTraffic AS i
WHERE DateTime BETWEEN DATETRUNC('month', AddDate('month', -1, GETDATE())) AND DATETRUNC('month', GETDATE())
  AND i.InterfaceId = 1119
ORDER BY DATETIME DESC

That works, thank you!

Sure thing.  Glad to have helped.  The DATETRUNC and DOWNSAMPLE functions have amazing capabilities - I've only just started working with them.