BizTalk Monday, 2017-07-31

The weekly BizTalk Monday. A collection of Microsoft BizTalk and script related updates from last week.

BizTalk Forum Threads

Description: Various BizTalk related forum threads from MS MSDN.

Email Alert in case of any message gets suspended in Group Hub BizTalk Server

URL: https://social.msdn.microsoft.com/Forums/en-US/30932983-73d5-41a9-80a8-3a934ca95d1b/email-alert-in-case-of-any-message-gets-suspended-in-group-hub-biztalk-server?forum=biztalkgeneral
Quote:

Hi friends, I am using below scripts in PowerShell to get email alert in case of any message gets suspended in Group Hub.It's working fine. Now I don't want email alert if the no. of suspended messages in group Hub is 0. How to apply in below scripts. # Import external assembly and create a new object [void] [System.reflection.Assembly]::LoadWithPartialName("Microsoft.BizTalk.ExplorerOM") [ ...Read more

Code from additional assembly

URL: https://social.msdn.microsoft.com/Forums/en-US/d78df827-ce29-49f6-b519-473ae5677419/code-from-additional-assembly?forum=biztalkgeneral
Quote:

Hi everyone. In my BizTalk project I have additional class library which contains data into collection and I want read data from collection and set value to message field into Map. How can I read data from class library inside Script functoid? I tried to reed data into script functoid using orchestration variables, but script functoid didn't recognise my library. Thank. E.T. ...Read more

Message Assignment Shape

URL: https://social.msdn.microsoft.com/Forums/en-US/5c5beff6-b4ec-4298-876f-cb50d925b745/message-assignment-shape?forum=biztalkgeneral
Quote:

Hello everyone ! I wrote a BizTalk project which should set a relationship between two entities in dynamic CRM. For achieve this goal I used Associate message from organisation service. And as you know associate message gets GUID of two entities record, but in my orchestration I saved GUID's in to additional class library. I thought to use Message Assignment shape but it didn't solve my proble ...Read more

BizTalk ESB error - Could not load Microsoft.Practices.ESB.Filters.XPath.dll

URL: https://social.msdn.microsoft.com/Forums/en-US/91aa1861-cbbc-4198-87c8-e518859927fb/biztalk-esb-error-could-not-load-microsoftpracticesesbfiltersxpathdll?forum=biztalkesb
Quote:

Hi, While using filters in Itineraries, am getting following error. I have this dll in GAC. Could not load file or assembly 'Microsoft.Practices.ESB.Filters.XPath, Version=2.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. Thanks, Praveen Praveen ...Read more

Logic Apps Vs BizTalk Server

URL: https://social.msdn.microsoft.com/Forums/en-US/de98495a-9395-4468-933c-92bedf7d80da/logic-apps-vs-biztalk-server?forum=biztalkgeneral
Quote:

Hi All, Can Logic apps replace BizTalk on premise? Are there any limitation of Logic apps which need BizTalk Onpremise to be used? Thanks & Regards, Uday. ...Read more

BizTalk scripts

Description: Newly released BizTalk scripts from MS Script Center.

PowerShell to Check if Windows Defender is running on the Server

URL: https://gallery.technet.microsoft.com/scriptcenter/PowerShell-to-Check-if-811b83bc
Quote:

Anti-virus can have a huge impact on BizTalk Server performance. This simple PowerShell script will help you validating if Windows Defender is running on the server. ...Read more

Other newly released scripts

Description: Other newly released scripts from MS Script Center.

Dynamic DataBase Structure - Convert Rows to Columns Using Dynamic Pivot

URL: https://gallery.technet.microsoft.com/scriptcenter/Dynamic-DataBase-Structure-23911424
Quote:

This SQL Script converts rows to columns Using Dynamic Pivot to simulate a Dynamic Database Structure. ...Read more

How to send an e-mail through Office 365 using PowerShell

URL: https://gallery.technet.microsoft.com/scriptcenter/How-to-send-an-e-mail-13ea23c9
Quote:

This script allows to send an e-mail through Office 365 using SMTP service available in the platform. The script defines a function that encapsulates all the required parameters to be able to send an e-mail by means of Office 365 SMTP service. These parameters are used to configu ...Read more

Set the Computer Description

URL: https://gallery.technet.microsoft.com/scriptcenter/Set-the-Computer-e0c8a68a
Quote:

This Script can be used on all Windows Workstations as a logon script and execute the script to open the textbox to enter the Computer description as we like to change. As we type the computer description name in any format like text or alphanumeric etc.,This script will update t ...Read more

Delete all EventLog entries

URL: https://gallery.technet.microsoft.com/scriptcenter/Delete-all-EventLog-entries-29ff60c8
Quote:

This function delete all EventLog entries. Please keep in mind, that this is something that could be very usefull, but this could be also very dagerous. and I mean that! ...Read more

REGEX checks to see if a given Email address is valid.

URL: https://gallery.technet.microsoft.com/scriptcenter/REGEX-checks-to-see-if-a-2ac8daff
Quote:

It checks a given Mail Address against an REGEX Filter to see if it is RfC822 complaint.Most mailers will not be able to handle it if there are non standard chars within the Mail Address. ...Read more