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.

How Can I Create Custom Poller for Simple Queue and The formula Transform Results?

Hello All,

Presently all our clients are queued in the router via Simple Queue List in Mikrotik router. The simple queue list is basically used to band limit our clients. In order for us to get jitter reports for each client, we need to be able to get bandwidth utilization in Orion.


Can all good people out there with the below. I would like to create custom poller using the OID below.


I would appreciate if anyone could use the below to show how I can go about it and the Transform results formula to get the result in MB

Flag 0:

name=.1.3.6.1.4.1.14988.1.1.2.1.1.2.4

bytes-in=.1.3.6.1.4.1.14988.1.1.2.1.1.2.8.4

bytes-out=.1.3.6.1.4.1.14988.1.1.2.1.1.2.9.4

packets-in=.1.3.6.1.4.1.14988.1.1.2.1.1.2.10.4

packets-out=.1.3.6.1.4.1.14988.1.1.2.1.1.2.11.4

queues-in=.1.3.6.1.4.1.14988.1.1.2.1.1.2.12.4

queues-out=.1.3.6.1.4.1.14988.1.1.2.1.1.2.13.4

Parents
  • What are you running into while setting up custom pollers? I am assuming you have seen the UnDP video available below

    Network Performance Monitor (NPM) Core Training - YouTube

  • Hi HolyGuacamole,

    Thanks for the response. Finally someone came to my rescue.

    I was able to query a particular device using the OIDs above from name up to Packet-out, but got OID not supported for the last two.

    However, the result of those OIDs are in different table and I am looking for a way to compile them in a single table. When transforming result, it does now allow to select multiple label in a table hence the display result is in separate table.

    I will like to have a table for those results as:

    OID Result.jpg

    Currently, individual tabs in the table exist but i would like to merge them.

    Can you help urgently?

    Thanks in advanced.

Reply
  • Hi HolyGuacamole,

    Thanks for the response. Finally someone came to my rescue.

    I was able to query a particular device using the OIDs above from name up to Packet-out, but got OID not supported for the last two.

    However, the result of those OIDs are in different table and I am looking for a way to compile them in a single table. When transforming result, it does now allow to select multiple label in a table hence the display result is in separate table.

    I will like to have a table for those results as:

    OID Result.jpg

    Currently, individual tabs in the table exist but i would like to merge them.

    Can you help urgently?

    Thanks in advanced.

Children
  • If you get unsupported message, that means your device doesn't respond to those OIDs. For the byes in, out etc, they seem to be counters. When you define the custom poller, you may want to choose 'counter' as the poller type so that NPM can automatically compute the delta between two consecutive polls.

    If you search for 'universal' from the list of available dashboard resources, you will find table and charting options to show multiple pollers in the same resource.

  • Thank you. I tried to use the multiple universal device poller custom chart but did not really get what I was looking for because it shows aggregates rather than individual. How I have found partly what i want using the guide in this post on which you where also a contributor: How to Set Up Multi-Column Table With Custom Device Poller

    However, the result there is more like raw data, we tried to convert the bytesin, bytesout, packetsin, packetsout using the XtoKilobytes formular and this provided a result as the below.

    UnDP Result.JPG

    The above is what I got after the transformation XtoKilobytes({SimpleQueueBytesIn}/1024) and each row represent a customer. I don't know if this formula is correct but I feel the numbers after the decimal is too much and I am looking for a way to reduce the number of digits display and will like to present it in a more readable format. Can you help with the right formula to use I will really appreciate if you could.

    Also is there a way to represent each customer result in a graph? Please help.

    Thank you so much.

  • ‌your device is providing the polled value in bytes. xtokbytes will convert bytes to KB. So, you shouldnt be doing a /1024 on top of that as that will effectively convert bytes to MB.

    To control the number of decimal points, you can use the Truncate function. So, your transform should look something like

    TRuncate{XtoKbytes{poller}, 2}

    about the chart, i though you could edit the chart and you could select specific labels to chart? And, also prevent it from showing the sum. Did you click on the 'edit' button for the chart resource to see what the options are? That should help you show per customer.

    the only other way would be to create a separate poller per customer. You will need to know the unique row id for each customer in the snmp table to do this

  • Thanks so much for your support.

    Does it mean using /1024 is further converting the kb into mb? That means the statistics in the table above is in mbps.

    When I edited the table above, I could select individual customer/row to be displayed on the table. But I am looking for way to put that table in a line Graph which customer can view from their login portal.

    Also, how do I show real time node line graph so we can see the movement in real time. It seems Solarwinds NPM cannot show real-time traffic on the network, all I am seeing are historical data since it is based on pull and push.

    Please tell me if I can view traffic in real-time this is very important.