Replies: 1 comment 1 reply
-
Some references that might help are:
The challenge that I think you're running into is that each channel connector type will have its own properties. You did a good job digging into the poller connector for all those details. You'll have to do that again for the HTTP connector, then again for TCP, and so on. There are only about 10 connector types but you'll have to grind through each one. A better approach might be to do something like read the connector properties, then produce output where you just return the properties XML as a blob or iterate over each child and return a SQL array or a comma-separated list of properties for each connector type. If you are who I think you are, you should check with both Zen and NextGen. You work for a customer of both vendors and each of them offers a channel reporting tool that operates off of a server export from MC. |
Beta Was this translation helpful? Give feedback.
-
We have mirth with MS SQL and there are tables in mirthdb (Channel, Channel_Group and Configuration).
Is there a sql already written to join all of the 3 tables and get the data out of xml fields . For example channel_group has field called channel_group which contains xml data about which channel are in this channel_group.
Also in CONFIGURATION table there is a field configuration.name with value 'channelMetadata' and configuration.value has xml data which contains additional meta information about a particular channel which is usually display in Summary tab.
How do I get/extract all the information using sql so we can create table about channel/job and its meta data without hardcoding?
Here is sample sql I started. My sql code for xml extraction is base on https://stackoverflow.com/questions/19165213/how-to-query-for-xml-values-and-attributes-from-table-in-sql-server
`SELECT ID, NAME, REVISION, CHANNEL_GROUP, convert(xml, CHANNEL_GROUP) as CHANNEL_GROUP_XML
into #channel_group
FROM mirthDB.dbo.CHANNEL_GROUP
Beta Was this translation helpful? Give feedback.
All reactions