TechNet Gallery - resources for IT professionals
Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.
Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
|
This is a simple but useful script. After a lot of questions regarding PowerShell scripts to clean up old backup files I decided to put it out here.You can simply edit anything you like in the PowerShell file the execute code is only a few lines, the variable $oldTi
|
(24)
Updated 1/9/2013
Released 1/17/2012
7,342
Downloads
|
|
|
This Script will provdie you with information of transactions in your BizTalk Environment.The scripts checks the InOutEvents table in the BizTalkDTADb database. It will group by date (DD) and Hour(HH). It is recommended to have a query like this to keep statistic of your BizTalk
|
(8)
Updated 3/6/2012
Released 3/6/2012
635
Downloads
|
|
|
This SQL query is designed for BizTalk version 2006 - 2010. It is created to gather inforamtion from the DTA database to locate orphaned messages. It will provide you with information from the service that creates the orphan message so it can be resolved.This script can also be r
|
(10)
Updated 3/6/2012
Released 3/6/2012
2,296
Downloads
|
|
|
This script is designed to keep a better statistic of your BizTalk Environment.Thi
|
(11)
Updated 3/6/2012
Released 3/6/2012
581
Downloads
|
|
|
This Script will provdie you with information of transactions in your BizTalk Environment.The scripts checks the InOutEvents table in the BizTalkDTADb database. It will locate the amount of messages going through a port according to the PortName for each day. You can alter this t
|
(10)
Updated 3/6/2012
Released 3/6/2012
462
Downloads
|
|
|
This script is created for BizTalk 2006 - 2010.This script will find all receive location related to one specific location/addres
|
(8)
Updated 3/16/2012
Released 3/16/2012
415
Downloads
|
|
|
I've decided to upload a script I often use. It's one of the simple ones. This script is designed for BizTalk 2006 - 2010. It basically reads the instance table in the BizTalkMsgBoxDb database and cross joins it with the host instance in the BizTalkMgmtDb and give me the amount o
|
(7)
Updated 3/8/2012
Released 3/8/2012
487
Downloads
|
|
|
Note that this script should only be run in test environments and not production enviornments as it may violate Microsoft Service agreement. For production use the Terminator tool for BizTalk.This script is simply created to resolve the orphaned messages in a BizTalk database.And
|
(6)
Updated 8/1/2012
Released 8/1/2012
260
Downloads
|
|
|
This script is designed to filter out ports with a filter on the address. You can simply use this in any version of BizTalk 2006 - 2010.Change the the word seachString into your search string in this line: (SendTransport.
|
(6)
Updated 3/19/2012
Released 3/16/2012
366
Downloads
|
|
|
This TSQL script is designed for BizTalk databases.This script is one of them i use often to see if there has been any massive loads and massive files passing through BizTalk. It reads the Byte from the InOutEvents in the tracking database and show them in your console. In my sce
|
(6)
Updated 3/12/2012
Released 3/12/2012
374
Downloads
|
|
|
This PowerShell scripts cleans up the entire MessageBoxDb and all completed tracking data in the tracking databasae based on what you want in thie powerhsell script simply execute it by typing:.\CleanD
|
(8)
Updated 11/14/2012
Released 11/14/2012
102
Downloads
|
|
|
Often I'm asked how many adapters are running for send-ports, or during health checks i determine this with some easy SQL queries towarsds the BizTalkMgmtDb.T
|
(7)
Updated 3/30/2012
Released 3/30/2012
1,264
Downloads
|
|
|
This is a simple script simply stopping all applications.It loops through all applications and stop them. Its designed to for test servers where you have issues with too many applicaitons running. I've seen this a couple of times and stopping the manually will take too long.This
|
(9)
Updated 2/27/2012
Released 2/27/2012
278
Downloads
|
|
|
Often I'm asked how many adapters are running for receive locations, or during health checks i determine this with some easy SQL queries towarsds the BizTalkMgmtDb.T
|
(7)
Updated 3/30/2012
Released 3/30/2012
250
Downloads
|
|
|
When conducting health checks or doing assessments I have a few important queries I use.This one is a simple checking the InOutEvents and the Service Instances, it gives me information of how long an instance run, what host were responsible of the job etc, you can add whatever yo
|
(3)
Updated 1/21/2013
Released 1/21/2013
206
Downloads
|
|
Download Windows Server 2012