rbeckman-nextgen / test-mc4

0 stars 0 forks source link

Generate reports for channels #4344

Open rbeckman-nextgen opened 4 years ago

rbeckman-nextgen commented 4 years ago

Have the ability to generate reports (PDF, HTML, or just email) for the Mirth server providing statistics for all of the channels (# messages, types of messages, average message size, etc.) This should be configured through the server settings in the UI.

Imported Issue. Original Details: Jira Issue Key: MIRTH-12 Reporter: geraldb Created: 2006-09-07T11:47:36.000-0700

rbeckman-nextgen commented 4 years ago

Moved to 1.3.0

Imported Comment. Original Details: Author: chrisl Created: 2006-10-03T17:53:48.000-0700

rbeckman-nextgen commented 4 years ago

Should be a plugin.

Imported Comment. Original Details: Author: admin Created: 2007-07-26T16:19:02.000-0700

rbeckman-nextgen commented 4 years ago

You could create a channel to do this...

Have a database reader set to poll at the frequency desired to capture statistics or have it run every five minutes and a transform at the source determines the schedule. When it polls, have it run javascript to copy the statistics to a new table called statistics_history with the start and end date. Then set the original statistics to zero by subtracting what was copied from the current statistics incase a new message was processed.

After it copies setup destinations that run transforms that look for issues such as:

  1. Channels that haven't processed a message in 4 (or a specified) number of hours. Send an email.
  2. Send the average stats for the prior week on Sunday nights at 1am to an email list. Format all stats for all channels in text then email out.
  3. If performance drops below a certain level, have it send out an email.

John

Imported Comment. Original Details: Author: jlehew Created: 2007-11-16T10:00:28.000-0800

rbeckman-nextgen commented 4 years ago

I like your suggestion John! I've bounced around a similar idea and I think we might start working on a few sample reporting channels. There's actually A LOT of power in the transformer/filter considering you can actually access Mirth's own controllers. For example, one could make a call to Packages.com.webreach.mirth.server.controllers.MessageObjectController and add/update/list messages manually (without writing any SQL).

Imported Comment. Original Details: Author: chrisl Created: 2007-11-24T03:52:06.000-0800