Reporting on Microsoft Active Directory Groups using LDAP & Crystal

[gary.pritchard]

We're using Windows 2003 server R2 & Crystal v10.

We need to provide a list of security groups and the users that are
members of those groups. We can query AD using Crystal and LDAP using
the query shown here,

select * from
'LDAP://OU=Department Groups,OU=Domain Groups,DC=[OurDomain],DC=com'

This produces a list of the security groups we need to populate for the
report. But we cannot get the list of group members associated with
each group.

Please help. This is a Sarbannes-Oxley query that will never go away no
matter how deep we bury our heads in the sand.