This query will list all Pacakges within SMS.

 

SELECT
 vPackage.PkgID AS ‘SMSPKGID’,
 vPackage.Name AS ‘Name’,
 vPackage.Version AS ‘Version’,
 vPackage.Language AS ‘Language’,
 vPackage.Manufacturer AS ‘Manufacturer’,
 vPackage.Description AS ‘Description’
FROM
 vPackage vPackage
ORDER By
 vPackage.PkgID