Filter Question...

Wildcards are not supported, at least not by using the asterisk.  What you are looking for is:

Match all
 - Node Status is Down
 - Node Ticketnumber is empty

However, I've found some inconsistencies with "is empty" and records that are null.  I can't remember off the top of my head how "NULL" is interpreted by report writer, so maybe someone else can chime in here.

EDIT:  Sorry, I thought this was report writer.  See kweise's suggestion below.

Matt,

I haven't tried filtering for an empty value, but you might try something like this:

TicketNumber <> '*' or TicketNumber <> ' ' or maybe TicketNumber <> null

Let me know if this helps or not.

Something like this should work

TicketNumber is not null and TicketNumber <> ''

I tried all of those...

Really I am trying to sort out interface outages where tickes have NOT been assigned meaning a null value in the TicketNumber field..

No luck on those that were posted, any other thoughts?

You might try running this query and see what values show up in the TicketNumber field for the currently down interfaces.  Note that I am assuming that the TicketNumber custom property is a field in the nodes table.

select Nodes.Caption, Nodes.TicketNumber, Interfaces.Caption, Interfaces.StatusLED from interfaces join nodes on Interfaces.NodeID = Nodes.NodeID where Interfaces.StatusLED = 'Down.gif' or Interfaces.StatusLED = 'Unknown.gif'

I changed ticketnumber to an integer and   "TicketNumber is null" works now... I guess NULL doesnt work on text-fields... bizarre

Followup:

In the same filter... is it possible to do a combo like   "if node is up and TicketNumber is null"  I cant seem to combine a Node and Interface filter in the resource.. is this possible?

My last post wasnt clear..

I am using the "Down Interface" resource as the basis for these filters..

I just tried a raw  "Status>0" to filter out unknowns and it came back as a bad SQL... even though its listed in the examples... and I missing something here?

You may need to write the filter as Interfaces.Status > 0 to differentiate between the status field in the nodes table and the status field in the Interfaces table.

Got it.. I had Interface.Status not Interfaces.Status.... thanks