Forum Discussion

NicoLemarchand's avatar
NicoLemarchand
Regular Visitor
4 years ago

Getting GID or SID fom Active Directory

Hi,    I'm facing a problem I'm not able to solve alone. I analyse usage of a web app thanks to a powerBi dashboard. Currently, as all the logs of my app identifies users with their SID, I shall ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

In our AD implementation the GID is called "primaryGroupID"  and it sits inside the "user"  attribute.

let
    Source = ActiveDirectory.Domains("domain.net"),
    domain = Source{[Domain="domain.net"]}[#"Object Categories"],
    user1 = domain{[Category="user"]}[Objects],
    #"Filtered Rows" = Table.SelectRows(user1, each Text.Contains([distinguishedName], "username")),
    #"Expanded user" = Table.ExpandRecordColumn(#"Filtered Rows", "user", {"primaryGroupID"}, {"primaryGroupID"})
in
    #"Expanded user"

 

As I understand it SIDs are machine related, not user related.