How to Convert SWQL to SQL?

Greetings all,

I am very new to using SQL and am still having trouble wrapping my head around it. As you can see, that would be one of the main issues when trying to take the reigns at SWQL. As a rule of thumb, what is the best way to convert SWQL to SQL or vice-versa?

My objective is to pull data from my SolarWinds Database into the data visualizer Grafana via a Microsoft SQL plugin. Down below is the SWQL script I plan on starting with:

SELECT COUNT ([AlertObjects].AlertConfigurations.Severity) AS [Severity]
FROM Orion.AlertObjects AS [AlertObjects]
WHERE [AlertObjects].EntityCaption LIKE '%SQ75%' AND [AlertObjects].AlertConfigurations.Severity = 2 --CRITICAL--
AND [AlertObjects].AlertActive.AlertActiveID > 0

Find more posts tagged with

swql query

grafana

sql

SWQL

npm

Accepted answers

All comments

adam.beedell

No perfect short answer for this one, though a fair few posts on the topic

Basically going from SWQL to SQL you'll have to add joins for every time you change table. The datetime functions are a bit different, and you get a load of new commands.

SQL to SWQL, drop most joins you wont need em. Drop almost all T-SQL. Drop any Write operations. Check the github page for what's left over.

Note part of the point of SWQL vs SQL is so the SW devs can move stuff around in the DB without breaking everyone's stuff. So beware of that in SQL

yaquaholic

I think it looks something like this....

SELECT COUNT(AC.Severity) AS [Severity]
FROM [dbo].[AlertObjects] AS AO

INNER JOIN [dbo].[Nodes] AS N
ON N.NodeID = AO.RelatedNodeID

INNER JOIN [dbo].[AlertConfigurations] AS AC
ON AC.AlertID = AO.AlertID

INNER JOIN [dbo].[AlertActive] as AA
ON AA.AlertActiveID = AO.AlertID

WHERE N.Caption LIKE '%Derek%'
AND AC.Severity = 2
AND AA.AlertActiveID > 0

I hope it helps...