galaumiy
-
Total Posts
:
3
- Scores: 0
-
Reward points
:
0
- Joined: 5/9/2011
-
Status: offline
|
Users export not fully working
Wednesday, November 16, 2011 12:29 AM
( permalink)
Dear forummembers, There is some bug inside this vbscript which I found from the internet and I really need this. The bug is that not all users are shown in the output of the csv file. Example 404 users out of 742. Can any of you help me discovering the error? Thank you. See here: http://www.waynezim.com/2009/05/list-all-active-directory-user-accounts-in-a-csv/
<message edited by galaumiy on Wednesday, November 16, 2011 12:30 AM>
|
|
|
|
Wakawaka
-
Total Posts
:
456
- Scores: 23
-
Reward points
:
0
- Joined: 8/27/2009
-
Status: offline
|
Re:Users export not fully working
Wednesday, November 16, 2011 1:19 AM
( permalink)
Are all your users in the same OU? What does your SELECT statement look like for the command text of the command object?
|
|
|
|
galaumiy
-
Total Posts
:
3
- Scores: 0
-
Reward points
:
0
- Joined: 5/9/2011
-
Status: offline
|
Re:Users export not fully working
Wednesday, November 16, 2011 8:09 PM
( permalink)
Hello, The needed ones are all inside one OU --> SharepointUsers. But I use the whole domainname to recheck all users in the Active Directory: The domainname = DTCSP07.local Sorry, copying goes not very well here with IE9, but these are the 3 lines: objCommand.CommandText = _ "SELECT Name, description, profilePath, homeDrive, distinguishedName,userAccountControl FROM 'LDAP://dc=DTCSP07,dc=local' WHERE objectCategory='user'" Set objRecordSet = objCommand.Execute Thank you.
|
|
|
|