StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POjoin more than 2 tables using SWQL(SolarWinds Query Language) when there is no common field?
text
Body
copied!<p>I am monitoring my node using SolarWinds Orion NPM (network performance monitoring). And I am using Orion SDK for getting alert information from SWIS (SolarWinds informarion Service) into vb.net console application. </p> <p>I am using some vb.net code:</p> <pre><code>Function GetOneAlert(ByVal swis As InformationServiceClient) As AlertInfo Dim query As String, result As XElement query = "SELECT TOP 1 A.AlertDefID, A.ActiveObject, A.ObjectType FROM Orion.AlertStatus A WHERE A.Acknowledged=0 ORDER BY A.TriggerTimeStamp DESC" result = swis.QueryXml(query) </code></pre> <p>The problem is, I want to get <code>alertinforamtion</code> from three tables named <code>Orion.AlertDefinitions</code>, <code>Orion.AlertStatus</code> and<code>Orion.Nodes</code> in <code>swis</code> (SolarWinds Information Service) and I need to join these 3 tables but I can able to join 2 of them (<code>Orion.AlertDefinitions</code>, <code>Orion.AlertStatus</code>) using <code>swql</code> (SolarWinds Query Language) query shown below</p> <pre><code>query = "SELECT AlertStatus.AlertDefID, AlertDefinitions.AlertDefID, AlertDefinitions.Name, AlertStatus.State, AlertStatus.ObjectName, AlertStatus.TriggerTimeStamp, AlertDefinitions.Description FROM Orion.AlertStatus INNER JOIN Orion.AlertDefinitions ON AlertStatus.AlertDefID=AlertDefinitions.AlertDefID WHERE AlertStatus.Acknowledged=0" </code></pre> <p>I know the alert details but i don't know the alert belongs to which node. For this purpose i need to join "orion.node" table with the remaining tables. But 3rd table (<code>Orion.Nodes</code>) has no common field(s) in anyone of other two tables to join. I need to get three field values named as <code>DNS</code>, <code>IPAddress</code>, <code>NodeDescription</code> from <code>Orion.Nodes</code> table.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload