Tag: Packages

This query is designed specifically for Packages rather than Applications. SELECT Program.PackageID, Package.Name ‘Package Name’, Program.ProgramName ‘Program Name’, Program.CommandLine, Program.Comment, Program.Description, Package.PkgSourcePath FROM [v_Program] as Program LEFT JOIN v_Package as Package on Package.PackageID = Program.PackageID Order by Program.PackageID Sample Output  

Missing as a standard report in SCCM 2012 onwards.  Use the additional line to return the name of a specific package. SELECT [PkgID]        ,[Name] FROM [osdp232a].[dbo].[SMSPackages_G] WHERE PkgID = ‘XX100854’ Sample Output