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
Explanation:
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.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.