Search active directory organizational unit within an organizational unit PL/SQL

Question

4.00/5 (1 vote)

See more:

Hi I've done some research on this matter but can't find a real answer for this: The company needs to sync a user table with the active directory. We are using LDAP from a Oracle database to connect to the AD. Ok at first didn't sound hard BUT then researching how the Ad was organized it got complicated. The structure is at follows:

SQL

Active Directory Users and Computers
   +Saved Queries
   -Company.org
      -OrganizationalUnit(root this is where we start)
          -OU folder Regions
             +OU folder Computers
             -OU folder Users
                +Users we need
      +Other Stuff

The problem is the subtree its divided on Organizational units nested on organizational units. I've tried different approaches and as far as I have got is to list the OU Users Names, NOT the users instead, and list the OU of regions too. Just need a point in the right directions.

Posted 30-Aug-12 2:31am

rhapemerald

Updated 30-Aug-12 2:38am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

rhapemerald · Accepted Answer · 2012-09-07T10:59:00

Ok i solved my issue,

Active Directory Users and Computers  
   +Saved Queries
   -Company.org
      -OrganizationalUnit <-----Starting Position
          -OU folder Regions
             +OU folder Computers
             -OU folder Users
                +Users we need
      +Other Stuff

Aparently using the DBMS_LDAP.SCOPE_SUBTREE it let me browse through all my starting position and all in between. Just had to tweak the filter to provide the users, its final form was:

(&(&(objectCategory=user)(objectClass=user)(memberOf=*)(samaccountname='||LDAP_USER||')))

Finally i got PL/SQL procedure that searches the Active Directory and updates the users table with a valid AD email :)