7 Replies Latest reply on Jul 4, 2015 6:18 AM by eno

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

    eno

      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

        • Re: How Can I Create Custom Poller for Simple Queue and The formula Transform Results?
          eno

          Hi all,

          Is it that there is no more engineers or IT Pro out there who can help. The above is a requirement from a client which is a dependency to closing this deal. The customer can archive this with CACTI so I wonder why we can't do even more with Solarwinds.

           

          maria.bungau, pmstone

          I really nedd your help with this. We are currently running a POC in the client's environment to help them make the right decision. The customer had provided us with list of OID to be monitored on Mikrotik devices for simple queue at node level. PLEASE HELP

          • Re: How Can I Create Custom Poller for Simple Queue and The formula Transform Results?
            HolyGuacamole

            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

              • Re: How Can I Create Custom Poller for Simple Queue and The formula Transform Results?
                eno

                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.

                  • Re: How Can I Create Custom Poller for Simple Queue and The formula Transform Results?
                    HolyGuacamole

                    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.

                      • Re: How Can I Create Custom Poller for Simple Queue and The formula Transform Results?
                        eno

                        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.

                          • Re: How Can I Create Custom Poller for Simple Queue and The formula Transform Results?
                            HolyGuacamole

                            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

                              • Re: How Can I Create Custom Poller for Simple Queue and The formula Transform Results?
                                eno

                                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.