Interface's up,down,shutdown and unknown events over the last 7 days + CP grouping

Question

SolarEGGS wasssup, Want to drop in and share a report with you chaps on events triggered by your interfaces over the last 7 days with active links and status LED's, from my previous report on Volume Report - Fixed Disk - Available - Size - Used - overall volume capacity NEW ** THRESHOLDS ** i know we like our custom properties so i have built them in for customer and vendor. this report will will give you a overview on the types of events that are triggering on your interfaces that you might have missed. Behind the scenes select CONVERT(VARCHAR(24),e.eventtime,113) AS Triggered ,'

' + '' + n.caption + '' AS 'NODE' ,'

' + '' + i.InterfaceName + '' AS 'INTERFACE' ,i.ObjectSubType polling_method ,CONVERT(VARCHAR(24),i.NextPoll,113) NextPoll --,n.n_customer --,n.Vendor ,case e.EventType when 10 then 'Interface down' when 11 then 'Interface up' when 12 then 'interface shutdown' when 13 then 'interface unknown' end 'Interface Events' from events e LEFT JOIN Nodes n on n.NodeID = e.NetworkNode LEFT JOIN Interfaces i on i.InterfaceID = e.NetObjectID where e.EventType IN('10','11','12','13') --change the 7 to a number within your event retention window and (e.EventTime > GETDATE()-7) -- you can comment the vendor n.n_customer and insert your own customer here also comment in the select statement the n.n_customer --and (n.n_customer like 'del%') --you can comment the vendor n.vendor and insert your vendors here also comment in the select statement the n.vendor --AND n.Vendor IN('Cisco','Windows') Group by e.eventtime,n.nodeid, n.caption,i.InterfaceName,i.ObjectSubType,i.NextPoll,e.EventType,e.NetworkNode,i.interfaceID,n.StatusLED, n.n_customer,n.Vendor,i.StatusLED order by e.EventTime desc Please download and enjoy thank you Interface%27s+down%2cup%2cshutdown+and+unknown+over+the+last+7+days+report+.xml