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.

Universal Device Poller when the temperature hits below 0 degrees celsius

Rotto over 13 years ago

I'm making a poller that polls the temperature on cisco equipment, which works fine until the temperature gets below zero. When this occurs it seems that NPM creates a totally wrong value, heres an example:

If the cisco switch reports -2 degrees celsius, then the UDP reads this as 254. Looks like it takes 256 and subtracts the temperature that the switch actually has.

Is there a way I can get NPM to report negative values?

The transform function will not work because then it will report negative values no matter what.

The high values in the picture is when the switch is below zero, cold in Norway nowadays ;-)

Thanks in advance,

Roy O.

Top Replies

bleearg13 over 9 years ago in reply to bleearg13 +1

FYI, I believe the problem here is that the column in the database is 'nvarchar' data type, so the negative number is not really seen as an integer. I think my solution is going to be to have to use a…

0 Rotto over 13 years ago

Nobody out there who has had the same problem?
Cancel
Vote Up 0 Vote Down

Cancel
0 crzyr3d over 11 years ago in reply to Rotto

I DO I DO!!! We finally have a location that the temp for a Cisco Wireless Bridge. In Orion UDP, it reaches a temp of 0 which converts to 32 F but after that it gives readings of like 491 F when it hits -1 and goes down from there. The udp uses this {ciscoEnvMonTemperatureStatusValue}CtoF( ) to convert it. Anyone out there know or found a solution to this yet?
Cancel
Vote Up 0 Vote Down

Cancel
0 mharvey over 11 years ago in reply to crzyr3d

I believe you need your transform setup like:
CtoF({ciscoEnvMonTemperatureStatusValue})

with the poller inside the parenthesis in order for the conversion to work.

Regards,
Matthew Harvey
Loop1 Systems
Cancel
Vote Up 0 Vote Down

Cancel
0 PavelSuchy over 11 years ago

Hi Rotto, crzyr3d,
I tried to reproduce your problem on my NPM 10.4 but I was not successful. I am able to poll negative values and convert them properly using CtoF funciton. Can you check, that your device provides correct information when negative value hits? Can you try to test the oid in UnDP to see if you receive negative value before conversion? Also it would be helpful if you would provide what OID you use so we can check its data type.
Thanks,
Pavel
Cancel
Vote Up 0 Vote Down

Cancel
0 crzyr3d over 11 years ago in reply to mharvey

Matthew,
We tested it last night and we received the same results. Thanks for the attempt to resolve the issue.
Cancel
Vote Up 0 Vote Down

Cancel
0 crzyr3d over 11 years ago in reply to PavelSuchy

Pavel,
here are some screen shots... We are using NPM 10.3.1
Cancel
Vote Up 0 Vote Down

Cancel
0 PavelSuchy over 11 years ago in reply to crzyr3d

Hi crzyr3d,
can you also post screenshot of whats returned to not transformed poller (ciscoEnvMonTepmeratureStatusValue)? I still could not reproduce the problem on my environment (attached screenshots) so I think it is problem on the device. Can you catch wireshark on the device and see what is returned to the 1.3.6.1.4.1.9.9.13.1.3.1.3 oid?
Thanks,
Pavel
Cancel
Vote Up 0 Vote Down

Cancel
0 bleearg13 over 9 years ago

cryzr3d,
Did you ever get a resolution to this? I'm experiencing the same issue. NPM does not alert properly based on negative values.
Cancel
Vote Up 0 Vote Down

Cancel
0 bleearg13 over 9 years ago in reply to bleearg13

FYI, I believe the problem here is that the column in the database is 'nvarchar' data type, so the negative number is not really seen as an integer. I think my solution is going to be to have to use a custom SQL alert and use a CAST function to convert the 'nvarchar' to an 'int'. My initial testing seems to indicate this works.
Cancel
Vote Up +1 Vote Down

Cancel
0 crzyr3d over 9 years ago in reply to bleearg13

Yeah, that is what I gathered after some time.
Cancel
Vote Up 0 Vote Down

Cancel