DB Table of Receive Location Properties

Does anybody know where some of the receive location properties such as pollingInterval, connection string etc.. get stored in the database. We are trying to generate some audit reports based on those fields and I almost seached all databases and did not get any hit.

Appreciate your help!

 Hi,

You can write a small program to get Receive Location properties through WMI MSBTS_ReceiveLocation or Microsoft.BizTalk.ExplorerOM

Example:

Using WMI MSBTS_ReceiveLocation :

ReceiveLocationQuery= "SELECT * FROM MSBTS_ReceiveLocation"

 //Create the WMI search object.

Using Microsoft.BizTalk.ExplorerOM

Create the root object and set the connection string
                BtsCatalogExplorer catalog = new BtsCatalogExplorer();
                catalog.ConnectionString = ConfigurationManager.ConnectionStrings
                    [Constants.BIZTALK_MGTDATABASE_CONNECTION].ConnectionString;
                string receiveLocationName = string.Empty;
                foreach (ReceiveLocation receiveLoc in
                                catalog.ReceivePorts[inboundReceivePort].ReceiveLocations)
                {
                    if (inboundAddress == receiveLoc.Address)

                    {
                        receiveLocationName = receiveLoc.Name;

                        break;
                    }
                }

//Create the WMI search object.

();

// create the scope node so we can set the WMI root node correctly.

.MGT_SCOPE);

Searcher.Scope = scope;

// Build a Query to enumerate the MSBTS_ReceiveLocation instances if an argument

// is supplied use it to select only the matching RL.

();

query.QueryString = ReceiveLocationQuery;

// Set the query for the searcher.

// Execute the query and determine if any results were obtained.

queryCol = Searcher.Get();

//Get the Recive Location Name from InboundTransportURL property

queryCol)

{

envVarProperties = envVar.Properties;

envVarProperties)

{

.INBOUND_TRANSPORT_URL)) &&

(inboundAddress.Equals(envVarProperty.Value)))

{

//Set the reciveLocationName from the InboundTransportURL property

].ToString();

;

The ESB Guidance might be helpful too (http://www.codeplex.com/esb).  It includes a BizTalk Operations Service that let's you access BizTalk management data such as receive location info.