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.
Sort by: rss
15 results in Tord G.Nordahl [Clear]
Tord G.Nordahl
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 $oldTime is how old
(24)
Updated 1/9/2013
Released 1/17/2012
7,342 Downloads
Tord G.Nordahl
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
Tord G.Nordahl
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
Tord G.Nordahl
This script is designed to keep a better statistic of your BizTalk Environment.This scripts checks the Instance table in the BizTalkDTADb and collects information for all instances that have passed in your BizTalk enviroment. Its great to use this query to keep statisitcs of your
(11)
Updated 3/6/2012
Released 3/6/2012
581 Downloads
Tord G.Nordahl
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
Tord G.Nordahl
This script is created for BizTalk 2006 - 2010.This script will find all receive location related to one specific location/addressYou will get the following information: InBoundAddress, Recive location name, Recive location status, Receive Port name, Application name.To alter the
(8)
Updated 3/16/2012
Released 3/16/2012
415 Downloads
Tord G.Nordahl
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
Tord G.Nordahl
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
Tord G.Nordahl
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.nvcAddress LIKE '%seachString%')It will give you informatio
(6)
Updated 3/19/2012
Released 3/16/2012
366 Downloads
Tord G.Nordahl
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
Tord G.Nordahl
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:.\CleanDatabase -action <your action> -database <database/Instance>example to clean mes
(8)
Updated 11/14/2012
Released 11/14/2012
102 Downloads
Tord G.Nordahl
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.The scripts takes all the adapters and counts the send ports related to that adapter and provide you with a number of send
(7)
Updated 3/30/2012
Released 3/30/2012
1,264 Downloads
Tord G.Nordahl
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
Tord G.Nordahl
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.The scripts takes all the adapters and counts the receive locations related to that adapter and provide you with a n
(7)
Updated 3/30/2012
Released 3/30/2012
250 Downloads
Tord G.Nordahl
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