everetjo
asked on
group and user report for a particular OU
I need to produce a report, txt or preferably xls that lists all the groups in the Bizmark OU and all of the members of those groups, filtering out computer accounts. also, i'd like to list the firstname lastname instead of logon name; all logon names are by empoyee ID and are non intuitive.
I'd like teh report to look something like this.
sales
Burt Blylevin
Luke Longley
Jeb Springfield
marketing
paul allen
charles zesterhaus
etc.
I'd like teh report to look something like this.
sales
Burt Blylevin
Luke Longley
Jeb Springfield
marketing
paul allen
charles zesterhaus
etc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ms.
i get an error on line 13 char 1 saying that the directory property cannot be found in the cache
i hardcoded the AD Path info instead of rootDSE
i get an error on line 13 char 1 saying that the directory property cannot be found in the cache
i hardcoded the AD Path info instead of rootDSE
you dont need to edit on char 13.
you just need to specify the distinguished name of the ou. char 11.
you just need to specify the distinguished name of the ou. char 11.
ASKER
Im still new with VBS and I'm still having trouble.
if my full AD path is LDAP://OU=SALES, DC=hq, DC=nt, DC=domain, DC=com
how would I ensure that this OU is the focus ?
if my full AD path is LDAP://OU=SALES, DC=hq, DC=nt, DC=domain, DC=com
how would I ensure that this OU is the focus ?
GetObject("LDAP://OU=SALES , DC=hq, DC=nt, DC=domain, DC=com")
ASKER
I'm still having some problems, and I think im doing something wrong.
How would I change the code to have it look in this one OU and create an xl file with all the information present in the user objects ?
using LDAP://OU=SALES, DC=hq, DC=nt, DC=domain, DC=com, I replaced the set objRootDSE statement but I'm not sure how to proceed.
How would I change the code to have it look in this one OU and create an xl file with all the information present in the user objects ?
using LDAP://OU=SALES, DC=hq, DC=nt, DC=domain, DC=com, I replaced the set objRootDSE statement but I'm not sure how to proceed.
ASKER
got it working!! thanks MsPro
http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept05/hey0921.mspx
http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov04/hey1122.mspx
http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr05/hey0419.mspx
http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb07/hey0221.mspx
http://www.microsoft.com/technet/scriptcenter/resources/qanda/aug04/hey0817.mspx