custom query

How do I build a report that queries a specific Organizational Unit and return all user objects that doesn't have a particular profilepath (eg. \\PATH\Profiles$\Workstations\TEST1) or a member of a certain AD group (eg. CN=List,OU=Recipients,OU=Exchange Migration,OU=Global,DC=L1,DC=COM )

Product: AD Admin Reporting Tool 5.2

Following sql will generate a report from DC=LDAPSOFT,DC=COM and return all user object that doesn't have a profiepath of \\PATH\Profiles$\Workstations\TEST1 (Please note that you have to escape all \ with \\ as shown in the query) or a member of CN=List,OU=Recipients,OU=Exchange Migration,OU=Global,DC=LDAPSOFT,DC=COM

Select cn,sn from DC=LDAPSOFT,DC=COM where profilePath!='\\\\PATH\\Profiles$\\Workstations\\TEST1' or memberof='CN=List,OU=Recipients,OU=Exchange Migration,OU=Global,DC=LDAPSOFT,DC=COM' and objectCategory='person' and objectClass='user' and sAMAccountType!=805306370

Thanks