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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s