asked on

Take Information from active directory dynamically and show it in a list

I want to make a list where i can get some information from active directories and make them read only information.User is not allowed to change that information .Secondly i want to take some information from user information list and display it in the same list but this information is editable.The information from active directory comes dynamically means when user access this list it information come from AD.

jlindler

Would a connection in MS Access work? If so, you can create a passthrough query like this:

select convert(varchar(50), [Name]) as FullName,
convert(varchar(50), sAMAccountName ) as LogonName,
distinguishedName as DN,
TelephoneNumber,
mail,
department

from openquery(ADSI,'select Name, sAMAccountName, distinguishedName, TelephoneNumber, mail, department
FROM ''LDAP://DC=AD,DC=MYDOMAIN,DC=COM''
WHERE objectCategory = ''Person''
AND objectClass = ''user''')

jlindler

Oops.... Missed the part about editable. The method above will only give you a read only list. (It also works with SQL by the way).

I noticed this in the web servers section.... Are you attempting to do this on a web form?

ASKER CERTIFIED SOLUTION

pr0t0c0l12

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Byteridge

ASKER

Hii jlinder,

I didn't get what u said.I am a newbie to sharepoint so please explain it.
and i am not using MS-ACCESS in my project anywhere.

jlindler

I was not sure exactly what you were looking for.... If are looking for an easy way to query AD information, the query above will work... However, you are looking for more than that. The information from pr0t0c0l12 is probably more like what you are looking for!

Byteridge

ASKER

Hii jlinder

Here is the working scrnario.I have created a list in a site and i am display some information like Username,Email address,Hobbies,Department etc.Now i want that information like username and email address come directly from AD and user can only view them not edit.and he can edit information like hobbies and dept.

There is one more question in my mind that is IS it possible in wss to get information from active directories and display them in a list dynamically.

Byteridge

ASKER

In simple words

Can user update information in active directories from site or vice versa in WSS 3.0.??

Byteridge

ASKER

Need to edit the script after that also.