Hi

I am looking out for kind windows tool where i can search for subscriptions and dependecies of the artifacts of the Deployed BizTalk applications .

Please let me know if anybody has these king of tool readily available.

Thanks&Regards,

Amarnath.

Hi Amarnath,

You can use WMI, from below link you can download it.

WMI Code Creator v1.0

Download this WMI Code generator and you can use this to create your code. This is a simple window app. Using WMI you can do anything and everything in BizTalk. You just need to use MicrosoftBizTalkServer namespace and select the class you want to use. 

Also please refer thread

You can view Subscriptions by following these steps: http://geekswithblogs.net/sthomas/archive/2005/10/03/55872.aspx

You can check the dependency chain of deployed artifacts also in BT Admin by selecting View Dependencies on each artifact.

Hi Amarnath,

1) If you are using BizTalk 2013 then one of the new out of the box features of BizTalk Server 2013 is the ability to track dependencies between artifacts. The BizTalk Server Administration console provides a UI-driven experience to see how different BizTalk Server artifacts such as orchestrations, send ports, receive locations etc. are dependent on each other.

Nice article by Steef-Jan BizTalk Server: Tracking Dependencies Between Artifacts

2) There is an addin which provides several option to deal with dependencies between BizTalk artifacts. Choosing what to use will depend on the situation and what you want to archive called BTSG NoS Addin and http://www.biztalk360.com/nos/features.html

3) Show BizTalk subscriptions download contains a SQL query, which can be executed against your BizTalk Message Box. The results you get are the current subscriptions in the Message Box. Only the 'Equals Predicates' subscriptions are shown.

4) For viewing subscriptions you can try using New BizTalk Subscription Explorer 

Hi Amarnath,

2013 BizTalk it has by default (selecting View Dependencies), where as in older versions its not.

However you have some queries to get some information using powershell, Windows Management Instrumentation (WMI).

Below resources will help you.

BizTalk Server: Administrator Queries and Scripts

BizTalk Server 2010: PowerShell

Blog Sandro Pereira:  BTSG NoS Addin

Thanks, SMSVikasK

Hi Amarnath,

Adding some more info for your benefit.

Below is SQL Scripts shows application level subscription by Lex Hegt

Show BizTalk Application Orchestrations subscriptions

Several other scripts are there, i used this many times for many scenarios to check from back end :)

SQL Scripts to see Admin console Information / to do some tasks

Hope this helps you.

Thanks, SMSVikasK

You can view Subscriptions by following these steps: http://geekswithblogs.net/sthomas/archive/2005/10/03/55872.aspx

You can check the dependency chain of deployed artifacts also in BT Admin by selecting View Dependencies on each artifact.

• Proposed as answer by Rachit Sikroria 12 hours 2 minutes ago

You can view Subscriptions by following these steps: http://geekswithblogs.net/sthomas/archive/2005/10/03/55872.aspx

You can check the dependency chain of deployed artifacts also in BT Admin by selecting View Dependencies on each artifact.

• Proposed as answer by Rachit Sikroria Saturday, August 29, 2015 7:03 PM

Hi Amarnath,

Adding some more info for your benefit.

Below is SQL Scripts shows application level subscription by Lex Hegt

Show BizTalk Application Orchestrations subscriptions

Several other scripts are there, i used this many times for many scenarios to check from back end :)

SQL Scripts to see Admin console Information / to do some tasks

Hope this helps you.

Thanks, SMSVikasK

• Marked as answer by Ammu4biz 12 hours 19 minutes ago

Hi Amarnath,

Adding some more info for your benefit.

Below is SQL Scripts shows application level subscription by Lex Hegt

Show BizTalk Application Orchestrations subscriptions

Several other scripts are there, i used this many times for many scenarios to check from back end :)

SQL Scripts to see Admin console Information / to do some tasks

Hope this helps you.

Thanks, SMSVikasK

• Marked as answer by Ammu4biz Saturday, August 29, 2015 6:46 PM

To view the dependencies of a BizTalk assembly:
 Click Start, click All Programs, click Microsoft BizTalk Server 2013 R2, and then click BizTalk Server Administration.

In the console tree, expand BizTalk Server Administration, expand the BizTalk group containing the BizTalk assembly for which you want to view dependencies, and then expand the application containing the BizTalk assembly.
Click the Resources folder, right-click the BizTalk assembly, and then click Modify.
Click the Dependencies tab.
The name and status of the artifacts that have dependencies on this BizTalk assembly are displayed in the list.

For subscription details , you can always look for biztalk admin console and in group hub page select a new query and look for the subscription  or else use below SQLQuery.

USE BizTalkMsgBoxDb

SELECT DISTINCT
		m.nvcName AS [Application],
		o.nvcName AS [Orchestration],
		sub.dtTimeStamp AS [Created on],
		sub.uidInstanceID AS [Instance],
		ds.msgtype AS [Equals predicate],
		eq.vtValue AS [Expected value]
FROM Services s WITH(NOLOCK)
LEFT OUTER JOIN Modules m WITH(NOLOCK) ON s.nModuleID = m.nModuleID 
LEFT OUTER JOIN Subscription sub WITH(NOLOCK) ON s.uidServiceID = sub.uidServiceID
LEFT OUTER JOIN PredicateGroup pg WITH(NOLOCK) ON sub.uidPredicateGroupID = pg.uidPredicateORGroupID 
LEFT OUTER JOIN FirstPassPredicates fp WITH(NOLOCK) ON pg.uidPredicateANDGroupID = fp.uidPredicateGroupID 
LEFT OUTER JOIN EqualsPredicates eq WITH(NOLOCK) ON pg.uidPredicateANDGroupID = eq.uidPredicateGroupID 
LEFT OUTER JOIN EqualsPredicates2ndPass eq2 WITH(NOLOCK) ON pg.uidPredicateANDGroupID = eq2.uidPredicateGroupID 
LEFT OUTER JOIN BizTalkMgmtDb.dbo.bt_DocumentSpec ds WITH(NOLOCK) ON eq.uidPropID = ds.id
LEFT OUTER JOIN BizTalkMgmtDb.dbo.bts_Orchestration o WITH(NOLOCK) ON s.uidServiceId = o.uidGUID

During design time ,you have option to use BTS NoS addin developed by Nino Crudele.It is one of the best toll which can ease your whole process of development  by removing multiple issue which you can face in large BizTalk implementation . 

Thanks

Abhishek

• Edited by Abhishek0127[Abhishek kumar]MVP 4 hours 3 minutes ago

To view the dependencies of a BizTalk assembly:
 Click Start, click All Programs, click Microsoft BizTalk Server 2013 R2, and then click BizTalk Server Administration.

In the console tree, expand BizTalk Server Administration, expand the BizTalk group containing the BizTalk assembly for which you want to view dependencies, and then expand the application containing the BizTalk assembly.
Click the Resources folder, right-click the BizTalk assembly, and then click Modify.
Click the Dependencies tab.
The name and status of the artifacts that have dependencies on this BizTalk assembly are displayed in the list.

For subscription details , you can always look for biztalk admin console and in group hub page select a new query and look for the subscription  or else use below SQLQuery.

USE BizTalkMsgBoxDb

SELECT DISTINCT
		m.nvcName AS [Application],
		o.nvcName AS [Orchestration],
		sub.dtTimeStamp AS [Created on],
		sub.uidInstanceID AS [Instance],
		ds.msgtype AS [Equals predicate],
		eq.vtValue AS [Expected value]
FROM Services s WITH(NOLOCK)
LEFT OUTER JOIN Modules m WITH(NOLOCK) ON s.nModuleID = m.nModuleID 
LEFT OUTER JOIN Subscription sub WITH(NOLOCK) ON s.uidServiceID = sub.uidServiceID
LEFT OUTER JOIN PredicateGroup pg WITH(NOLOCK) ON sub.uidPredicateGroupID = pg.uidPredicateORGroupID 
LEFT OUTER JOIN FirstPassPredicates fp WITH(NOLOCK) ON pg.uidPredicateANDGroupID = fp.uidPredicateGroupID 
LEFT OUTER JOIN EqualsPredicates eq WITH(NOLOCK) ON pg.uidPredicateANDGroupID = eq.uidPredicateGroupID 
LEFT OUTER JOIN EqualsPredicates2ndPass eq2 WITH(NOLOCK) ON pg.uidPredicateANDGroupID = eq2.uidPredicateGroupID 
LEFT OUTER JOIN BizTalkMgmtDb.dbo.bt_DocumentSpec ds WITH(NOLOCK) ON eq.uidPropID = ds.id
LEFT OUTER JOIN BizTalkMgmtDb.dbo.bts_Orchestration o WITH(NOLOCK) ON s.uidServiceId = o.uidGUID

During design time ,you have option to use BTS NoS addin developed by Nino Crudele.It is one of the best toll which can ease your whole process of development  by removing multiple issue which you can face in large BizTalk implementation . 

Thanks

Abhishek

• Edited by Abhishek0127[Abhishek kumar]MVP Saturday, August 29, 2015 3:01 AM
• Proposed as answer by Abhishek0127[Abhishek kumar]MVP 11 hours 24 minutes ago

To view the dependencies of a BizTalk assembly:
 Click Start, click All Programs, click Microsoft BizTalk Server 2013 R2, and then click BizTalk Server Administration.

In the console tree, expand BizTalk Server Administration, expand the BizTalk group containing the BizTalk assembly for which you want to view dependencies, and then expand the application containing the BizTalk assembly.
Click the Resources folder, right-click the BizTalk assembly, and then click Modify.
Click the Dependencies tab.
The name and status of the artifacts that have dependencies on this BizTalk assembly are displayed in the list.

For subscription details , you can always look for biztalk admin console and in group hub page select a new query and look for the subscription  or else use below SQLQuery.

USE BizTalkMsgBoxDb

SELECT DISTINCT
		m.nvcName AS [Application],
		o.nvcName AS [Orchestration],
		sub.dtTimeStamp AS [Created on],
		sub.uidInstanceID AS [Instance],
		ds.msgtype AS [Equals predicate],
		eq.vtValue AS [Expected value]
FROM Services s WITH(NOLOCK)
LEFT OUTER JOIN Modules m WITH(NOLOCK) ON s.nModuleID = m.nModuleID 
LEFT OUTER JOIN Subscription sub WITH(NOLOCK) ON s.uidServiceID = sub.uidServiceID
LEFT OUTER JOIN PredicateGroup pg WITH(NOLOCK) ON sub.uidPredicateGroupID = pg.uidPredicateORGroupID 
LEFT OUTER JOIN FirstPassPredicates fp WITH(NOLOCK) ON pg.uidPredicateANDGroupID = fp.uidPredicateGroupID 
LEFT OUTER JOIN EqualsPredicates eq WITH(NOLOCK) ON pg.uidPredicateANDGroupID = eq.uidPredicateGroupID 
LEFT OUTER JOIN EqualsPredicates2ndPass eq2 WITH(NOLOCK) ON pg.uidPredicateANDGroupID = eq2.uidPredicateGroupID 
LEFT OUTER JOIN BizTalkMgmtDb.dbo.bt_DocumentSpec ds WITH(NOLOCK) ON eq.uidPropID = ds.id
LEFT OUTER JOIN BizTalkMgmtDb.dbo.bts_Orchestration o WITH(NOLOCK) ON s.uidServiceId = o.uidGUID

During design time ,you have option to use BTS NoS addin developed by Nino Crudele.It is one of the best toll which can ease your whole process of development  by removing multiple issue which you can face in large BizTalk implementation . 

Thanks

Abhishek

• Edited by Abhishek0127[Abhishek kumar]MVP Saturday, August 29, 2015 3:01 AM
• Proposed as answer by Abhishek0127[Abhishek kumar]MVP Saturday, August 29, 2015 7:41 PM