Active Directory and SSRS
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
January 24th, 2007 11:15pm

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.
Free Windows Admin Tool Kit Click here and download it now
January 25th, 2007 2:37am

Thank You so much for pointing me in the right direction. I was able to do what I needed. NB
January 25th, 2007 8:56pm

I'm trying to do the same thing. Can you show me the code you're using in SSRS? Thanks!
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2009 10:59pm

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...
September 14th, 2010 2:04pm

I'm having the same challenge. Would love to see the code also. Thanks
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 8:20am

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 )
March 30th, 2011 3:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics