Since  in BizTalk 2009  the HAT console has been deprecated  we can now query tracking data through the Administration Console.

Just right click on the BizTalk 2009 Root Node (not the hub node) and select “Connect to Existing Tracking Database” option.

image

Then, simply select your SQL server instance and TrackigDTADb database names and ready to go!

 

image

 

After connecting, the BizTalk hub will show the tracking data as follows

 

image

By pressing F5 the date will update with the last information. Clicking on every link will show you the classical query builder section  in which you can customize the query as needed:

image

You have almost all the old HAT queries here!  and in the same place!

Note

HAT queries coming from previous versions of BizTalk will not work and you will need to re-code again in Administration Console.

Enjoy querying!   ;-)