The most recent content from our members.
So had some great discussions at the SWUG covering a lot of SWQL ground. And one of my take-aways was that joins should be a rarity. Background: The team handling alerts was suffering from alert fatigue when I joined the team, and I only made it worse initially as I increased coverage by 300%. 95% of the alerts were coming…
I'm attempting to get a list of IPAM entries that need some attention and/or cleanup using the following: SELECT DISTINCT I.IPAddress , I.DnsBackward , O.Caption , O.IP_Address FROM IPAM.IPNode AS I LEFT OUTER JOIN Orion.Nodes AS O ON I.IPAddress = O.IP_Address WHERE I.Status = 1 AND ( I.DnsBackward LIKE '' OR…
I can do a regular JOIN or I can explicitly type LEFT JOIN, but if I type RIGHT JOIN or RIGHT OUTER JOIN I get "Unsupported JOIN Type "RIGHT" Yet, in the SWQL Studio "SQL Constructs Supported" section it specifically lists RIGHT OUTER JOIN as being supported. LEFT JOIN, LEFT OUTER JOIN, and INNER JOIN do work just fine.…
It looks like you're new here. Sign in or register to get started.