PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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.
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 inany order, and
csvde does not attempt to impose any order on the columns. If you omit this parameter, AD DS returns all
attributes.


Leave a Reply