Having previously talked about the lack of the traditional HAT in BizTalk 2009, the question then becomes how do you replicate some of the functionality that was previsouly relied on?

I have already covered the Last 100 Messages Received query so what about sent messages?

In BizTalk 2004 we had a query in HAT to return the messages sent in the last day.  While not a direct replacement the following query replicates some of the usefullness of this query in a BizTalk 2009 Hatless environment.

Basically we are creating a query to search for the last one hundred tracked messages that were sent by BizTalk:

Coming up

Messages - last 50 suspended
Service instances - last 100