Compare Active Directory and SCCM databases

Posted on June 22, 2010March 9, 2015 by Alan

There is no good way to see what systems are in Active Directory which are not in SCCM, and sometimes you may want to manually delete systems from SCCM that are no longer in AD. AD_SMS_Compare_and Cleanup.vbs does both. It creates a temporary mdb file (whether or not Access is installed), and two reports on your desktop. You may optionally delete the systems from SCCM which have been deleted from a Active Directory. Works with SCCM and SMS. You must have admin rights on the SCCM server. Rename to .vbs. [6/23 fixed link]

Tags: SMS, SCCM

2 thoughts on “Compare Active Directory and SCCM databases”

untiltheshout says:

June 22, 2010 at 7:33 PM

Hey Alan…the link isn’t working.

https://www.akaplan.com/AD_20SMS_20Compare_20and_20Cleanup.txt

=(
Alan says:

September 29, 2010 at 10:33 AM

Should work now

You must be logged in to post a comment.

All the scripts are saved as .txt files. Newer files have a “View Script” button which will let you save or open a script in notepad. For earlier posts, the easiest way to download with IE is to right click on the link and use “Save Target As”. Rename file from Name_ext.txt to Name.ext.

To see a full post after searching, please click on the title.

PowerShell Scripts were written with version 3 or later.

https connections are supported.

All new users accounts must be approved, as are comments. Please be patient. If you find a post error or a script which doesn’t work as expected, I appreciate being notified. My email is my first name at the domain name, and you are welcome to contact me that way.

2 thoughts on “Compare Active Directory and SCCM databases”

Leave a Reply