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

1 Comment 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

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 )

w

Connecting to %s

%d bloggers like this: