It's time for our first June TechNet Guru winner!
Ron Phillips (El Bo) is our BizTalk TechNet Guru for June! See the TechNet Guru Contributions for June 2013.
About El Bo: Native of the San Francisco Bay Area, attended U.C. Berkeley (History major, I learned to code in high school). Once long ago I was a dBase/Clipper developer, and was the lead developer of a commercial code generator (Smart Templates). Then a Visual Basic/SQL developer, and then starting in 2000 a BizTalk developer (yes, I really did use BizTalk 2000).
Here is El Bo's winning article:
BizTalk: Monitoring and Automatically Starting Host Instances Via A Scheduled Task
Here are all the June BizTalk winners:
Thanks to Ron, Abhijit, and Mohit! We had a great collection of articles for our first month for the BizTalk Technical Guru competition! And congrats to Ron! We'll feature your article in a variety of ways (including this blog post)! The four BizTalk contributions are here.
And here's an excerpt from the article:
To start, you need to be able to query the BizTalk management database. WMI gives us an easy hook for this:
objWMIService = GetObject(
Now you can look around in the management database with SQL queries - well, really simple ones. Finding out what will and won't work requires some trial and error. For example, our final script lets you provide a list of host names to check (rather than all of the hosts on the machine - there may be some where you want to sometimes take a host instance offline temporarily). So you would think we'd query the database for a specific host name.
But that WHERE clause on the query just doesn't work, so we grab all of them and iterate through the list:
colHostInstances = objWMIService.ExecQuery(
"Select * from MSBTS_HostInstance Where HostType=1 And IsDisabled=False "
That gives us a collection of host instances. In our script, we iterate through that to find a particular one.
Read the rest here:
Thanks to Ron for your great contribution to the TechNet Guru contest! You can read about all the June winners here: TechNet Guru Award Winners - June 2013
Also, for the July Guru competition, see TechNet Guru Contributions for July 2013.
Are you a Wiki Ninja? http://technet.com/wiki
- User Ed