SWQL local variables

Hello. I have a question about using local variables/macro with SWQL queries.

It can be named differently, so let me explain what I mean.

For example, I want to add Custom Query widget on the NodeDetails page with Last Boot history info (last 10 events).

What's why I use this template:

SELECT TOP 10 EventTime, NodeID, Message, Acknowledged
FROM Orion.Events 
INNER JOIN Orion.Nodes ON events.NetObjectID = nodes.nodeid;
WHERE NodeID='xxx';
ORDER BY EventTime DESC

But instead of 'xxx' I want to put in NodeID of current host (if user opens NodeDetails page of Node with "NodeDetails=100", xxx must be replaced with "100" and show info about current openned node).

Find more posts tagged with

query

custom queries

SWQL

Accepted answers

All comments

christopher.t.jones123

the ${ID} variable pulls the ID of the object the details page is currently looking at

mesverrum

The trick to knowing what variables are available on a details page is to just look that the corresponding SQL database table for that object type. So for a node open the DB and every column on the Nodes table is a variable you can use, for an interface it would be the Interfaces table.

That applies to almost all of the details view types. If i recall correctly, i have run into a few exceptions in IPAM/UDT where it seemed like no variables were able to be used for some of the details pages.

omavel

I think, it must be ${NodeID}

omavel

Thank you