I was able to create a monthly SLA report using Thwack community but I am having issues trying to get my SLA report to show me the month. For instance, when i run the SWQL script I get sla availability for 1/1/2018 and 12/1/2017. I am trying to get the script to show my SLA availability for the whole month of January and only that month. So far this is the script i have that keeps adding 12/1/2017. Could someone point me in the right direction please?
This is my current config
SELECT n.Caption, sub_query.sla_day, sub_query.sla_availability, n.CustomProperties.time_from, n.CustomProperties.time_to FROM
(
SELECT avg(Availability) AS sla_availability, datetrunc('MONTH',datetime) AS sla_day, r.NodeID
FROM Orion.ResponseTime r
WHERE hour(datetime) >= r.Node.customproperties.time_from
AND hour(datetime)<= r.Node.customproperties.time_to
GROUP BY datetrunc('MONTH',datetime), r.NodeID
) AS sub_query
INNER JOIN Orion.Nodes n
ON n.NodeID=sub_query.NodeID
