Deployment Management Report

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.

Prompt:

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

Downloads:

• [download id=”40″]