I've got this query which selects data from a customers active directory, but its only returning certain top level information
Problem is, I don't really understand all about OU=, DN= etc etc
The customers directory shows like this in windows explorer
Active Directory Users and Computers
The query which is
Select PersonalTitle, Displayname, UserPrincipalName, sAMAccountName, ADsPat FROM 'LDAP://domain.establishment.edu'
I am running this from VB Script. Its bringing back users I don't want and lots of other info, but apart from that and its working fine,
1. how can I change the bit in quotes to only return USERS from LEVEL2A ?
2. Any more information on what OU=, o=, c=, cn= etc means would be great.
3. Any ideas on how I can find out what fields names are available in the select statement (I get the feeling they vary by installation ??)