I think it’s common problem as Active Directory gets bigger in businesses, control over content material of that mission critical part appears to be like lost. Same took place in my place. In addition to that we had to provide advice from AD on a daily basis in a sort of report. We had no tools to tug all data from AD, method it and existing in some readable format.
However, I was operating with skilled SQL guy who was also fantastic in Reporting Services. So, I proposed that we can link Active Directory with SQL Server and use Transact SQL to drag tips from AD, manner it on SQL after which make it readable and presentable through Reporting Services. That would allow SQL guy to system all information and do all type of reporting required.