Is there a way to select a node in Orion NPM and return all the alerts associated with it? We're running NPM 10.0.
Thanks in advance.
Is there a way to select a node in Orion NPM and return all the alerts associated with it? We're running NPM 10.0.
Thanks in advance.
I went thru the same problem and found a _long_ but workable solution.
I wrote a php script (my scripting language of choice for the last few years) that did the following:
Needless to say, this took a while to write (2-3 days) and most likely doesn't correctly strip all variations of WHERE statements that you could write.
Example:
alert name : Node MEM Utilization
Original sql:
SELECT DISTINCT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name
FROM Nodes
WHERE
(
(Nodes.Status = '1') AND
(Nodes.Status <> '0') AND
(Nodes.Status <> '9') AND
(Nodes.customproperty= 1) AND
(Nodes.PercentMemoryUsed >= 85)
)
Stripped sql:
SELECT DISTINCT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name
FROM Nodes
WHERE ( ( Nodes.customproperty= 1 ) )
In this case the idea is to delete the Nodes.Status and Nodes.PercentMemoryUsed qualifiers and see what comes out.
You can also start by doing the process by hand to understand what needs to be done.
Chris
It is a very good question, because by the nature of Alert definition in Orion, it is not very clear which nodes/interfaces it applies to (if your conditions are too detailed).
Over a course of time, it becomes essential to pick some core nodes and check whether all policies created are applicable for it (i.e, not skipped because of some loosely defined rules)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.