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'
SCOPE SUBTREE REFERRALS TRUE PAGESIZE 9999;

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

Thanks
emkay
 
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.
Support
 
Posts: 886
Joined: Sun Aug 12, 2001 12:00 am


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron