Archive for July, 2014

Jul 28 2014

Deleting Inactive AD Computers from SCCM 2012

I wrote the following script to find inactive computers in Active Directory and then find & delete them from SCCM. Feel free to use & abuse as you see fit, but always run through a test environment first. My version makes sure to target only Windows Operating Systems, and excludes anything with Server in the caption – you’ll want to adjust the filter as needed in your specific environment.

Jul 21 2014

Querying for Advertisement Status in SCCM

The following query can be run in SQL against your CAS or Primary Site to collect the status of one or more advertisements. I find it useful to run this instead of the built-in reports because I can more easily link out to other sources, in this case my Active Directory Users table (v_r_user) and add/drop data as needed.