GENERATE A REPORT WHICH TELLS YOU NODE AND ALERT(NAME AND MESSAGE) CONFIGURED FOR ALL NODE : NOTE REPORT SHOULD NOT INCLUDE ACTIVE ALERT(NAME AND MESSAGE)?
GENERATE A REPORT WHICH TELLS YOU NODE AND ALERT(NAME AND MESSAGE) CONFIGURED FOR ALL NODE : NOTE REPORT SHOULD NOT INCLUDE ACTIVE ALERT(NAME AND MESSAGE)?
Caps lock aside, are you looking for a report that tells you all the possible alerts for each node? or all alerts that can trigger on any node? When you say "message", which one do you want? The Alert Description, or what the trigger action writes out to the Event Log or to an e-mail? When you specify alerts that are configured for all node, but not active alerts, do you imply Enabled (triggerable) alerts as "active" alerts, or do you mean currently "active" alerts (currently triggered)?
You haven't gotten any response up to now because there are too many ways to interpret your question. Try writing out a simple example of what you want to see using a spreadsheet. What columns are there? What kind of data is in each row? Give us this, and it'll help us figure out exactly what you are looking for.
this should get you in the right direction:
you can use the web report writer to create a custom SQL report and then use this query.
select
a.name as 'ALERT'
,o.entitycaption as 'ALERT OBJECT'
,o.entitytype as 'ALERT OBJECT TYPE'
,o.relatednodecaption as 'RELATED NODE'
from alertobjects o
join alertconfigurations a on a.alertid = o.alertid
where a.enabled = 1
order by a.name, o.entitycaption
Loop1 Systems: SolarWinds Training and Professional Services
Thanks for your reply!
I have performed following steps in report writer but when i select preview - get an SQL error:
- open report writer
- select new
- select advance SQL
- select SQL tab and copy and paste your query
- run preview
SQL Error : Invalid object name 'alertobjects'
It's going to be harder to configure something like this in 11.0.1 especially if you're using Advanced Alerts. The alerts themselves usually aren't set up on a per node basis and will usually cover everything in the database. Also, with the way the table and the conditions are built, there's nothing to relate a specific device to a node until the alert triggers. Now, if you have alerts set to trigger on specific nodes, then there would be ways to do that, but you'd have to parse out the trigger query field from the database of find anything that contains a node name within it.
Select
AlertStatus.AlertDefID,AlertStatus.ObjectName,
Events.EventID,Nodes.Vendor,Nodes.NodeID,Nodes.Status,Nodes.Caption as "Node Name",hw.ServiceTag as Serial,Message,AlertStatus.ObjectType as "Alert Type",EventTime,Nodes.IP_Address,Nodes.CRM_Account
from AlertStatus WITH(NOLOCK)
inner join Events WITH(NOLOCK) ON DATEADD(MINUTE,DATEDIFF(MINUTE,0,AlertStatus.TriggerTimeStamp),0) = DATEADD(MINUTE,DATEDIFF(MINUTE,0,Events.EventTime),0) AND CONVERT(varchar(255), AlertStatus.ActiveObject) = convert(varchar(255), Events.NetObjectID)
INNER JOIN Nodes WITH(NOLOCK) on Nodes.NodeID = Events.NetworkNode
Left outer join APM_HardwareInfo as hw WITH(NOLOCK) on hw.NodeID = Nodes.NodeID
WHERE Nodes.Status <> 9
AND AlertStatus.Acknowledged <> 1
AND Events.EventType = 5000
UNION
Select
AlertStatus.AlertDefID,AlertStatus.ObjectName,
Events.EventID,Nodes.Vendor,Nodes.NodeID,Nodes.Status,Nodes.Caption as "Node Name",hw.ServiceTag as Serial,Message,AlertStatus.ObjectType as "Alert Type",EventTime,Nodes.IP_Address,Nodes.CRM_Account
from AlertStatus WITH(NOLOCK)
left outer join CustomPollerStatusTable as cps WITH(NOLOCK) on cps.UniqueID = AlertStatus.ActiveObject
Left outer join CustomPollerAssignmentView as cpa WITH(NOLOCK) on convert(varchar(255),cpa.CustomPollerAssignmentID) = AlertStatus.ActiveObject
inner join Events WITH(NOLOCK) ON DATEADD(MINUTE,DATEDIFF(MINUTE,0,AlertStatus.TriggerTimeStamp),0) = DATEADD(MINUTE,DATEDIFF(MINUTE,0,Events.EventTime),0) AN
( cps.NodeID = Events.NetworkNode
OR
cpa.NodeID = Events.NetworkNode
)
INNER JOIN Nodes WITH(NOLOCK) on Nodes.NodeID = Events.NetworkNode
Left outer join APM_HardwareInfo as hw WITH(NOLOCK) on hw.NodeID = Nodes.NodeID
WHERE Nodes.Status <> 9
AND AlertStatus.Acknowledged <> 1
AND Events.EventType = 5000
This might be because the alerts that you create also have to write to netperf as well so that it creates a message with the alert.
I wrote this up as well Some Things Solarwinds Admins Can't Live Without some of that might help you.
Please let me know if i can help any further!
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.