This was more difficult than I thought it should be. Machine, memory and last hardware inventory was easy. It was fairly easy to add the last Heartbeat but. For machines that roam each site visited would give a last heartbeat. The embedded query that filters these out was the part that gave me the most grief. If there is a better way of doing it let me know. v R System AS SYS INNER JOIN.

Prestaging Content in Configuration Manager 2012. As it is not the best documented topic so far, I thought about posting a step-by-step for the prestage option in 2012. Option to configure the prestage feature in the object properties.