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?

In BizTalk 2004 we had a query in HAT to return the messages received 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 received by BizTalk:

Coming up:

Messages - last 100 sent
Messages - last 50 suspended
Service instances - last 100