Skip navigation

In Active Directory you could search using the ldap filter (ANR=JOSH) and it would return any object where the search string ‘JOSH’ is a part of the the givenName, SN, mail…basically any attibute that has ‘searchFlags=0’ in its schema entry.

In SQL you would use the keyword ‘LIKE’ for the same effect. Although, in SQL you would have to specify the column names to query.

I can’t tell you how much time this would have saved me in the past. I want to weep.

 

Advertisements

One Comment

  1. As Matt mentioned on the phone…It’s not like SQL ‘LIKE’…in LDAP that would be ‘*’…as in (cn=josh*)…there isn’t really an analog in SQL. On the phone we kind of went through the mental gymnastics to see what it would take. It went somehting like…1. Query the schema and insert into an in-memeory table all of the column names that you might think are important…then 2.) snore…

    I can’t even bring myself to finish it. That’s why LDAP is better for people data.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: