Linux server SWQL reporting

Question

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%'

i_like_eggs · Accepted Answer

The Swap space is located in the Orion.volumes table here is a snippet:

SELECT