PowerShell script to start and stop all host instances with some filter condition Skip to main content

PowerShell script to start and stop all host instances with some filter condition

Image
By
In below following complete PowerShell script is to start and stop all BizTalk host instances. There is a filter condition with '-notlike' powershell command where if you want to avoid host instance by the host name. There are two functions one is for start host instance and second one is for stop host instance. You go ahead and use accordingly your requirement.

# Import external assembly and create a new object
[void] [System.reflection.Assembly]::LoadWithPartialName("Microsoft.BizTalk.ExplorerOM")
$Catalog = New-Object Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer

 #BizTalk Config
$Catalog.ConnectionString = "SERVER=JEETU;DATABASE=BizTalkMgmtDb;Integrated Security=SSPI"  #connectionstring for the BizTalkMgmtDb
$Hostinst = "" # Define variable for host instances
$resultToWrite=""
$OutResultLog = 'E:\Biztalk\BizTalkLive\BizTalkPowerShellService\StartStopHostInstnace\logStartStopHostInstance.txt'
#$ServerName="" #Define running server name

#Function to start host instances with filter condition
function StartHostInstance()
{
    $resultToWrite='Process has started to start host instance on date : '+(Get-Date).ToString()
    Add-Content $OutResultLog $resultToWrite
    $resultToWrite=""

    #get all in-process host instances
    [ARRAY]$hostInstances = Get-WmiObject MSBTS_HostInstance -namespace "root\MicrosoftBizTalkServer" -Filter "(HostType = 1 )" # and RunningServer = '$ServerName' --If you want to add server in filter co

   foreach ($Hosts in $catalog.Hosts )
   {
       foreach($Hostinstance in $Hosts ){
       try
       {
            $Hostinst = $Hostinstance.Name
           
             foreach($hostinst1 in $hostInstances | WHERE {($_.HostName -eq $Hostinst) -and ($_.HostName -notlike 'BizTalkLive')}) {
              
                if  ($hostinst1.ServiceState -eq 1)   # 1 = host instance  is stoped
                {
                    $hostinst1.Start()
                    #Wait for few seconds
                    Start-Sleep -s 2

                    $resultToWrite=$resultToWrite+ 'Started host instance: '+$Hostinst+ ' at datetime :'+(Get-Date).ToString()
                    Add-Content $OutResultLog $resultToWrite
                    $resultToWrite=""
                }
            }
        }
        catch [Exception]
        {
            $resultToWrite=$resultToWrite+ 'Getting Exception: '+ $_.Exception.Message +' to Start host instance: '+$Hostinst+ ' at datetime: '+(Get-Date).ToString()+"`r`n"
            Add-Content $OutResultLog $resultToWrite
            $resultToWrite=""
        }

       }
}
$resultToWrite=$resultToWrite+ 'Process end to start host instance on datetime: '+(Get-Date).ToString() +"`r`n"
Add-Content $OutResultLog $resultToWrite #logged all details in log file
[void]$Catalog.Refresh()
}

#Function to stop host instances with filter condition
function StopHostInstance()
{
    $resultToWrite='Process has started to stop host instance on date : '+(Get-Date).ToString()
    Add-Content $OutResultLog $resultToWrite
    $resultToWrite=""

    #get all in-process host instances
    [ARRAY]$hostInstances = Get-WmiObject MSBTS_HostInstance -namespace "root\MicrosoftBizTalkServer" -Filter "(HostType = 1 )" # and RunningServer = '$ServerName' --If you want to add server in filter co

   foreach ($Hosts in $catalog.Hosts )
   {
       foreach($Hostinstance in $Hosts ){
       try
       {
            $Hostinst = $Hostinstance.Name
           
             foreach($hostinst1 in $hostInstances | WHERE {($_.HostName -eq $Hostinst) -and ($_.HostName -notlike 'BizTalkLive')}) {
              
                if  ($hostinst1.ServiceState -eq 4)   # 4 = host instance is running
                {
                    $hostinst1.Stop()
                    #Wait for few seconds
                    Start-Sleep -s 2

                    $resultToWrite=$resultToWrite+ 'Stopped host instance: '+$Hostinst+ ' at datetime :'+(Get-Date).ToString()
                    Add-Content $OutResultLog $resultToWrite
                    $resultToWrite=""
                }
            }
        }
        catch [Exception]
        {
            $resultToWrite=$resultToWrite+ 'Getting Exception: '+ $_.Exception.Message +' to Stop host instance: '+$Hostinst+ ' at datetime: '+(Get-Date).ToString()+"`r`n"
            Add-Content $OutResultLog $resultToWrite
            $resultToWrite=""
        }

       }
}
$resultToWrite=$resultToWrite+ 'Process end to stop host instance on datetime: '+(Get-Date).ToString() +"`r`n"
Add-Content $OutResultLog $resultToWrite #logged all details in log file
[void]$Catalog.Refresh()
}

 #call function to start host instances
   StartHostInstance

 #call function to start host instances
   StopHostInstance

!! Keep visiting BizTalkLive !!
<< Previous                                                                                                                                 Next >>
Labels:

Comments

Post a Comment

Please write comment only that belongs to this blog

Popular posts from this blog

BizTalk Interview Question and Answer

By
1. What is BizTalk? BizTalk is a middleware that sits in the middle of any two software who wish to communicate with each other and agree on some specified communication pattern. It uses SQL Server as back end database. “Microsoft BizTalk Server is an Inter-Organizational Middleware System (IOMS) that enables companies to automate business processes, through the use of adapters which are tailored to communicate with different software systems used in an enterprise. Created by Microsoft, it provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring.”                 2. What is BizTalk Server Architecture and Life Cycle of Message? BizTalk Server Architecture: Life Cycle of Message: In this simplified view, a message is received through a receive location defined...
9 comments
Read more

Configuring BizTalk WCF Timeout Values on a Binding

By
There are a number of timeout settings available in WCF bindings. Setting these timeout settings correctly can improve not only your service’s performance but also play a role in the usability and security of your service. The following timeouts are available on WCF bindings: OpenTimeout CloseTimeout SendTimeout ReceiveTimeout Open Timeout :  This property represents the amount of time a channel open operation has to complete. Send Timeout :  Use this property to set the amount of time that a send operation has to complete. When used as part of a solicit-response scenario, this value encompasses the total amount of time for the interaction to complete. If we are sending a large message, we may need to increase this timeout to allow for the request and response messages to be processed within this window. Close Timeout :  A time-stamp that is used to indicate the amount Receive Timeout :  Used by the Service Framework Layer to initialize the...
5 comments
Read more

PowerShell Script to enable BizTalk Receive Location

By
We are facing problem in BizTalk server 2016 that few of running SFTP Receive location would be stopped after some time due to sftp connectivity issue of their threshold so I am going to share PowerShell script to enable receive location by window task scheduler. Before execute following script Please do following task a. Set Server name in ConnectionString b. Set ( $hostname) host name value that is using in SFTP Receive location c. Set ( $rcvLocation) Receive location name # Import external assembly and create a new object [ void ] [ System.reflection.Assembly ]:: LoadWithPartialName( "Microsoft.BizTalk.ExplorerOM" ) $Catalog = New-Object Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer   #BizTalk Config $Catalog . ConnectionString = "SERVER=.;DATABASE=BizTalkMgmtDb;Integrated Security=SSPI"   #connectionstring for the BizTalkMgmtDb $hostname = "BizTalkServerApplication" #hostname $rcvLocation = "RL_GetAccReq_SQL...
6 comments
Read more

Publish a web service in biztalk using BizTalk WCF Service Publishing Wizard

By
Welcome you again in my Blog and let us do another mind blowing achievement that how to publish a WCF web service in BizTalk and as in previous post to Complete BizTalk project to host Schema as Web Service  so If you want to expose/publish a web service, you should run through the BizTalk WCF Service Publishing Wizard. This wizard guides you through choosing what you want to expose as a web service. This section walks you through the wizard step by step to publish WCF Web Service using  WCF-WSHttp- Step-1:  To start the wizard, go to Start, All Programs, Microsoft BizTalk Server 2016(version), BizTalk WCF Service Publishing Wizard. This fires up a welcoming screen, on which you just click Next. Consider disabling the welcoming screen for the future by checking the check box at the bottom. You will now see the screen shown in above figure. Step-2: Choose the Service Endpoint option, and choose which adapter to use. Check Enable Metadata Endpoint if you wa...
5 comments
Read more

Step by step solution of BizTalk Two-Way WCF-SQL XmlPolling in Send Port

By
I am going to share most awaited Two way WCF_SQL Two Way XmlPolling so that you can easily enhance your old SQL procedure and BizTalk Map without any big change. I know there is no content available in any website to how work with XmlPolling in WCF-SQL two-way adapter. In the last of this post you can download complete source code with an example. Please follow carefully all steps – 1. Open Microsoft Visual Studio as Administrator user and Click File>New>Project… In Installed Templates click BizTalk Projects then Empty BizTalk Server Project and Name as “BizTalkLive-WCF-SQL” and click OK. 2. Now see the below picture and create all respective folders separately for Schema, Map, Orchestration, Pipeline, Binding- 3. Create Schemas in Schema folder as shown below picture to get Account request using One Way WCF-SQL XmlPolling a) Create Envelope Schema first with Target NameSpace - http://BizTalkLive_WCF_SQL.AccountRequest b) Create Second Sch...
5 comments
Read more