Package Deployment Status with Deployment ID

Note:- Replace stars (***) with Deployment ID(Example:- PS120001)

select
vc.Name as 'CollectionName',
pkg.Name as 'Pacakge Name',
sys.Name0 as 'Host Name',
sys.User_Name0 as 'User Name',
ads.LastAcceptanceStateName as 'Package Acceptance Status',
ads.LastAcceptanceStatusTime as 'Last Stuats',
ads.LastStateName as 'Package Status',
ads.LastStatusMessageIDName as 'Last Message ID',
ads.LastExecutionResult as 'Execution Result'
from v_Advertisement as adv
inner join v_Package pkg on pkg.PackageID = adv.PackageID
inner join v_ClientAdvertisementStatus as ads on adv.AdvertisementID=ads.AdvertisementID
inner join v_R_System as sys on ads.ResourceID=sys.ResourceID
inner join v_Collection as VC on adv.CollectionID=VC.CollectionID
Where adv.AdvertisementID = '******'
order by ads.LastStateName

Query Result:-