How do I import the ObjectGuid from LDAP in a Hexadecimal format?

John VanBruggen
Giga Guru

I noticed that if you export these from AD they come out as Hex and when imported into SNOW they seem to be BASE64.

Example:  

On a file provided from AD administrator, the guid is as follows: 9e5bab01-07dc-4ba1-a88f-93342f4b0927

Yet that same group when imported into SNOW shows as: AatbntwHoUuoj5M0L0sJJw==

I have found 1 website that accurately converts these from one to the other.

Online GUID Conversion Tool To Convert Hex Base64 Int

Is there a way to convert   9e5bab01-07dc-4ba1-a88f-93342f4b0927 to AatbntwHoUuoj5M0L0sJJw==

Better yet, is there a way to force SNOW to import it in HEX to begin with instead of forcing it to BASE64?

Check out my Consultant's Survival Guide
https://youtube.com/watch?v=zYi8KhP9SUk
1 ACCEPTED SOLUTION

I found the following will prevent the field from being modified from the original guid in ldap.


http://wiki.servicenow.com/index.php?title=Available_System_Properties#gsc.tab=0


http://wiki.servicenow.com/index.php?title=Available_System_Properties#gsc.tab=0



glide.ldap.binary_attributes


Comma-separated list of LDAP attributes that should be converted from binary format to encoded64 strings. If you set this property, only the values listed are converted. The most common attributes are objectSID and objectGUID. These converted values are unique and can be used as the coalesce field on the LDAP import mapping. If this property is blank, ServiceNow tries to map these binary attributes without the conversion and they are not guaranteed to be unique since they are not properly converted to string values. You can set this property for a MID Server to import BLOB data through a MID Server, starting with the Fuji release.
Check out my Consultant's Survival Guide
https://youtube.com/watch?v=zYi8KhP9SUk

View solution in original post

18 REPLIES 18

It was a long time ago.   I thought we had gotten the results without the dashes.   If that isn't what is happening let me know and I will unmark my response as correct..   it is possible the guid is a calculated field on the windows side as well?


Check out my Consultant's Survival Guide
https://youtube.com/watch?v=zYi8KhP9SUk

No, it does not bring it to HEX values.


Finally I am done with it. Works like a charm now. Will publish a post on it soon


I'm interested in reading the article but it is not available.