bsharath
asked on
Export these data from ADS
Hi,
I want a way to export the description,User full name,NT login,Email address of all users to a file.
REgards
Sharath
I want a way to export the description,User full name,NT login,Email address of all users to a file.
REgards
Sharath
ASKER
Yes i have a exchange server...
Download adfind tool from: http://www.joeware.net/freetools/tools/adfind/index.htm
Syntax would be something like: "adfind -b dc=xyz,dc=com -f "objectcategory=user" description,displayname,sa mid,mailni ckname"
Syntax would be something like: "adfind -b dc=xyz,dc=com -f "objectcategory=user" description,displayname,sa
ASKER
I used this command
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "objectcategory=user"
description,displayname,sa mid,mailni ckname > c:\desc.txt
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
I got this.
dn:CN=Sharath Reddy,OU=Named Accounts,OU=User Accounts,OU=IND,OU=Countri es,DC=Deve lopment,DC =Group,DC= co,DC=uk
C:\>adfind -b dc=development,dc=group,dc
description,displayname,sa
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
I got this.
dn:CN=Sharath Reddy,OU=Named Accounts,OU=User Accounts,OU=IND,OU=Countri
Try this:
adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=person)( samaccount name=*)"
description cn samaccountname mailnickname -nodn -nolabel -csv > c:\desc.txt
adfind -b dc=development,dc=group,dc
description cn samaccountname mailnickname -nodn -nolabel -csv > c:\desc.txt
ASKER
I get this
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname mailnickname -nodn -nolabel
-csv > c:\desc.txt
ldap_get_next_page_s: [in-ads-srv02.Development. Group.co.u k] Error 0x57 (87
) - Filter Error
C:\>adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
-csv > c:\desc.txt
ldap_get_next_page_s: [in-ads-srv02.Development.
) - Filter Error
I have tested it in environment without Echange so lose Exchange attribute:
adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname -nodn -nolabel
-csv > c:\desc.txt
Any difference?
adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
-csv > c:\desc.txt
Any difference?
ASKER
I get this.
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname -nodn -nolabel-csv > c:\desc
.txt
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
ERROR: Bad Command Line Arg(s)
ERROR: nolabel-csv
C:\>adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
.txt
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
ERROR: Bad Command Line Arg(s)
ERROR: nolabel-csv
ASKER
Any help....
Typo, one space is missing:
adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname -nodn -nolabel -csv
adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
ASKER
Still get this.
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname -nodn -nolabel -csv
"cn","samaccountname"
ldap_get_next_page_s: [in-ads-srv02.Development. Group.co.u k] Error 0x57 (87
) - Filter Error
C:\>adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
"cn","samaccountname"
ldap_get_next_page_s: [in-ads-srv02.Development.
) - Filter Error
There are spaces between these switches "-nodn -nolabel -csv", your error is genereted, beacuse you are missing space here: "-nolabel -csv"
adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname -nodn -nolabel
-csv > c:\desc.txt
adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
-csv > c:\desc.txt
ASKER
I get this
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname-nodn-nolabe l-csv
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
Using server: in-ads-srv02.Development.G roup.co.uk :389
Directory: Windows Server 2003
ldap_get_next_page_s: [in-ads-srv02.Development. Group.co.u k] Error 0x57 (87
) - Filter Error
0 Objects returned
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname-nodn -nolabel-csv
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
ERROR: Bad Command Line Arg(s)
ERROR: nolabel-csv
Type AdFind /help or AdFind /? for usage assistance.
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname -nodn-nolabel-csv
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
ERROR: Bad Command Line Arg(s)
ERROR: nodn-nolabel-csv
Type AdFind /help or AdFind /? for usage assistance.
C:\>adfind -b dc=development,dc=group,dc =co,dc=uk -f "&(objectcategory=pers
on)(samaccountname=*)"desc ription cn samaccountname -nodn -nolabel -csv
cn,"samaccountname"
ldap_get_next_page_s: [in-ads-srv02.Development. Group.co.u k] Error 0x57 (87
) - Filter Error
C:\>adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
Using server: in-ads-srv02.Development.G
Directory: Windows Server 2003
ldap_get_next_page_s: [in-ads-srv02.Development.
) - Filter Error
0 Objects returned
C:\>adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
ERROR: Bad Command Line Arg(s)
ERROR: nolabel-csv
Type AdFind /help or AdFind /? for usage assistance.
C:\>adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
AdFind V01.36.00cpp Joe Richards (joe@joeware.net) February 2007
ERROR: Bad Command Line Arg(s)
ERROR: nodn-nolabel-csv
Type AdFind /help or AdFind /? for usage assistance.
C:\>adfind -b dc=development,dc=group,dc
on)(samaccountname=*)"desc
cn,"samaccountname"
ldap_get_next_page_s: [in-ads-srv02.Development.
) - Filter Error
ASKER
I have tryed with and without spaces....
Hi!
I have uploaded txt file which has command that's working to: https://filedb.experts-exchange.com/incoming/ee-stuff/3704-adfind.txt
HTH
Toni
I have uploaded txt file which has command that's working to: https://filedb.experts-exchange.com/incoming/ee-stuff/3704-adfind.txt
HTH
Toni
ASKER
Thanks get it now.
"1878","Rajesh Rayen","RajeshR","and","an d"
"1879","Sharath Reddy","SharathR","and","a nd"
But no emailid?
Regards
Sharath
"1878","Rajesh Rayen","RajeshR","and","an
"1879","Sharath Reddy","SharathR","and","a
But no emailid?
Regards
Sharath
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Full name is not an AD property, can you be more specific? Do you have Exchange Server in your organization?
Toni