Down Interfaces Resource Filtering

I'm trying to use the Down Interfaces resource as a way to show which CircuitIDs are down because I have most interface descriptions configured with the CID. However when I try to apply a filter to remove Ethernet interfaces and nodes which are up but their interfaces are unknown, I receive the message 'Custom SQL filter is incorrectly formatted.'

My query is: InterfaceTypeDescription NOT Like '*Ethernet*' And Status != 'Unknown'

If I leave just the InterfaceTypeDescription and take off the Status part, it works fine. Something is wrong with my Status query. Any ideas?

Find more posts tagged with

Accepted answers

sedmo

The problem you are having may be related to the fact that there are multiple tables in the database with a field named status. That means you need to specify which table you are referring to in your filter. Try something like this:

InterfaceTypeDescription NOT Like '*Ethernet*' and interfaces.status <> 0

All comments

jason.clark

The Filter Examples shows the following:

Filter the results to only show Nodes that are not UP
Status<>1

The valid status levels are:

0=UNKNOWN	(The current up/down status of the Node is unknown)
1 = UP	(The Node is responding to PINGs)
2 = DOWN	(The Node is not responding)
3 = WARNING	(The Node may be responding, but the connection from the server to the Node is dropping packets)

You might try Status<>0

That said, I'm not a SQL person, and I have found these Filter Nodes interfaces to be quite unreliable. Even when copying their first example in the documentation (Satus<>1), it does not work. It's at least worth a try in your case.

FormerMember

Something about the Status part of the query is being rejected for the Down Interfaces resource. I cannot make it work any which way I try to word it Status>0, Status=1, Status!=0. Nothing is working.

sedmo

InterfaceTypeDescription NOT Like '*Ethernet*' and interfaces.status <> 0

FormerMember

That got it!