how would i filter on interfaces which are UNPLUGGABLE

lchance

i created a scheduled report about events from certain nodes (which have a CUSTOM NODE PROPERTY).

now i don't want to include any event where an interface/port is flagged as UNPLUGGABLE. this particular report is based on the EVENTS.

how would i mass-create a CUSTOM INTERFACE PROPERTY where i could also use that as a filter?

i don't want to manually go through hundreds of Custom Property interfaces which are designated unpluggable. i hope i explained this ok...whew!

qle

I understand what you're saying which is why I was following up on your suggestion for an advanced SQL solution. However, after testing it out, the solution wasn't as simple as I had suggested in my post. Anyway, after some self-education in SQL, I may have found a solution. See if the following works for you. Create a new Advanced SQL report and use the SQL query you posted. However, change the following:

FROM
Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)

WHERE
( EventTime BETWEEN 40182 AND 40182.4166666667 )
AND
(
(Nodes.Department = 'WIDE')
)

 to

FROM 
Nodes INNER JOIN (Interfaces RIGHT OUTER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Interfaces.InterfaceID = Events.NetObjectID)) ON (Nodes.NodeID = Events.NetworkNode)

WHERE
( EventTime BETWEEN 40182 AND 40182.4166666667 )
AND
( Nodes.Department = 'WIDE')
AND
(Unpluggable <> '1' or Unpluggable is null)

 Let us know how that works out for you.