web stats
SQL server table links in Mirth connect 3.0.3 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2015, 05:16 PM
donsls donsls is offline
OBX.2 Kenobi
 
Join Date: Feb 2010
Posts: 72
donsls is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 02-06-2015, 06:39 PM
wayneh wayneh is offline
OBX.3 Kenobi
 
Join Date: May 2012
Posts: 102
wayneh is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 04:52 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation