Hello,
ON Active Directory, I try to obtain the list of person contain in all group
I try this script under, I have a result for "GroupKey" and "GroupName" but no information for "KEY_User" the field is empty maybe I have do something wrong.
Someone have an Idea?
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OLEDB CONNECT TO [Provider=ADsDSOObject;Encrypt Password=False;Data Source=LDAP://i1mgt00;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648];
groups:
load
distinguishedName as GroupKey,
cn as "Group Name",
subfield(member, ',') as KEY_User;
sql select distinguishedName,cn,member from 'LDAP://i1mgt00' WHERE objectCategory = 'Group';
Thank