WorldMap Filter

dogsalt428

I would like to filter on the worldmap showing only down nodes that have not have their alert acknowledged. 

I see limited options. Currently, only down nodes using node properties. See below. 

I can do this with a  swql command with proper results using the code below.

SELECT TOP 100 AlertDefID, ActiveObject, ObjectType, State, WorkingState, ObjectName, AlertMessage, TriggerTimeStamp, TriggerTimeOffset, TriggerCount, ResetTimeStamp, Acknowledged, AcknowledgedBy, AcknowledgedTime, LastUpdate, AlertNotes, Notes, AlertObjectID, DisplayName, Description, InstanceType, Uri, InstanceSiteId
FROM Orion.AlertStatus where acknowledged=0

I am wondering how I apply this logic to the WorldMap.

Am I missing something? A node property or using a custom group?

Any help is appreciated.

marlief22

Hi there, 

I had a quick play with this and managed to get it working in the following way (Copy and paste the below in the 'Filter Nodes' section of the map widget:

status = 2 and nodeid in (SELECT RelatedNodeId
FROM Orion.AlertObjects
where alertobjectid in (Select AlertObjectID from Orion.AlertActive where Acknowledged is NULL)
and EntityType = 'Orion.Nodes')

Couple of notices:

1. It is using the specific status of the node, in this case 2 (Down) - You will have to change this if you want to do Critical or Warning too. 
2. RelatedNodeId technically could match child items of a device, but the EntityType property SHOULD avoid that problem - haven't tested thoroughly though. 

If this helps, please mark this as a confirmed answer to help other people who might have the same problem.

Any questions just ask!

Marlie Fancourt | SolarWinds Pre-Sales Manager 

Prosperon Networks | SolarWinds Partner since 2006