none
Export the Results in the Biztalk Group Overview RRS feed

  • Question

  • Hello all,

    There is a way to export a resultant service instances as a excel file from the Group Overview in the Biztalk server.

    I want to create consolidate report by using the historical service instance data.

    Can any one help me on this?

    Thanks in advance.

    -Joyson

    Tuesday, May 23, 2017 12:37 PM

Answers

  • Hi Joyson

    You can try the below query, and fine tune it to cater to your specific needs-

      SELECT  [nServiceInstanceId],
    [strServiceName]
          ,[uidActivityId]
          ,[uidServiceInstanceId]
          ,si.[uidServiceId]
          ,[uidAgentSrvId]
          ,[uidServiceClassId]
          ,[dtStartTime]
          ,[dtEndTime]
          ,[HRESULT]
          ,[ErrorInfo]
          ,[nHostId]
          ,[nMessageBoxId]
          ,[nServiceStateId]
          ,[nGroupId]
          ,[bExceptionsOccurred]
          ,[dtInsertionTimeStamp]
      FROM [BizTalkDTADb].[dbo].[dta_ServiceInstances] si with (nolock) INNER JOIN [BizTalkDTADb].[dbo].[dta_Services] se with (nolock)
      ON si.uidServiceId = se.uidServiceId


    Thanks Arindam

    • Marked as answer by Joyson Joy Wednesday, May 24, 2017 6:52 AM
    Wednesday, May 24, 2017 1:04 AM
    Moderator

All replies

  • While there is no way to export the Group Hub directly, all of the data presented there is available through the standard WMI interface so what you would do is just make the queries yourself.

    Tuesday, May 23, 2017 10:15 PM
    Moderator
  • Hi,

    You can make use of the WMI classes or the Biztalk Operations namespace classes to query the data from the Biztalk databases.

    Refer below links for samples

    Core Server Classes

    Biztalk Operations Namespace


    Mandar Dharmadhikari

    Wednesday, May 24, 2017 12:45 AM
    Moderator
  • Hi Joyson

    You can try the below query, and fine tune it to cater to your specific needs-

      SELECT  [nServiceInstanceId],
    [strServiceName]
          ,[uidActivityId]
          ,[uidServiceInstanceId]
          ,si.[uidServiceId]
          ,[uidAgentSrvId]
          ,[uidServiceClassId]
          ,[dtStartTime]
          ,[dtEndTime]
          ,[HRESULT]
          ,[ErrorInfo]
          ,[nHostId]
          ,[nMessageBoxId]
          ,[nServiceStateId]
          ,[nGroupId]
          ,[bExceptionsOccurred]
          ,[dtInsertionTimeStamp]
      FROM [BizTalkDTADb].[dbo].[dta_ServiceInstances] si with (nolock) INNER JOIN [BizTalkDTADb].[dbo].[dta_Services] se with (nolock)
      ON si.uidServiceId = se.uidServiceId


    Thanks Arindam

    • Marked as answer by Joyson Joy Wednesday, May 24, 2017 6:52 AM
    Wednesday, May 24, 2017 1:04 AM
    Moderator