Current Down Nodes and Interfaces with Duration

very helpful thanks

This is really great, but wanted to see if I could make it more specific based on Node name. I was thinking a line of code similar to this, but not sure where to put it or if it would even work at all:

Nodes.Caption LIKE 'xxxxx'

Any help would be awesome, thanks.

Should be possible as long as you put it into the Where clause. 

Oddly enough I tried that and it filtered out the specific Nodes I was looking for. The base code returns a number of items, but when I add that line it will remove anything with -ehrk in the name.

WHERE (

(E.NETOBJECTID = N.NODEID) AND

(E.EVENTTYPE = 1) AND

(N.CAPTION LIKE '%-ehrk%') AND

(N.STATUS = '2'))

GROUP BY N.NODEID, N.CAPTION, N.OBJECTSUBTYPE

Try this instead and see what the results are:

WHERE (

(E.NETOBJECTID = N.NODEID) AND

(E.EVENTTYPE = 1) AND

(N.STATUS = '2'))

AND

(N.CAPTION LIKE '%-ehrk%')

GROUP BY N.NODEID, N.CAPTION, N.OBJECTSUBTYPE