Has anyone figured out how to get swap data for your server reports using SWQL. We are just beginning to write our reports and this is what I have so far:
Select
hc.Caption,
HC.TotalMemory,
hc.cpuload,
hc.cpucount,
HC.PercentMemoryUsed,
c.avgpercentmemoryused,
c.DateTime,
c.avgload,
c.MaxLoad,
c.minload,
c.MaxMemoryUsed,
c.avgmemoryused,
c.minmemoryused
from ORION.NODES HC
Inner JOIN ORION.CPULoad C on C.NodeID = HC.NodeID
where ToLower(hc.caption) like 'd%'