cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vktr Frequent Visitor
Frequent Visitor

Active Directory (AD) User Object GUID

Hello,

 

Has anyone managed to get User Object GUID from Active Directory (AD)?

It is in binary format so it must be converted to text to use it.

 

There is an example on how to convert Object SID binary to text.

Also I saw a topic where MS Graph is used to get GUID, but it only applies to Azure AD, so it would not help in my case.

1 ACCEPTED SOLUTION

Accepted Solutions
vktr Frequent Visitor
Frequent Visitor

Re: Active Directory (AD) User Object GUID

I needed this to link AD objects to Azure AD objects.

I have found that it is enough for me to convert AD GUID values with function:

= Binary.ToText(Guid, 0)

In Azure AD GUID's have the same expression as after confersion with function above.

 

4 REPLIES 4
vktr Frequent Visitor
Frequent Visitor

Re: Active Directory (AD) User Object GUID

I needed this to link AD objects to Azure AD objects.

I have found that it is enough for me to convert AD GUID values with function:

= Binary.ToText(Guid, 0)

In Azure AD GUID's have the same expression as after confersion with function above.

 

v-ljerr-msft Super Contributor
Super Contributor

Re: Active Directory (AD) User Object GUID

Hi @vktr,


Has anyone managed to get User Object GUID from Active Directory (AD)?

It is in binary format so it must be converted to text to use it.

 

There is an example on how to convert Object SID binary to text. 

I just verified that I can successfully use the M query below which is provided in that thread to get User Object GUID from Active Directory (AD). Smiley Happy

let
    ConvertSidToStringSid = (sid) => let
        parts = BinaryFormat.Record([
            version = BinaryFormat.Byte,
            count = BinaryFormat.Byte,
            first = BinaryFormat.List(BinaryFormat.Byte, 6),
            rest = BinaryFormat.List(BinaryFormat.ByteOrder(BinaryFormat.UnsignedInteger32, ByteOrder.LittleEndian))])(sid),
        result = "S-" & Number.ToText(parts[version]) & "-" & Number.ToText(BinaryFormat.UnsignedInteger64(#binary({0, 0} & parts[first]))) & List.Accumulate(parts[rest], "", (a, b) => a & "-" & Number.ToText(b))
    in
        result,
    Source = ActiveDirectory.Domains("redmond.corp.microsoft.com"),
    redmond.corp.microsoft.com = Source{[Domain="redmond.corp.microsoft.com"]}[#"Object Categories"],
    user1 = redmond.corp.microsoft.com{[Category="user"]}[Objects],
    FilteredRows = Table.SelectRows(user1, each [displayName] = "Curt Hagenlocher"),
    #"CN=Curt Hagenlocher,OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC=com" = FilteredRows{[distinguishedName="CN=Curt Hagenlocher,OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC=com"]}[securityPrincipal],
    objectSid = #"CN=Curt Hagenlocher,OU=UserAccounts,DC=redmond,DC=corp,DC=microsoft,DC=com"[objectSid],
    stringSid = ConvertSidToStringSid(objectSid),
    #"Converted to Table" = #table(1, {{stringSid}})
in
    #"Converted to Table"

r1.PNG

 

Regards

vktr Frequent Visitor
Frequent Visitor

Re: Active Directory (AD) User Object GUID

Hi @v-ljerr-msft,

 

Yeah i know Smiley Happy I do use it for getting AD object's SID.

But as I've said, I needed to extract GUID value.

GUID is different from SID, so needed another solution to convert GUID's binary value to text, which turned up, is an eazy task.

 

Highlighted

Re: Active Directory (AD) User Object GUID

@vktr did u find solution?...i have similar issue