-
SWQL query UnDP with custom property on Node
I'm trying to write a swql query that combines 4 universal Device pollers with a custom property on a node. One of the UnDP's is collated to a custom property that is attached on a Node. I want to state again the node has the custom property but one of the UnDP's has the same value as the custom property. I need to know…
-
Need to join two tables
Both queries give me the results I need in separate tables, now I just need help with the formatting and syntanx for it to work properly in ONE table. Can anyone help me out with this join? SELECT n.FullyQualifiedName,n.ApplicationAlert.ApplicationAvailability AS…
-
How to get Routers\Switch information with Service Tag.
I am trying to do a API call to get our routers and switches from solarwinds but can't work out how to join two tables. I have this query that gets all the devices SELECT NodeID, IPAddress, Caption, NodeDescription, Description, DNS, SysName, Vendor, IOSImage, IOSVersion, MemoryAvailable, MachineType, IsServer,…
-
NPM CustomPoller SQL script for comparing previous or next record examples (sql 2012+)
HI, Solarwinds tech Support does not support this sql script. But it will work! Save it to a Report Writer or Custom SQL Web Report... You will need to modify the Where command.. Here is examples showing SQL to allow you to compare value between either previous or next records value in custompoller table. Again, you must…
-
SWQL Studio RIGHT JOIN not working
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.…
-
How to create join in Database Manager?
Hi All, I'm trying to become a "power" user, and do a fancy SQL query, but it's not working for me. I can't find a discussion about doing a basic join. In English pseudocode, I'm trying to: select IfName as Interface from Interfaces select IPAddress as 'IP Address' from NodeIPAddresses where the InterfaceIndex.Interfaces =…
-
"Complex" SWQL Query and Error
Hi all, I'm trying to create a table resource for displaying custom poller results using swql query. I've created the query in SQL, where it works without problems. When converted to SWQL though, it produces the error at the bottom of this post. The query (already translated with SWQL v3 schema names) is: select…
-
Two Custom Pollers - need to join into one table
hi, i have two custom pollers, one pulls a group of table headers from the multifunction copier/printer/scanner/fax/monstrosity, the other poller pulls the actual values. i'd like to join them into one table.. is there an easy way to do this? poller one returns this: prtMarkerSuppliesDescription -…
-
Creating a SWQL statement from more than one table
I'm trying to filter and list information from two linked tables (AlertDefinitions and AlertStatus), but to do that I think I need an inner join statement or some other SQL stuff but I cannot make that work. Can you please advise? >>This works fine Select ObjectName, TriggerTimeStamp, Acknowledged, AcknowledgedBy, Notes…
-
Advanced SQL
How can I join this 2 scripts to create a report with Event time and the currently down nodes.. SELECT Nodes.Caption AS NodeName, Nodes.IP_Address AS IP_Address, Nodes.Status AS Status, Interfaces.InterfaceName AS Interface_Name, Interfaces.Status AS Status_1, Nodes.StatusDescription AS Status_Description,…