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)(obje ctcategory =person))" -l "cn,sn,givenName,name,sAMA ccountName ,userPrinc ipalName,i nitials" -o "DN"
csvde -f results.csv -d "ou=users,dc=domain,dc=com
DN can't be excluded, it's the unique identifier for the object. You can't delete it afterwards?
Chris
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome, thanks this does exactly what i need.
Pleasure :)
Chris
ASKER