Report for Interface Down for More Than 31 Days

Hello All, 

I was looking for a query to let me know if an interface is down for more than 31 days.  We are going to some tech refresh and my network admins move so fast they never go back to do the house keeping.    and  have done some great work in the past and was wondering if you had a solution to this query.  

I use this one to tell me if a node is down for more than 5 days. 

n.Caption AS Node,
e.ServerName AS PollingEngine,
n.ObjectSubType AS PollingMethod,
TOLOCAL(n.LastSystemUpTimePollUtc) AS LastUptimeLocal
FROM Orion.Interfaces.Interfaces n
JOIN Orion.Engines e ON n.EngineID = e.EngineID
WHERE n.ObjectSubType <> 'ICMP' AND n.Status = 2
AND DAYDIFF(TOLOCAL(n.LastSystemUpTimePollUtc), GETDATE()) > 5
ORDER BY n.LastSystemUpTimePollUtc ASC

Top Replies

Parents Reply
  • Here's an example with 's query. May need to adjust depending...

    SELECT I.Caption as [Interface Name]
    , I.Node.Caption as [Node Name]
    , tolocal(I.LastChange) as [Last Change Time]
    ,I.Node.ObjectSubType AS PollingMethod
    FROM Orion.NPM.Interfaces I
    WHERE I.Status = 2 AND I.Node.Vendor ='Cisco'
    AND I.Node.Caption LIKE '%SITECODE%'
    AND DAYDIFF(TOLOCAL(I.LastChange), GETDATE()) > 31
    ORDER BY I.LastChange ASC