Announcement

Collapse
No announcement yet.

SQL server table links in Mirth connect 3.0.3

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL server table links in Mirth connect 3.0.3

    I have installed Mirth connect 3.0.3 in our test server successfully. So far everything is working well. Now I want to write a stored procedure in sql server that will email me when there are any errors + queued messages totalling more than 25 within a 1 hour.
    My issue is Mirth connect 3, creates it's own tables for each channel.
    Ex: When I create the first channel and deploy it, I see the following new tables.
    [D_M1]
    [D_MA1]
    [D_MC1]
    [D_MCM1]
    [D_MM1]
    [D_MS1]

    When there is a another channel it goes D_M2, D_MA2...etc.

    I want to know how to find the matching tables when a new channel is added with sql without hardcoding and the links between these new tables.
    Any help is greatly appreciated.

  • #2
    If you have a Platinum support contract, the Advanced Alerting Plugin can do this for you automatically.

    If you're looking to do something custom, the "d_channels" table contains the link between the channel Id and the numbers used in the d_m tables.

    Comment

    Working...
    X