CODEWITHSUNDEEP
biztalkbiztalk-2010mbvbhm
SteveC
SteveC

Reputation: 16815

Is there a way to get at the queries used in the MBV / BHM

Is there a way to get at/extract the queries used in the Message Box Viewer / BizTalk Health Monitor?

Upvotes: 2

Views: 153

Answers (3)

user3931148
user3931148

Reputation: 21

The SQL queries used by BHM or MBV come from a declarative repository and also from an assembly containing .NET code. These queries are not public; if you want to see them, you can indeed use SQL profiler.

BHM and MBV use also .BAT, .VBS, WMI and PS queries. We also did not make these queries public.

JP MBV/BHM team

Upvotes: 2

zurebe-pieter
zurebe-pieter

Reputation: 3266

Regarding the SQL queries:

The MBV Q&A file mentions this 

Q: Where do the SQL queries executed by MBV come from ?
A: Some of them come directly from BizTalk Architect Lee Graber’s "Advanced Queries" 
   document. Other queries come from Microsoft BizTalk Support teams or known SQL & 
   BizTalk Troubleshooting documents.

The .doc file with the paper can be found here (mirror site I found):

Another way to do this, would be to use SQL Profiler to see what commands are being sent to SQL to see which queries are being executed.

Upvotes: 3

DTRT
DTRT

Reputation: 11050

No. They're all baked into an assembly.

If this is related to the previous question about the ESX warning, my recommendation would be to modify the output which is just an HTML page to remove of annotate the warning.

Upvotes: 2

Related Questions