SQL Queries for Packages Distribution status on Distribution Points
All Failed Packages/DPs :
SELECT distinct A.DPName, A.PackageID, B.Name, A.MessageState, A.LastStatusTime, A.SiteCode
FROM vSMS_DPStatusDetails A
JOIN SMSPackages_All B ON A.PackageID = B.PkgID
WHERE MessageState = 4
All In Progress Packages/DPs :
SELECT distinct A.DPName, A.PackageID, B.Name, A.MessageState,
A.LastStatusTime, A.SiteCode
FROM vSMS_DPStatusDetails A
JOIN SMSPackages_All A ON A.PackageID = B.PkgID
WHERE MessageState = 2
All Success Packages/DPs :
SELECT distinct A.DPName, A.PackageID, B.Name, A.MessageState, A.LastStatusTime, A.SiteCode
FROM vSMS_DPStatusDetails A
JOIN SMSPackages_All B ON A.PackageID = B.PkgID
WHERE MessageState = 1
Small Correction:
SQL Queries for Packages Distribution status on Distribution Points
All In Progress Packages/DPs :
JOIN SMSPackages_All A ON A.PackageID = B.PkgID
small correction, change the reference as “B” instead of “A”
LikeLike
This is awesome. Your blogs are really helpful.. Chris
LikeLike