F
funnybroad
In my Access Database, I need a simple table that lists the members (userids)
of a security group in Active Directory.
I don't need it for security purposes (like securing portions of my
database). I just need it for informational/reporting purposes.
Right now, I have to run a "dsget group" command from a DOS prompt, pipe the
output to a csv text file, then import/link that to a table in my Access
Database.
Problem 1: The dsget command only returns the list of group members in
"distinguished name" format: "CN=Smith\,
Bob,OU=BIG,OU=Users,DC=main,DC=company,DC=com", when what I really need is
just the userid.
Problem 2: To keep the list current in the database, I have to manually run
the "dsget group" command, etc... etc...
Is there a way in Access to create some kind of "datalink" (like you do when
you link to an SQL database table or a SharePoint list) that would return a
table of information (in this case, a list of userids within a group in
Active Directory) into Access?
of a security group in Active Directory.
I don't need it for security purposes (like securing portions of my
database). I just need it for informational/reporting purposes.
Right now, I have to run a "dsget group" command from a DOS prompt, pipe the
output to a csv text file, then import/link that to a table in my Access
Database.
Problem 1: The dsget command only returns the list of group members in
"distinguished name" format: "CN=Smith\,
Bob,OU=BIG,OU=Users,DC=main,DC=company,DC=com", when what I really need is
just the userid.
Problem 2: To keep the list current in the database, I have to manually run
the "dsget group" command, etc... etc...
Is there a way in Access to create some kind of "datalink" (like you do when
you link to an SQL database table or a SharePoint list) that would return a
table of information (in this case, a list of userids within a group in
Active Directory) into Access?