Generate reports for channels about connect HOT 4 CLOSED

Moved to 1.3.0

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

from connect.

Should be a plugin.

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

from connect.

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

from connect.

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

from connect.