 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Advanced Techniques / December 2004CFLDAP Query not quite right...
I am using this query: <cfldap name="qGetUsers" server="myServer" action="query" attributes="sAMAccountName" scope="subtree" start="ou=-hnmc,dc=hnmc,dc=com" filter="(&(objectClass=User))" username="#dclogin_username#" password="#dclogin_password#" <cfoutput query="qGetUsers"> #sAMAccountName#<br> </cfoutput> The problem is that it returns both Users and Computer Names. How do I get it to return just the usernames. And also... how do I drop this information into a database table (SQL 2000)....? Thanks, Jones > filter="(&(objectClass=User))" Your guess is as good as mine as to why, but "computers" are also in the objectClass "user". I would instead filter on objectCategory instead; it seems to make the differentiation that you want. A very handy tool for investigating these things is Softerra's LDAP Browser... it's a lot easier for poking around the place than using CFLDAP, and you can run test queries on it and such like. Great tool. > how do I drop this information into a database table (SQL 2000)....? Err... Loop over it, insert it into the DB. Not sure there's a quicker way. Although maybe there's an LDAP connector for MS-SQL 2k? Might be worth looking at.  SignatureAdam Try outputing the samAccountType, and see if that gives you a distinction between username and computername. I think that it does, but I don't remember which value it is. Then, you can use that attribute/value pair as your filter. To input this data into a SQL table, simply loop through the query ("qGetUsers") and insert into a table. Hope that this helps. Thanks. CHris > filter="(&(objectClass=User))" Your guess is as good as mine as to why, but "computers" are also in the objectClass "user". I would instead filter on objectCategory instead; it seems to make the differentiation that you want. A very handy tool for investigating these things is Softerra's LDAP Browser... it's a lot easier for poking around the place than using CFLDAP, and you can run test queries on it and such like. Great tool. > how do I drop this information into a database table (SQL 2000)....? Err... Loop over it, insert it into the DB. Not sure there's a quicker way. Although maybe there's an LDAP connector for MS-SQL 2k? Might be worth looking at. -- Adam |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.