test email


SQL Query!


-- SUM Packages with count of updates in each package
SELECT PC.PkgId, P.Name, COUNT(distinct SU.CI_ID) AS NumberOfUpdates FROM fn_ListUpdateCIs(1033) SU
INNER JOIN vSMS_CIToContent CC ON CC.CI_ID = SU.CI_ID
INNER JOIN vCI_ContentPackages PC ON PC.Content_ID = CC.ContentID
JOIN SMSPackages P ON PC.PkgID = P.PkgID AND P.PackageType = 5
WHERE SU.IsContentProvisioned = 1
GROUP BY PC.PkgID, P.Name
ORDER BY COUNT(distinct SU.CI_ID) DESC


Comments (0)

Skip to main content