Need help to alter the SWQL query to get last month data

DN

Hello Friends,

I have working SWQL query which gets last month data with by manually feeding the date, I need help to alter the query to pick last month data automatically so that i can avoid changing the query every month.

I tried multiple queries but they are failing, not sure which function to use to get that data.

Here is my query. This query gives the average value of all the nodes for last month. Need help only on the date part on this query. Thanks in Advance 

SELECT
ROUND(AVG(Availability), 2) as AvailabilityAverage
FROM
Orion.ResponseTime as rt
JOIN
Orion.Nodes as n
ON rt.nodeid = n.nodeid
WHERE
n.customproperties.segmentation = 'Network'
AND rt.DateTime >= '2024-08-1'
AND rt.DateTime < '2024-09-1'

chad.every

It would probably look something like the following.

</code><pre class="code codeBlock" spellcheck="false" tabindex="0">SELECT ROUND(AVG(Availability), 2) AS AvailabilityAverage FROM Orion.ResponseTime AS rt JOIN Orion.Nodes AS n ON rt.nodeid = n.nodeid WHERE 1=1 n.customproperties.segmentation = 'Network' AND (MONTH(TOLOCAL(rt.DateTime)) = (MONTH(TOLOCAL(ADDMONTH(-1,GETUTCDATE()))))) AND (YEAR(TOLOCAL(rt.DateTime)) = (YEAR(TOLOCAL(GETUTCDATE()))))</pre><code>

This was taken from a SWQL query I have that tracks monthly WAN usage on one of my internet uplink. However, It is for the current month. I added the ADDMONTH(-1,X) to your query.

SELECT
    ROUND((SUM(InTotalBytes)/1024/1024/1024),1) AS [In Total GB]
    ROUND((SUM(OutTotalBytes)/1024/1024/1024),1) AS [Out Total GB]
    ROUND((SUM(TotalBytes)/1024/1024/1024),0) AS [Total GB]
FROM Orion.NPM.InterfaceTraffic i
WHERE i.Interface.Name = 'X'
    AND NodeID = 'X'
    AND (MONTH(TOLOCAL(DATETIME)) = (MONTH(TOLOCAL(GETUTCDATE()))))
    AND (YEAR(TOLOCAL(DATETIME)) = (YEAR(TOLOCAL(GETUTCDATE()))))