Dear All
I am trying to create a Report in where the report should show the downtime & uptime of the Interface in the below format
Sr. no | Interface Name | Downtime_DateTime | Uptime_DateTime | total Downtime Duration.
Can somebody help me on this
Have a look at these posts explaining how to do this with the custom SQL query in Report Writer.
Network Guru,
I tried below SQL Starements in Report Writer. I replaced 45 days to 2 days as I dont have 45 days data. The report is fetching 0 records.
SELECTEvents.EventTime AS Event_Time,Nodes.Caption AS NodeName,Nodes.IP_Address AS IP_Address,Events_EventTypes.Name AS Event_Type_Name,DATEDIFF(Mi, Events.EventTime,(SELECT Top 1EventTimeFROM Events AS EndtimeWHERE EndTime.EventTime > Events.EventTime And EndTime.EventType = 11ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes
FROMNodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)
WHERE((Events_EventTypes.Name = 'Interface Down')
AND
(EventTime between dateadd(day, -45, getdate()) and getdate())AND
(
(Nodes.Caption = 'atlrt-masergy') OR(Nodes.Caption = 'denrt-inetatt') OR(Nodes.Caption = 'denrt-inetmasergy') OR(Nodes.Caption = 'denrt-masergy') OR(Nodes.Caption = 'denrt-sprint') OR(Nodes.Caption = 'frart-masergy') OR(Nodes.Caption = 'frart-sprint') OR(Nodes.Caption = 'lgwrt-masergy') OR(Nodes.Caption = 'lgwrt-sprint') OR(Nodes.Caption = 'nbyrt-masergy') OR(Nodes.Caption = 'nobrt-masergy') OR(Nodes.Caption = 'nobrt-sprint') OR(Nodes.Caption = 'nycrt-masergy') OR(Nodes.Caption = 'nycrt-philly') OR(Nodes.Caption = 'nycrt-sprint') OR(Nodes.Caption = 'b61sw-closet2') OR(Nodes.Caption = 'SJC-IAD2420') OR(Nodes.Caption = 'sjcrt-masergy') OR(Nodes.Caption = 'sjcrt-sprint') OR(Nodes.Caption = 'wilrt-masergy') OR(Nodes.Caption = 'wilrt-sprint') OR(Nodes.Caption = 'denrt-centennial') OR(Nodes.Caption = 'nbyrt-masergy')))
ORDER BY 1 DESC
