Creating a UnDP for monitoring a Hex String.

aacosta

When I do an SNMP walk it shows: "1.3.6.1.2.1.2.2.1.6.3 = HEX-STRING: 64ED572016E0"

When I try to poll, I just see a weird character in the Orion database.

I've tried all of the formats available in the UnDP config but that doesn't help.

Find more posts tagged with

UnDP

npm

Accepted answers

All comments

wildersa

Hi, you can try this query:

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:

In snmp walk

For now, it's working for me.

aacosta

Thanks, I will ask our systems team to try this. I had given up...