Regular expression to check for shutdown interfaces

charles.ponton

Trying to create a rule to check for shutdown interfaces on a cisco router.

Anyone have the syntax to create a regular expression to check for shutdown interfaces on a cisco router? Following the documentation with no success

krc85aggie

I actually created a report which gives a count of admin down and oper down which you might be able to tweak.

You have to have the Node Goup defined under NCM properties

SELECT 

      NodeCaption AS [Device Name],

      NodeGroup AS [Group],

      AgentIP AS [Device IP], 

           COUNT( 

                CASE WHEN n.Interfaces.AdminStatus = '1'  

                THEN 1 ELSE NULL END 

                )  

                     AS [Admin Up], 

           COUNT( 

                CASE WHEN n.Interfaces.OperStatus = '1'  

                THEN 1 ELSE NULL END 

                )  

                     AS [Oper Up], 

           COUNT( 

                CASE WHEN n.Interfaces.AdminStatus = '2'  

                THEN 1 ELSE NULL END 

                )  

                     AS [Admin Down], 

           COUNT( 

                CASE WHEN n.Interfaces.OperStatus = '2'  

                THEN 1 ELSE NULL END 

                )  

                     AS [Oper Down], 

           COUNT( 

                n.Interfaces.AdminStatus 

                )  

                     AS [Total]  

    FROM  

      NCM.Nodes n 

    WHERE 

      n.Interfaces.PhysicalInterface = 'Y' 

    GROUP BY 

      NodeCaption, AgentIP,NodeGroup 

    ORDER BY 

      NodeCaption