Options
Sign in to Download

Syslog & Trap widgets for Node & Interface Details Views

Hello,

I have prepared a full video tutorial for adding custom Syslog and Trap widgets for Node & Interface Details Views.

You can also use below description and attached TXT file will all the queries.

First Node Details widget will allow you to jump directly from Node Details view to Log Viewer Dashboard and start the log analysis:

In order to create above widget, please add "User Links" widget and include below hyperlinks:

Log Viewer (Syslog & Traps) - Last Hour
/ui/orionlog/logviewer/now/1hours/${NodeID}

Log Viewer (Syslog & Traps) - Last 24 Hours
/ui/orionlog/logviewer/now/24hours/${NodeID}

Log Viewer (Syslog & Traps) - Last 7 Days
/ui/orionlog/logviewer/now/7days/${NodeID}

Below Node Details widgets are simple counters based on predefined filters, which can be changed. In order to add them, please use Custom Query widget.

Below Node Details Custom Query widget is showing only linkDown and linkUp traps. It is also finding correlated monitored network interface in NPM.

If an interface is not monitored, then you will see "not monitored" and decide, if it should be added.

Node Details Custom Query widgets for Last 300 Syslog and Trap messages.

Interface Details Custom Query for Last 300 Traps. This widget is finding traps based on Interface Index.

Interface Details Custom Query widget for Last 300 Syslog messages. This widget is finding Syslog based on Interface Name or IfName.

So, in this example, for syslog "flapping between port Gi1/0/2 and port Gi1/0/7", you will actually see this message in both interfaces in Interface Details View.

This is very handy and I highly recommend it.

Kind regards, Marcin.

kpmarcin
  • in reply to Daran

    Hi  

    Could you check the query using SWQL Studio? If the reason is a timeout, I am not sure if we can do more about this.

    How many Syslog/Traps messages you have currently? API is not very well optimized for those and I've seen timeouts in the past.

    Another workaround for timeouts is to use SQL queries (instead of SWQL), however such widgets are not very pretty and does not have search function.

    Also, you would need to configure "Linked Servers" (in SQL Management Studio) between main DB and syslog DB. If you are interested, I can take a look at creating such query.

  • in reply to kpmarcin

    Hi,
    still getting the same error... :(

  • in reply to Daran

    Hello  

    If you are seeing both empty and error results in the same widget, that might indicate a timeout. There could be multiple reasons for it, but overall the SWQL for Log Viewer/Analyzer is not very well optimised. I hope it will get better in the upcoming releases.

    Could you try including a date filter, for example last 7 days? You can add below row just above the "ORDER BY":

    AND DAYDIFF(le.DateTime, GETUTCDATE()) <= 7

  • in reply to kpmarcin

    Hi Marcin,

    yes - I have definitely copied the entire query.  Sometimes the widget comes back blank (expected if there are no results I guess) and other times it comes back with an error...

  • in reply to Daran

    Hello  

    Those widgets should work on any environment. I am a curious why it is not working for you. Did you copy&paste the entire query?

    It might be a good idea to open the SWQL file using Notepad++ and copy the query from it, instead of other software.

    If you still have issues, could you install OrionSDK, run SWQL Studio, paste the query, replace "${NodeID}" with the correct NodeID, run it and show me the result?

    SWQL Studio will tell us what is wrong.

    Kind regards,

    Marcin.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Customer Portal
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.