CDP Manage: Selecting Sent Not Confirmed Documents

Select * from document

Where datesend is not null

And remoteid is null

And dateconfirm is null

Or to get documents older than x [the value of two below can be changed to whatever you are looking for.]

Select * from

[CDPManage4].[dbo].[Document]

where cast(datesend as date)= cast (getdate()-2 as date)

and remoteid is null