Server Report in SWQL

Hello,

I am trying to put together a server report using SWQL. I do not have any documentation on tables/field names so I am flying blind. I need items 7,8, 9 in the swql statement below. Can anyone help me?

SELECT
n.NodeID,
n.DisplayName,
n.IPAddress, (Delete)
n.MachineType,
n.Interfaces.DisplayName AS InterfaceDisplayName
Average CPU Utilization %
Physical Memory Utilization %
Virtual Memory Utilization %
FROM Orion.Nodes n
ORDERBY n.NodeID

Or can anyone help me find a document that links tables and displays field names so I can stumble through this myself.

Find more posts tagged with

swql query

custom swql report

server

Accepted answers

dan_jagnow

There is schema documentation for Orion.Nodes here:

http://solarwinds.github.io/OrionSDK/2019.2/schema/Orion.Nodes.html

You could try something like this for the CPU and physical memory. I'm not sure about virtual memory.

SELECT
    n.NodeID,
    n.DisplayName,
    n.IPAddress,
    n.MachineType,
    n.Interfaces.DisplayName AS InterfaceDisplayName,
    n.CPULoad
    n.PercentMemoryUsed
FROM Orion.Nodes n
ORDER BY n.NodeID

All comments

dan_jagnow

There is schema documentation for Orion.Nodes here:

http://solarwinds.github.io/OrionSDK/2019.2/schema/Orion.Nodes.html

You could try something like this for the CPU and physical memory. I'm not sure about virtual memory.

SELECT
    n.NodeID,
    n.DisplayName,
    n.IPAddress,
    n.MachineType,
    n.Interfaces.DisplayName AS InterfaceDisplayName,
    n.CPULoad
    n.PercentMemoryUsed
FROM Orion.Nodes n
ORDER BY n.NodeID

mesverrum

The best way to stumble through these is just to install SWQL studio on your workstation and use it to connect to the orion sever with your normal orion logon credentials. Then you can browse all the tables and come up with queries. Trying to do it without SWQL studio is hugely painful, nearly impossible.

padnaram

Thank you! We are putting the cart before the horse. Reports first and maybe or maybe not support.