Is there any way to search on active directory without defining the field to search?
Export to csv using
csvde -f test.csv
test.csv in excel or a text editor and look for the string you need.
Simplify admin tasks by exporting Active Directory data with CSVDE
Wouldn't it be great if we could extract the information stored in
Active Directory for use in spreadsheets and checklists? Actually we
can and it's not complicated at all!
CSVDE, what is it?
CSVDE stands for Comma Separated Value Data Exchange. CSVDE is a small
command-line tool that is included in Windows 2003 installs by default
- usually found in the %windir%/system32 directory. The application can also be installed on a Windows XP workstations as part of Active
Directory Application Mode (ADAM).
Exporting data from the directory
As we are only going to look at CSVDE's export functions, there's no
chance of damaging the directory or accidentally corrupting its data.
Therefore I think the best way to understand it is to jump right in:
The basic export will dump all records from Active Directory into a
CSV file without any filtering of results. By default CSVDE will bind
to AD using the credentials of the users currently logged on-to
specify different credentials use the -a flag (-a UserDN [Password |
To export all data from Active Directory into a file called test.csv:
csvde -f test.csv
After the export has completed a message will tell you how many
entries were exported. These ‘entries' translate into rows of data,
and you will probably notice that there are a great deal more entries
than users. This is because without any filtering CSVDE will simply
dump the entire contents of your directory into a CSV file; that
includes groups, system accounts, and other hidden values which may or
may not be of use to you. If you open test.csv with notepad, you will
be able to take a quick look at the data and all will become clear.
Source Simplify admin tasks by exporting Active Directory data with CSVDE