Advertisements
Latest Posts

SQL Queries for Packages Distribution status on Distribution Points

helpful tips crossword puzzle

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

Advertisements

2 Comments on SQL Queries for Packages Distribution status on Distribution Points

  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”

    Like

  2. This is awesome. Your blogs are really helpful.. Chris

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: