Sorry it’s taken so long but here is my 1st post (of many) since my change of Job.
In my new environment machine history isn’t retained upon a machine rebuild, so how do I determine what a machine had before it was rebuilt? Well there is no “easy” answer to this, the company historically used a vbs script to diff the uninstall reg key against a list of standard or core applications. This worked to some extent but was far from perfect and could result in very large lists of applications that were not even installed by SCCM.
This is where a collection structure comes into play, we have 2 main application top level collections “RestrictedApps” and “UnRestrictedApps” now any application that is manually pushed via SCCM and thus is not part of the build image requires membership to a collection that is a sub-collection of one of these two.
In the report the two lines with XXXXXXXX need to be changed to match your top level collections.
begin if (@__filterwildcard = '') SELECT DISTINCT SYS.Netbios_Name0 FROM v_R_System SYS ORDER By SYS.Netbios_Name0 else SELECT DISTINCT SYS.Netbios_Name0 FROM v_R_System SYS WHERE SYS.Netbios_Name0 like @__filterwildcard ORDER By SYS.Netbios_Name0 end