How to get AD information into SCCM Configmgr Database for multiple tasks

Getting AD information into SCCM Database can be done using AD discovery Methods From SCCM Configmgr but there are cases where in some of the computers may not be discovered or Computers do not exist in AD but do avilable in SCCM Database.

I used MaikKoster Old blog post as reference and made some customizations/Updates in the query to retrieve information about only Active Computers (Exclude disabled Machines).

Comparing AD Computer information with SCCM Database sometimes interesting to know about client health and are there any missing out clients did not discover into SCCM Database.

This also helps you to focus more on clients inventory issues .There are cases where in User will be logged into domain(last logon timestamp) but client will not report to site .With this you can create hardware inventory report for computers not reported with in X number of Days with AD last logon Timestamp.(if your discovery is not customized and run frequently).

You can use this procedure in SMS 2003, SCCM 2007 and SCCM 2012 environments.
Read the Full Article on http://eskonr.com/2012/12/how-to-get-ad-computer-info-into-sccm-configmgr-20072012-database/