Table of Contents
- Introduction
- SQL Scripts
- PowerShell Scripts
- Other scripts
- Ot
BizTalk Server: Administrator Queries and Scripts
Introduction
This site is dedicated to gather information for all the resources related to scripting for BizTalk administrators. It should include information with a reference to the exact location where you can find and download the script.
SQL Scripts
Be aware that performing queries towards the SQL Database should always be with no locks (add 'WITH (NOLOCK)' to every table you have in your query). It is not allowed to UPDATE, ALTER or by any means change the content of the BizTalk databases as this may result in a breach of the Service Agreement with Microsoft.
- Determine size of database and underlying tables
- Find receive locations by address
- Find send ports by port address
- Get amount of messages form the in and out events in BizTalk by date and hours
- Get amount of instances in BizTalk by date and hours
- Get information of all messages from an instance
- Get number of records in the MarkLog tables
- Get Orchestration Instances, Counts and States
- Get statistics from Instances in BizTalk
- Instances in Messagebox being processed by a host instance
- Large files in tracking database
- Locate and show information of all orphaned messages
- Number of Messages per MessageType in TrackingDb
- Pre-allocate space and define auto-growth settings for BizTalk Server databases
- Query for Failed/Successful BizTalk Database Jobs
- Query for list all users with access to BAM Primary Import database
- Query for list all users with access to specify BAM View
- Querying for messages received by the given Receive Location
- Show all BizTalk applications and artifacts
- Show all BizTalk subscriptions
- Show BizTalk Applications, Orchestrations, Ports and Pipelines with a SQL Query
- Show Receive Locations and/or Send Ports that are down
- Statistics from in and out events in BizTalk
- Statistics from in out events grouped by port name and date
- Top 100 Most recent Suspended Messages for a Host
- View Hosts and Host Instances Information from a SQL Query
- Show BizTalk host dependencies
- Orchestration Details
- Get References of Pipeline Component using Mgmt DB
- SQL Query to retrieve the Receive port/location details with Analytics Tracme and date
- Top 100 Most recent Suspended Messages for a Host
- SQL Query to retrieve the Send port details with Analytics Tracking
- SQL Query to retrieve the Orchestration with Analytics Tracking
PowerShell Scripts
This is PowerShell scripts related to maintain and use BizTalk in a better way.
- Generate a BizTalk database restore script
- PowerShell to Configure BizTalk Server Host and Host Instances
- Backup BizTalk Applications and Binding files
- Change user credentials of a BizTalk Host
- Change the startup type for BizTalk services to Automatic (Delayed Start)
- Compare Hotfix
- Delete old backup files and folders
- Deploy applications to BizTalk Servers
- Determine Version and Edition
- Determining the process ID of BizTalk Host Instances
- How to set SQL Server Network Protocols in the SQL Server for BTS Databases
- Monitoring disk spaces in your BizTalk environment with PowerShell
- Monitoring SQL Agent Jobs in your BizTalk environment with PowerShell
- Obtain a list of “BizTalk Software Inventory” installed with PowerShell
- Show the status of the BizTalk host instances
- Stop and start BizTalk servers - GUI
- Stop all applications in your BizTalk Environment
- Setup MSDTC
- Create BizTalk Groups and Accounts using PowerShell
- BizTalk: PowerShell Script To Create and Configure HTTP Receive Location
Other scripts
Here will you find references to other scripts in other scripting languages.
Other languages
This article is also available in the following languages
See Also
Read suggested related topic:
- BizTalk Administrator's Checklist Compiled by Microsoft BizTalk Support
- PowerShell Portal
- Wiki: Portal of TechNet Wiki Portals
Back to Top