Packages – System Center Configuration Manager

SQL Query : All Packages & Programs & Sources (not applications)

October 10, 2017October 10, 2017 JonMoss

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

SQL Query : List All Packages

October 10, 2017October 10, 2017 JonMoss

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