Need to read Active Directory users to create a SSRS report
I need to get a list of all enabled Active Directory users into a table including name, user name, some other fields and account status. I am very new to Active Directory but experanced with SSIS and SSRS. My end goal will be to create a SSRS report matching all Active Directory users with an HR employee table reporting on any Active Directory accounts that are active for any non-active employees.
March 11th, 2011 7:00pm

Hi Rlholmes2, In reporting services, to query Active Directory users info, if you have permission to do it, follow these steps: 1. Create a Directory Services Data Source. Data Source Type->OLE DB and its Provider->OLE DB Provider for Microsoft Directory Services. 2. Under the datasource, you can create a report query with LDAP query to retrieve the direcory info you want. See http://technet.microsoft.com/en-us/library/ee692831.aspx on more informtion about LDAP query. For example, the following is to return username, SELECT ADsPath, cn ,objectCategory,name FROM 'LDAP://DC=ourdomainname,DC=corporation,DC=companyname,DC=com' where objectCategory = 'user' additionaly, i would suggest you ask more detailed questions about LDAP query in Microsoft windows server forum. If you want to implement ETL solution with SSIS to get the directory data into database tables, it is the same thought as above. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
March 12th, 2011 1:58am

Hi Jerry, The query given by you is perfectly working fine. But I have a question that how will I got a group name for a given user or a all user name for a given group. Thanks in Advance.
June 13th, 2011 6:43am

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

Other recent topics Other recent topics