SCCM IP Check Script to Remove All of the Stale Systems from AD

SCCM IP Check Script When Troubleshooting client agent health issues at my current customer, I wanted to eliminate all of the stale systems from AD so I didn’t waste my time on them (and, of course, the customer was no real help here).

I wrote a script to take a list of systems, check if a forward and a reverse DNS entry exists, and compare the DNS reverse entry (if it exists) to the system’s name as specified in the list.

Using these checks, I can now identify systems that probably don’t exist anymore and can be deleted from or disabled in Active Directory, thus allowing ConfigMgr to be cleaned up. Sample output:

SCCM IP Check Script

SCCM IP Check Script to Remove All of the Stale Systems from AD -Fig.1
SCCM IP Check Script to Remove All of the Stale Systems from AD -Fig.1

Actual/exact interpretations of each category are possibly subjective and based on the configuration of a particular environment.

Patch My PC
[sibwp_form id=2]

Still, the IP registered to another system and could not resolve the IP indicated as stale systems. Recall that AD System Discovery also does a forward DNS lookup on systems before creating a DDR.

This script follows a similar logic to the discovery; however, once the system is discovered, AD Discovery won’t remove it, and thus, this script. Also, AD Discovery doesn’t do a reverse lookup because this may or may not be configured in any given environment. SCCM IP Check Script.

The script is a PowerShell script and can be run on any system that can query the internal DNS. By default, it pulls the names of systems to check from a file called sys.txt in the same directory as the script; place each system name to query on a separate line.

Then, run it from a PowerShell command prompt. To output the results to a CSV, pipe the output of the script to the Export-CSV commandlet, e.g., .\IPCheck.ps1
Export-Csv c:\IpCheckResults.csv

Adaptiva

Log in to the original Post to download the script –> http://myitforum.com/cs2/blogs/jsandys/archive/2011/01/06/configmgr-client-ip-check-script.aspx

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.