Existe alguma maneira de pesquisar no diretório ativo sem definir o campo para pesquisar?
-
Exportar para o csv usando
csvde -f test.csv
-
Abra
test.csv
no excel ou em um editor de texto e procure a sequência de caracteres de que você precisa.
Simplifique as tarefas administrativas exportando dados do Active Directory com 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: Basic export
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.
Fonte Simplifique as tarefas administrativas exportando dados do Active Directory com CSVDE