Hello, Is there any easier way to clear out the entire unprovisioned computers through a script rather than one at a time? Is that considered a collection and if so what's the collection ID or how would I find it? Thanks.

Do you mean where a machine has no client installed so that you just want to clear it from the database? If that is the case i made a collection of those computers and then you can right click on the collection and Delete Special which removes them from the database. Keep in mind though that something in AD Computer discovery might pick them up again. My WQL for the report is select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where (Client = 0 or Client is NULL) Hope this helps

You can use SELECT * FROM SMS_R_System WHERE Unknown=1 to create a new collection and delete all from there.

Under the OSD section, there's a Unprovisioned Computers container. It lists the Name as Unknown, the MAC Add, Agent site, and System UUID.