Reporting on Active Directory

I belive it is possible to use active directory as a datasource for a SQL Report Services Report.

Anyone know how I go about this?

geoff

Yes, please. I would like to know too..

Thanks

|||

I've never tried this myself nor have I ever needed to, but I did find an article about connecting to Active Directory which may be of some assistance. If anything, lead you in the right direction.

http://www.codeguru.com/csharp/csharp/cs_network/directoryservices/article.php/c6021/

According to the article, you'll have to set an assembly reference to System.DirectoryServices before connecting. If you're not sure how to do this, open the report properties and select the References tab.

Sincerely,

Micheal

|||Geoff you can use AD and i guess its possible..
You can get the data first model it to the way you want it and use the data for reporting services..
Patrick
|||

Hi,

I think that is a C# example. (which is fine I suppose, but it doesn't help me. )

Does anyone know of or have any information on how to create a report in Reporting Services 2005 that accesses Active Directory?

If I try the "Microsoft OLE DB Prodiver for Microsoft Directory Services" I can get a connection. That is, the "Test Connection" works, but then what? I can't seem to create a dataset for the report.. I don't even know if "Microsoft directory Services" is what I'm supposed to connect. I need to get a list of user names based on their UserID's because I can't tell who I've set up in Reporting Services to access reports and folders by looking at their userID's.

Does anyone know of a good tutorial or have step by step instructions on how to report on Active Directory with RS 2005?

Thanks.