Can anyone help me convert below SQL query to SWQL. Thanks in advance!!!
SELECT
Nodes.Caption AS NodeName,
Nodes.IP_Address AS IP_Address,
AVG(CPULoad.AvgLoad) AS AVERAGE_of_AvgCPULoad,
MAX(CPULoad.MaxLoad) AS MAX_of_MaxCPULoad,
AVG(CPULoad.AvgPercentMemoryUsed) AS AVERAGE_of_AvgPercentMemoryUsed,
MAX(CPULoad.AvgPercentMemoryUsed) AS MAX_of_AvgPercentMemoryUsed,
Nodes.NodeID AS NodeID,
Nodes.Category AS Category,
Nodes.ReportCode AS ReportCode
FROM
Nodes INNER JOIN CPULoad ON (Nodes.NodeID = CPULoad.NodeID)
WHERE
(Datepart(Hour,DateTime) >= '8' AND
Datepart(Hour,DateTime) <= '19') AND
(DATEPART(Month,DateTime) = '9' AND
DATEPART(Year,DateTime) = '2017' AND
DATEPART(Weekday,DateTime) not in (1,7))
AND
(Nodes.ReportCode = 'Core Switch' or Nodes.ReportCode = 'Data Center Distribution' or Nodes.ReportCode = 'MPLS Backhaul')
GROUP BY Nodes.Caption, Nodes.IP_Address, Nodes.NodeID, Nodes.Category, Nodes.ReportCode
ORDER BY ReportCode, NodeName ASC
