I may not get all the attributes right, since I'm not connected to a server right now...
<cfldap action="query" name="results" scope="subtree" base="ou=myOU,dc=domain,dc=com" attributes="cn,mailNickname,proxyAddresses" filter="(&(objectClass=User)(mail=*))" server="domcontroller" username="" password="" > That code should get you the records from AD. Since proxyAddresses is a multi-value attribute, you will need to handle those accordingly. By default, they will be comma-separated, if there are more than one value. The filter says: Any object that is a User AND also has an email address. You may need to adjust this for your needs. Then, loop over the ldap query and create your csv file using CFFILE. There were some recent cf-talk posts on using java to save data to files, in case your data is very large. M!ke -----Original Message----- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 6:02 AM To: CF-Talk Subject: RE: CFLDAP Question ? Hi Mike Going to use a different approach What code would I need to dump the following information from Active Directory (CN, mailnickname, ProxyAddressses) to a .CSV file for all users in a certain OU? Any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236127 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
