Link to home
Start Free TrialLog in
Avatar of josgan
josgan

asked on

Omit DN information from csvde results

I'm trying to create a csv to import users into a database. I'm using the command below and everything works other than i cannot seem to omit the dn in the results file. Any clues?

csvde -f results.csv -d "ou=users,dc=domain,dc=com" -r (&(obbjectClass=user)(objectcategory=person))" -l "cn,sn,givenName,name,sAMAccountName,userPrincipalName,initials" -o "DN"
Avatar of josgan
josgan

ASKER

need this answer so i'm increasing the points.
Avatar of Chris Dent

DN can't be excluded, it's the unique identifier for the object. You can't delete it afterwards?

Chris
Avatar of josgan

ASKER

I want to do a straight import into SQL, and the DN information is messing that whole process up. I'm creating a searchable database users can use to check to see if their account exists.
ASKER CERTIFIED SOLUTION
Avatar of Chris Dent
Chris Dent
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of josgan

ASKER

Awesome, thanks this does exactly what i need.

Pleasure :)

Chris