Report of users in specific user group

[dshu]

Is it possible to create reports based on AD group membership?

IE 'Report : All users in group UK-Marketing'

Cheers

[dshu]

Sorted it, for anyone interested the following works for me :

Select Top 1000000 tblADusers.DisplayName,
tblADusers.Displayname,
tblADusers.Office,
tblADGroups.Name As 'Active Directory Group Name'
From tblADusers
Left Join tblADMembership On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Left Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Where tblADGroups.Name Like 'YOUR-GROUP-NAME!'
Order By tblADusers.Name

[dshu]

If I search for a user and click on a group they're a member of, the report is produced exactly as I'd like to use but more permanently. Any way to convert the on-the-fly report? Or to expose the underlying SQL ?