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

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

 

Related posts

Leave a Comment