With SCCM 2012 onwards, in the event you make queries that determine machines that do not have Software X installed, it may be used for deployments (perhaps with yet another prerequisite of the computer becoming a member of the Advertisement team?). Just one instance of CMPivot can run concurrently http://jaredzvgcu.ampblogs.com/How-SCCM-SQL-Query-for-Add-Remove-Programs-can-Save-You-Time-Stress-and-Money--25204825