Home » Microsoft » 70-640 » Which tool should you use?
A network contains an Active Directory forest.
The forest schema contains a custom attribute for user objects.
You need to view the custom attribute value of 500 user accounts in a Microsoft Excel table.
Which tool should you use?
A. Dsmod
B. Csvde
C. Ldifde
D. Dsrm
Correct Answer: B
Explanation/Reference:
We can achieve this by using csvde:
CSVDE -f onlyusers.csv -r "objectCategory=person" -l "CN,<CustomAttributeName>"
The exported CSV file can be viewed in Excel.
Reference:
http://technet.microsoft.com/en-us/library/cc732101.aspx
Csvde
Imports and exports data from Active Directory Domain Services (AD DS) using files that store data in the comma-separated value (CSV) format. You can also support batch operations based on the CSV file format standard.
Syntax
Csvde [-i] [-f <FileName>] [-r <LDAPFilter>] [-l <LDAPAttributeList>] (…)
Parameters
-i
Specifies import mode. If not specified, the default mode is export.
-f <FileName>
Identifies the import or export file name.
-r <LDAPFilter>
Creates an LDAP search filter for data export.
-l <LDAPAttributeList>
Sets the list of attributes to return in the results of an export query. LDAP can return attributes in any order, and csvde does not attempt to impose any order on the columns. If you omit this parameter, AD DS returns all attributes.
