SWQL query to fetch raw cpu and memory report

veera.sivareddy

"I need a SWQL query to generate a raw report of CPU and memory utilization for devices that have surpassed the 85% threshold in the past 30 days."

yaquaholic

Have you had a look at https://github.com/solarwinds/OrionSDK ?
It's got a wealth of knowledge and documentation around SWQL.

But while you're reading the docs, here's a quick and dirty starter to get you going.

SELECT n.Caption, 
       n.CPULoadHistory.AvgLoad,
       n.CPULoadHistory.AvgPercentMemoryUsed,
       n.CPULoadHistory.DateTime 
FROM Orion.Nodes as n
WHERE ( n.CPULoadHistory.AvgLoad > 85
   OR n.CPULoadHistory.AvgPercentMemoryUsed > 85 )
AND n.CPULoadHistory.DateTime > ADDDAY(-31, GETDATE())
ORDER BY n.CPULoadHistory.DateTime DESC

Get yourself the SWQL Studio from the Orion SDK, paste that code in and start exploring 

You will find that if you ask a really generic question, such as above, people won't answer as it sounds like you maybe haven't looked at the documentation or around Thwack. 
But if you ask a specific question, they'll jump on it. 
¯\_(ツ)_/¯