cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Add Hex transforms to Custom UnDP pollers

Add Hex transforms to Custom UnDP pollers

I'm sure that it is somewhere on the to do list at Solarwinds for the UnDP tool to be integrated into the web console in the same way that most of the other tools have been migrating. 

I would hope that when you get around to that you could include a few additional transformations such as converting Hex values to Datetime or Decimal or even Binary formats as there are more than a few SNMP OID's out there that report in hex.

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

3 Comments
Level 13

Bumping - I'm currently creating a set of UnDPs that includes a date/time stamp that's reported in hex. As it stands, I can't even get the hex string into Solarwinds to parse it later.

Level 8

Hi, as a workaround, you can try this query to convert the value:

SELECT

DateTime,

--NodeID,

RowID,

[CustomPollerStatus].Status,

REPLACE(REPLACE(CONVERT(nvarchar(max), CONVERT(varbinary(max), [CustomPollerStatus].Status), 1), '00', ''), '0x', '') FiberWwn

FROM [SolarWindsOrion].[dbo].[CustomPollerStatus] (NOLOCK) INNER JOIN [SolarWindsOrion].[dbo].[CustomPollerAssignment] (NOLOCK)

ON [CustomPollerStatus].CustomPollerAssignmentID = [CustomPollerAssignment].CustomPollerAssignmentID

WHERE

[CustomPollerAssignment].PollerID IN (

'305E000C-9977-437C-A6CC-975B14D30080'

)

ORDER BY NodeID, CAST(RowID as int)

Change the bold colounm for your necessity.

In SQL:

pastedImage_11.png

In snmp walk:

pastedImage_1.png

For now, it's working for me.

Level 13

Thanks!