This content originally appeared on moyerteam.com (no longer active) and has been reproduced with permission of the author, Jamie Moyer.
What packages are pending removal from DP?
select * from v_PackageStatusDistPointsSumm where installstatus = 'Waiting to remove package'