Query to find largest SMS Package in the console

SELECT dbo.SMSPackages.PkgID as PackageID, dbo.SMSPackages.Name as [Package Name], dbo.SMSPackages.Source as [Source Location],
dbo.SMSPackages.SourceSize/1024 as [Package Size in MB], dbo.SMSPackages.SourceDate,
dbo.v_Advertisement.AdvertisementID, dbo.v_Advertisement.AdvertisementName
FROM dbo.SMSPackages INNER JOIN
dbo.v_Advertisement ON dbo.SMSPackages.PkgID = dbo.v_Advertisement.PackageID
WHERE dbo.v_Advertisement.AssignedScheduleEnabled=16 ORDER BY dbo.SMSPackages.SourceSize DESC

Description:

This query gives you all the packages exist in the SMS console with their size in MB.