Open for Voting

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

  • This is awesome, one question.  How do I get it to not strip off 00 when it's a valid number?

    example:

    ô5#$    is being converted to:  F47F352324   but it should be: F47F35232400

  • 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.

  • 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.