I downloaded an evaluation copy of AD Admin & Rpt Tool, We need to be able to export certain user attributes for user that belong to specific user groups in AD. Is there a way to accomplish this with your tool without having to do a lot of work on the result set?
That is very easy with AD Admin & Reporting tool, Open a sql window from top tool bar sql button , modify the following sql change the group names (memberof) and after select list all the attributes you want to export or view then copy and paste and click run or export.
The following statement will list sn and cn attribute of all users which are either member of 'testusergroup or 'testusergroup2'.
Select sn,cn from RootDSE where memberof='CN=testusersgroup,DC=LDAPSoft,DC=COM' or memberof='CN=testusersgroup2,DC=LDAPSoft,DC=COM' and objectclass='user'