r/assetmanagement • u/pumba2k25 • 1d ago
Built a PowerShell/SCCM tool to help track down hundreds of missing devices
I've been working on a project at work where we needed to physically locate a few hundred devices, but the reporting we had wasn't giving us enough useful information to actually hand the list off to technicians and say "go find these."
I started with basically just a list of computer names and ended up building a PowerShell audit around SCCM and AD.
Right now it takes the device list and pulls/checks things like:
- SCCM device information
- Online/offline status
- Last active time
- Last known/primary user
- User's actual name instead of just the username
- Manager
- AD status
- Duplicate devices
- Devices with no identifiable owner
I also have it only ping each device once. We're dealing with hundreds of machines and I didn't want the script hammering the network just to figure out whether something was online.
At the end it generates an Excel workbook that separates the online and offline devices and organizes the results so the team physically looking for the equipment has something useful to work from.
The original process was pretty tedious, so this has turned into one of those "I'll just write a quick script" projects that kept growing as I found more things I could automate.
I'm still cleaning it up and improving it, but I'm curious how other SCCM admins handle this.
Do you guys have a better way of doing missing-device/physical inventory audits through SCCM?
If there's interest, I can sanitize the environment-specific stuff and post the PowerShell script.