I have created an "Events" report called "Nodes That Went Down - Last 7 Days." Is it possible to have this report - or another report - also show the total amount of time the node was down?
This is definitely possible. I found this in the content exchange which may aid you in getting to where you are wanting to go.
Device_Outage_byDuration.OrionReport
This is going to need an advanced sql report.
Sohail Bhamani
Loop1 Systems
http://www.loop1systems.com
The report does not run because it does not like the final portion of the Select statement: "nodes.n_mute_reason as Addtl_Info." Any suggestions?
select nodes.caption, Nodes.GroupStatus, nodes.nodeid, nodes.percentloss,
a1.downtime, nodes.n_mute_reason as Addtl_Info
from Nodes
left outer join (select AlertStatus.ActiveObject as nodeid,
CONVERT(varchar, alertstatus.triggertimeoffset/60/60/24) as days,
+CONVERT(varchar, alertstatus.triggertimeoffset/60/60 % 24) as hours,
+CONVERT(varchar, alertstatus.triggertimeoffset % 60) as minutes,
CONVERT(varchar, alertstatus.triggertimeoffset/60/60/24)+' d '
+CONVERT(varchar, alertstatus.triggertimeoffset/60/60 % 24)+' h '
+CONVERT(varchar, alertstatus.triggertimeoffset % 60)+'m' as downtime,
AlertDefinitions.AlertName
from AlertStatus
join AlertDefinitions on AlertStatus.AlertDefID = AlertDefinitions.AlertDefID
WHERE
alertdefinitions.alertname like '%updown%'
OR alertdefinitions.alertname is NULL) a1
on convert(varchar, Nodes.nodeid) = a1.nodeid
nodes.status <> 9
order by nodes.GroupStatus asc,
a1.days desc, a1.hours desc, a1.minutes desc,
nodes.caption
Looks like n_mute_reason is a custom property on the Nodes level that would need to be created in your environment to support this. This is how I am readin this.
Sohail is correct. The n_mute_reason is a custom property. If you don't have that created, just remove if from the query so it will read:
a1.downtime
Regards,
Matthew Harvey
Sorry for just getting around to this. This report is close to what you want, but not (as I read your original request) exactly what you want.
What THIS report does is tell you how long it has been since a particular ALERT has triggered. That alert has to have "updown" in it's name (ie: winserver_updown, netwkrtrs_updown, etc).
As long as you have that (and, as Sohail pointed out, you either create the n_mute and addtl_info custom properties, or remove those lines from the query) you should be good.
