HAT base ‘Service Instances’ queries

Hey all,

I'm trying to port out a .NET app to provide a graphical 'dashboard' for my support group that will offer them a one page view of the current health of our Biztalk server (2004), and then allow them to drill into a running instance and see the details.  I don't want to open up the HAT application to them however.

I currently have a web app that uses a custom database for transactional tracking to assist with support issues and I want to add the following metrics to a page based on the queries. (I've tried to catch them using SQL Profiler to no avail for some reason).

Desired Summary Metrics:
Service Name
Service Status (Active/Dehydrated as shown on HAT)
Activation Time
Number of messages within the instance that have NOT been processed yet (delivered, not consumed status I would guess)
Error Description (if service failed)

Anybody have any thoughts on this?  Should I truly be able to extract queries from SQL Profiler while running the base service queries in HAT?

Thanks,
-Rich