I have created a report that pulls in a device name (Caption from Node) and two values that are polled from Cisco routers using a UnDP. The values are the Downstream and Upstream DSL Line rates and are displayed in Bits per Second, the UnDP obtains the values from an OID. When I view the report some of the values appear to have too many digits so are displayed as shown in the screen grab below which I understand is referred to as Scientific notation or Exponential notation. The polled value of the top one is 11614000 bps (or 11.614 mbps) and when I view the device in NPM this value is displayed in full. I have setup a transform and this will successfully transform the value from bps to mbps, as it would be an option to use the transformed value in the report, but have been unable to work out how to create a report based on a transform result. How can I display either the polled value in full or a transformed value in the report? Appreciate any ideas or experience that you may have with this.

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.

Report based on UnDP values displayed as Scientific Notation

grizzlyferrett over 6 years ago

I have created a report that pulls in a device name (Caption from Node) and two values that are polled from Cisco routers using a UnDP. The values are the Downstream and Upstream DSL Line rates and are displayed in Bits per Second, the UnDP obtains the values from an OID.

When I view the report some of the values appear to have too many digits so are displayed as shown in the screen grab below which I understand is referred to as Scientific notation or Exponential notation.

DSL Rate Report.PNG

The polled value of the top one is 11614000 bps (or 11.614 mbps) and when I view the device in NPM this value is displayed in full.

I have setup a transform and this will successfully transform the value from bps to mbps, as it would be an option to use the transformed value in the report, but have been unable to work out how to create a report based on a transform result.

How can I display either the polled value in full or a transformed value in the report?

Appreciate any ideas or experience that you may have with this.

Top Replies

m_roberts over 6 years ago +2

Hi It is not necessary to use the converted UnDP value, as the report definition will allow you to manipulate the result. In this case if you edit the report format section and click on Advanced for the…

0 m_roberts over 6 years ago

Hi
It is not necessary to use the converted UnDP value, as the report definition will allow you to manipulate the result.
In this case if you edit the report format section and click on Advanced for the column you wish to manipulate, you will see an option within the drop down for Display Setting to use data conversion. Select Bps for this and it will auto scale to your values.
The screenshot below gives an example of this.
Hope this helps.
Mark
Cancel
Vote Up +2 Vote Down

Cancel
0 grizzlyferrett over 6 years ago in reply to m_roberts

Hi,
Thanks for the reply.
I don't see Data Conversion as an Option, I have only have three options
     Details Page Link
     Generic Icon
     Status Icon (Watermark)
Cancel
Vote Up 0 Vote Down

Cancel
0 m_roberts over 6 years ago in reply to grizzlyferrett

Can you provide details on your data selection in the table definition, as I believe you are using a custom query. Export the report if that is easier.
If the column is returning a numeric value, the data unit option should be visible.
Cancel
Vote Up 0 Vote Down

Cancel
0 grizzlyferrett over 6 years ago in reply to m_roberts

This is a screenshot of the data selection. It is a custom node poller.
Cancel
Vote Up 0 Vote Down

Cancel
0 jrouviere over 5 years ago in reply to grizzlyferrett

Not sure if you're still having the issue as this is an older post, but to close the loop on it at least:
Make sure you're selecting the Add Display Settings drop down and selecting Data Unit.
If you're still not seeing it make sure you're using Current Numeric Value instead of Current Value.
It's the difference between it being treated as an integer or a string.
Cancel
Vote Up 0 Vote Down

Cancel