Comments
-
UPDATE: Got it working like this check it out SELECT TOP 100 CustomPollerAssignmentID ,DateTime ,Status ,RowID ,AO.Description ,AO.EntityCaption FROM Orion.NPM.CustomPollerStatistics CPS JOIN Orion.AlertObjects AO ON (CPS.RowID = Replace(AO.EntityCaption, 'Contact Point ', '')) WHERE RowID LIKE '%.2.%' AND…
-
Sorry, this is for a modern dashboard, I didn't write that SQL code. I'm trying to access the above table to display the alert name in my dashboard (using SWQL).
-
Asentria SiteBoss 530 pretty sure
-
Here is the code I can pull through; I didn't write it. It gets pulled through when I query Orion.AlertObjects.AlertConfiguration.AlertMessage ${N=SwisEntity;M=CustomPollerAssignment.Node.Caption}:: [${N=SwisEntity;M=CustomPollerAssignment.Node.CustomProperties.ws_node_short_description}] ${SQL: SELECT CASE WHEN…
-
@"wluther", @"Seashore" I combined both your ideas into this. Since using 1440.0 returned a long decimal number which caused trailing zeros but using 1440 returned an integer there wasnt a simple way to achieve "378.9 days", therefore by using the method below I managed something close, I could have used this to obtain…
-
This does work well, although the only issue here is this method doesn't allow for any decimal places in the result, you're stuck with an integer. I'll try adding the decimal on and see if that works
-
I've already found importing dashboards to be really useful to find out how other people use SWQL. I'll get onto making some terrible queries and learning. Thanks!
-
Thank you for your great reply. My original plan was to make a top-level summary dashboard which linked to others for specific systems so it's great to know that pros do that too! So, from what you're saying, it would put a lot of strain on the system if I put lots of large queries on a dashboard that everyone uses, but…
-
Yeah, I've been practicing on the dev server although it doesn't contain many of the nodes I'm looking to query unfortunately. Thanks for your help!
