Is it possible to create a report in SSRS that queries Active Directory data such as user's phone extension, email addressetc What would be a good way to do this? Thanks, Nisha

I haven't done this but probably the easiest way will be to use the OLE DB Provider for Microsoft Directory Services. When setting up the data source, choose the OLE DB option and then click the Edit button which will bring you to all OLE DB providers installed.

Thank You so much for pointing me in the right direction. I was able to do what I needed. NB

I'm trying to do the same thing. Can you show me the code you're using in SSRS? Thanks!

Hi, I want to implement similar kind of stuff... access user information availabel in Active directory from SSRS 2008 Can you share the code.... Thanks in advance...

I'm having the same challenge. Would love to see the code also. Thanks

I access active directory from RS 2005. We store a list of companies a user is authorized to access. Based on the passed userid it returns the values to the calling parameter as a string. The format returned = 1,36,90 The first value becomes the default company and then all of them are placed in a drop down box so the user can select any of them. I'm sure there is some setup work but the DBA does all that. ALTER PROCEDURE [dbo].[spConoList] @UserId nvarchar(20) AS SELECT CASE WHEN employeenumber IS NULL THEN '999' ELSE employeenumber END AS ConoList FROM OPENQUERY(adsi, 'select samaccountname,employeenumber from ''LDAP://OU=wilsonart,DC=wi,DC=rwp,DC=com'' ' ) AS derivedtbl_1 WHERE ('wi\' + samaccountname = @UserID )