This website uses cookies. By browsing this website, you consent to the use of cookies. Learn more.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- THWACK
- :
- Network Performance Monitor (NPM)
- :
- NPM Discussions
- :
- Universal Device Poller results manipulation

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

harrijs

Level 11

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-31-2012
05:17 PM

Are there any future plans to add a function that would allow for me to manipulate the results from a UnDP? I have a radio that stores transmit success rate information at an OID, but the values come back as 4 digits. The web interface for this radio does a quick calculation on this value before it displays it as a percentage with two decimal places. I would love to be able to do this for the results that Orion stores historically. An example is below.

Returned value for UnDP = 6235

Desired displayed value = 62.35

If there was a function that would allow me to multiply the returned value by .01, I would have my desired value.

If this is not currently an option, I would like to suggest it as a feature request.

Thanks.

Solved! Go to Solution.

1 Solution

harrijs

Level 11

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-01-2012
11:45 AM

Zak,

Thanks for the suggestion. I worked on this late last night and figured out that the order of Formula is specific (at least in my case it was).

I had to create the formula to be {Poller} * 0.01

Initially I tried to create it as {Poller}*.01 - (notice there are no spaces. Spaces are apparently important to these forumulas)

Then I tried {Poller} * .01 - (notice there is no leading value before the decimal. This is apparently also important)

I finally tried the formula {Poller} * 0.01 and it is working as expected.

I was initially confused about the transform because in the documentation there were only mentions of a handful of transform possibilities (avg, min, max, truncate, celsius to fahrenheit, X to Kb,Mb,Gb,Tb). I didn't know if I could perform simple calculations on the values I was receiving. It would be useful in future versions of the documentation if the possibilities of the the transform feature were fully discussed.

7 Replies

zkahl

Level 12

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-31-2012
06:36 PM

Have you tried to use the option "Transform Results"? This is found in the Universal Device Poller program.

If you have the poller already created, just select it then add "*.01" in the formula. Just reference this new transform you created for the results that you are wanting.

UnDP will still return = 6235

Transform will return 62.35

Let me know if that works. I haven't used this with a decimal point, but I think it should work just fine.

Zak Kahl

harrijs

Level 11

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-01-2012
11:45 AM

Zak,

Thanks for the suggestion. I worked on this late last night and figured out that the order of Formula is specific (at least in my case it was).

I had to create the formula to be {Poller} * 0.01

Initially I tried to create it as {Poller}*.01 - (notice there are no spaces. Spaces are apparently important to these forumulas)

Then I tried {Poller} * .01 - (notice there is no leading value before the decimal. This is apparently also important)

I finally tried the formula {Poller} * 0.01 and it is working as expected.

I was initially confused about the transform because in the documentation there were only mentions of a handful of transform possibilities (avg, min, max, truncate, celsius to fahrenheit, X to Kb,Mb,Gb,Tb). I didn't know if I could perform simple calculations on the values I was receiving. It would be useful in future versions of the documentation if the possibilities of the the transform feature were fully discussed.

vijay.raje

Level 11

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-01-2015
10:16 AM

I have created poller with the help of Transform result. applied it on same node. but not getting any data in chart & in table.

while testing it giving the exact data what we want.

Need your assistance.

zkahl

Level 12

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-01-2015
10:47 AM

I remember I had an issue like this a few years ago. If i remember correctly, the fix was playing with some values when on the poller. I don't remember exactly what it was, and I currently don't have a Solarwinds Environment that I work on.

You may want to post this question on the general NPM board to see if anyone else can assist.

vijay.raje

Level 11

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-01-2015
11:40 AM

Thank you.

alexisjavier

Level 7

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-22-2015
07:13 AM

Did you found a solution? I get the same behaviour, It works while testing or using the "non-converted" UDP.

Thanks!

zkahl

Level 12

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-01-2012
11:52 AM

Nice work getting it to work. I will make a mental note that a preceding '0' is needed before the decimal.

Zak Kahl

http;//www.loop1systems.com

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

© 2020 SolarWinds Worldwide, LLC. All Rights Reserved.