Directly querying the BizTalk database for suspended messages

SELECT
nvcName as ApplicationName,
DATEADD(hh,-6,dtSuspendTimeStamp) as DateSuspended, — Subtract the appropriate hours for your timezone
nvcAdapter as Adapter,
nvcURI as URI,
nvcErrorDescription as ErrorDescription
FROM InstancesSuspended
LEFT OUTER JOIN [Services]
on InstancesSuspended.uidServiceID = [Services].uidServiceID
LEFT OUTER JOIN Modules
on Modules.nModuleID = [Services].nModuleID
WHERE DtCreated between DATEADD(dd,-7,GETUTCDATE()) and GETUTCDATE()
and nErrorCategory=0
ORDER BY dtCreated desc

article source

http://geekswithblogs.net/bosuch/archive/2010/11/29/directly-querying-the-biztalk-database-for-suspended-messages.aspx