e3f03663-dcff-4a79-9a2a-f193a786e042 CentralSite 29.7cm true 21cm 0.25cm true 0.5cm 0.5cm true 1.25cm 19.5cm 1 0.25cm 0cm 19.5cm true 0.25cm 1cm Programs Missing MSI Product ID 1.5cm true 0.5cm f5fab6a7-c43a-4144-8535-6df85cef555a 21cm PkgID System.String Manufacturer System.String Name System.String Version System.String CentralSite SELECT tpr.PkgID, vpa.Manufacturer, vpa.Name, vpa.Version FROM PkgPrograms tpr INNER JOIN v_Package vpa ON tpr.PkgID = vpa.PackageID WHERE vpa.PackageType = '0' -- Application Packages AND tpr.Command like '%msi%' AND tpr.PkgID NOT IN ( SELECT PkgID FROM PkgPrograms WHERE MSIProductID <> '' ) GROUP BY tpr.PkgID,vpa.Manufacturer,vpa.Name,vpa.Version ORDER BY Manufacturer, Name true 20cm 1cm 0.5cm 18.5cm 1 true 1cm 0.63492cm ="Total Packages without MSI Product IDs: " + CountRows("Programs").ToString() Programs1.5cm18.5cm

PkgID 1 true =Fields!PkgID.Value Manufacturer true =Fields!Manufacturer.Value + " " + Fields!Name.Value + " " + Fields!Version.Value + " " 0.63492cm

textbox1 3 true =Fields!PkgID.Value Package ID textbox2 2 true =Fields!Manufacturer.Value Package 0.63492cm true

4.05064cm 14.44936cm 1.26984cm1cm 25.7cm en-US true 0.25cm 19.5cm 2 0.25cm 0cm 0.5cm 8.25cm 1 true 0.25cm 0.63492cm ="Report Generated on: " + Now().ToString() 0.5cm 5.03968cm true 14.75cm 0.63492cm ="Page: " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString() 1.5cm true 0.5cm 29.7cm