Find BizTalk Pipeline Component References

Used Case

What if your BizTalk implementation has lot of pipeline components and custom pipeline used and at times the question might pop up: find where all a certain pipeline components has been referenced.

This might become more relevant if you are doing a deployment planning . One way is to go check the individual BizTalk solutions and find out where those have been referenced. There is a  high probability that something may be missed.
 

Solution

To overcome that we can use the BizTalk MdmtDb and query it to get the information on the go.

The table we need to refere in our query are

• bts_component
• bts_stage_config
• bts_pipeline_stage
• bts_pipeline_config
• bts_Pipeline

Here is the query you will need to execute, you will be required to be the part of BizTalk operator group.

SELECT E.Name,E.FullyQualifiedName
FROM BizTalkMgmtDb.dbo.bts_component AS A,
BizTalkMgmtDb.dbo.bts_stage_config AS B,
BizTalkMgmtDb.dbo.bts_pipeline_stage AS C,
BizTalkMgmtDb.dbo.bts_pipeline_config AS D,
BizTalkMgmtDb.dbo.bts_Pipeline AS E
WHERE A.id=B.CompId
AND B.stageId=C.id
AND  C.id=D.StageId
AND D.PipeLineId=E.id
AND A.Name like  (‘%Your Component Name%’)

https://psrathoud.files.wordpress.com/2016/11/untitled.png?w=630

​**
**Reference : MSDN Forum Discussion

​