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
Read MoreTag: Packages
SQL Query : List All Packages
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
Read More