LDAP-SQL - exporting more than I ask for?

General Discussion about LDAP Administrator

Moderator: Support

LDAP-SQL - exporting more than I ask for?

Postby emkay » Thu Jul 26, 2012 8:11 pm

Here's my query:
SELECT $employeeID, $department, $mail, $sAMAccountName, $userAccountControl, $sn, $givenName
FROM "DC=my_Company_here,DC=com"
WHERE $objectCategory='Person' AND $objectClass='user' AND $mail<>'*net'

However, when I save the results to a CSV file, I also get DN, objectCategory and objectClass ; sAMAccountName doesn't seem to be showing up, and my fields are not exported in the order specified in my query (or displayed in my results). I also seem to get the column headers TWICE.

Is this due to something that I'm doing wrong, or is this how the browser works?

I'm using LDAP-SQL because it seems to be the least painless way to handle multiple domains and thousands of records...

Posts: 2
Joined: Wed Jul 25, 2012 6:13 pm

Re: LDAP-SQL - exporting more than I ask for?

Postby Support » Fri Jul 27, 2012 11:22 am

Thank you for the report. We are checking this issue.
Posts: 895
Joined: Sun Aug 12, 2001 12:00 am

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 5 guests