We would like to alert on IPv4/IPv6 BGP peers but it looks like Orion's default OID doesn't include peer state for IPv6 BGP peers.
I created a UnDP poller for jnxBgpM2PeerState, jnxBgpM2PeerLocalAddr, and jnxBgpM2PeerRemoteAddr but the IP addresses are returned as a Hex String.
Here's a snippet of what's returned in an snmpwalk for IPv4 (top 3 lines) and IPv6 (bottom 3 lines) for the BGP peer local address. Values were sanitized so probably not actually accurate.

In SQL I get this character in Status though. I found a script linked below to convert it to hex which seems to work for the IPv4 address but for IPv6 it seems like half the data is missing. Is it just a limitation of what can be stored? I'm guessing from Hex I would be able to then convert to an IP format but haven't gotten that far. Would this even be possible in SQL or would I need to use Powershell to do something like this?
thwack.solarwinds.com/.../creating-a-undp-for-monitoring-a-hex-string

The end goal is just to alert on a BGP peer not established and in the alert show the actual peer IP address.