Query AD in Reporting Services

Last Post 01 Dec 2005 02:02 PM by kskistad. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

01 Dec 2005 02:02 PM
I want to query our companies Active Directory for users/groups information. I haven't found any good information on constructing SQL-like queries using the OLEDB directory provider. The examples I've found use linked servers, but I want to just use SQL syntax using the OLDDB provider if possible.

The query would have to accept parameters, so the user can enter a user name and list the groups they belong to, or pick a group and see which users are in it.



Acceptable Use Policy