SCCM Queries and the power of ##PRM:[VARIABLE-NAME]##

Many years ago I built a quick query in SCCM which searched the database for a device that had a particular MAC address. It works, and it does what it needs to do and this is where I left it. It’s a pain in the ass to go into the query, edit the values and manually add the query. Time to add a user prompted value like below to enter our mac address’s in. No more editing a sccm queries. 😀

It’s a simple change as well. Just replace the inverted commas with this –

The entire script: