This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Last xx Events. Filtered. 10.6; 10.4.2; 9.5.1

Gob over 14 years ago

events.filtered.JPG

Hi. Try to run Configuration Wizard, select Website only. After that add my resource, search by word Filtered

Last Events. Filtered.zip

Top Replies

0 terrys1026 over 13 years ago

I'm new to SW, so some additional directions would be helpful. I downloaded the files and installed them in locations corresponding to the filenames (with the exception of installing in subdirectories of c:inetpub\SolarWindsNPM\). Do I have to restart some part of SW to make them go?
Cancel
Vote Up 0 Vote Down

Cancel
0 terrys1026 over 13 years ago

I figured it out, plus received confirmation from the support team while working on another ticket.

Just put the files into the locations specified by the directory names in the zip file. You'll have a new resource that you can add to web pages. I replaced the Last xx Events page with this one on the home page and am now able to filter out noisy events that aren't important to us.
Cancel
Vote Up 0 Vote Down

Cancel
0 matthewbsimon over 13 years ago

BTW, I really wanted to filter out all events that relate to interfaces tagged as 'unpluggable' - because this is how I denote desktop ports.

This can't be done with the control above, but if you make 1 small modification it will work.

Change line 37 of Orion\Controls\NewEventsReportControl.ascx.cs to read:

builder.Append("SELECT TOP (@maxRecords) NetObjectType, NetObjectID, NetObjectID2, EventID, Acknowledged, EventTime, \r\n Events.EventType as EventType, Interfaces.Unpluggable as unpluggable, Message, ISNULL(EventTypes.BackColor, 0) as BackColor \r\n FROM Events \r\n LEFT JOIN Nodes ON Events.NetworkNode = Nodes.NodeID\r\n LEFT JOIN EventTypes ON Events.EventType = EventTypes.EventType LEFT JOIN interfaces on Events.NetObjectID = Interfaces.interfaceid");

all this does is add an additional left join on the interfaces table and include the unpluggable attribute.

After that you can used a filter like:
((unpluggable is null) or (unpluggable <> 1))
which is what I use.
Cancel
Vote Up 0 Vote Down

Cancel
0 familyofcrowes over 13 years ago

Will this work with Version 10?

Works great with 10.5 too.... :-)
Cancel
Vote Up 0 Vote Down

Cancel
0 wbrown over 13 years ago

Working great with my v10 sp1.
Makes the "Last xx events" section usable.

As terrys1026 mentions, use "customize page" to add the new functionality to the desired page.

Thank you Gob for developing this.
Cancel
Vote Up 0 Vote Down

Cancel
0 esamurai over 13 years ago

Thank-you Gob and matthew b,
It took reading all of the posts and figuring out that I could not use this to change the "Events" page. I now have the unplugged interfaces not showing up as "Up" on my Summary page's Events.filtered box.
NPM 10.1 SP1, about to try 10.2.
Cancel
Vote Up 0 Vote Down

Cancel
0 Federico55 over 12 years ago

Hi people,
does it work on 9.5.0 ?

I put all files in destination directory but I cannot see a new resource to add in customiza page.

Thnx to all
Cancel
Vote Up 0 Vote Down

Cancel
0 Federico55 over 12 years ago

Hi,

I posted message below in a new topic but a senior member
suggest to me to post it here.

Can you help me pls ?
Many thanks

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Hi guys and eXperts,

I downloaded a very useful tool found on this forum "Last xx Events. Filtered. For NPM 9.5.1"

and it works gracefully but I have a question.

Is this tool supporting any kind of Sql query or not ?

I am trying to filter an interface using this syntax :

(Interfaces.InterfaceName='FastEthernet4/44')

(Interfaces.InterfaceIndex='678')

(Interfaces.PhysicalAddress='000C.CE64.BB7B')

but none of this one is working.

Have you any ideas ?

Thank you in advance
Cancel
Vote Up 0 Vote Down

Cancel
0 Gob over 12 years ago

Federico 55, if you want to filter events by interfaces you should to modify one line. Just read the thrid answer in this topic.
Cancel
Vote Up 0 Vote Down

Cancel
0 pmzwieryznski over 12 years ago

Just installed on V10 and works GREAT! Thank you for the post!
Cancel
Vote Up 0 Vote Down

Cancel