| Author |
Message
|
| 16legal |
 Posted: Thu Jun 13, 2013 4:28 am Post subject: Customization of activity logs in message broker |
 |
|
Novice
Joined: 05 Jun 2013
Posts: 21
|
| Can activity logs of message broker be customized to capture incoming message fields ? There are defaults fields that are captured ie MessageNo,severity,timestamp etc..Can i modify this list to capture fields of incoming message? |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Jun 13, 2013 4:35 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| 16legal |
| Posted: Thu Jun 13, 2013 5:55 am Post subject: |
|
|
Novice
Joined: 05 Jun 2013
Posts: 21
|
How do i add a column to add keydata to the already defined columns ?Here is a sample activity log with predefined tags
MessageNumber,Severity,Timestamp,ThreadID,FormattedMessage,Tags,Inserts
11504,I,"2013-06-13 10:53:03.000383",9512,,"MSGFLOW=com.test.TestFlow,NODE=IN,NODETYPE=INPUT,",IN,com.test.TestFlow,
Here i want to add a user defined tag say 'KeyData' to capture the incoming message field .How to go about it ?
[/img] |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jun 13, 2013 6:03 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Code: |
INSERT INTO Database.WMB_HST ( ID, MSG_ID, ASSIGNED_DATE, RECORD_STATE, KEYDATA, CREATE_DATE, CREATE_USER )
VALUES( Environment.Variables.XMLNSC.{ReplyId}.HST_sequence.NextVal,
ReplyId,
Root.XMLNSC.AssignedDate,
'INFLIGHT',
Root.XMLNSC.KeyData,
CURRENT_GMTTIMESTAMP,
'wmbuser' );
|
| lancelotlinc wrote: |
| You can capture and log any data you want, including all or parts of any payload. You must store customized fields in a custom table. You can tie back through foreign key reference to the off-the-shelf table. |
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Last edited by lancelotlinc on Thu Jun 13, 2013 6:06 am; edited 1 time in total |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 13, 2013 6:06 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
It's a shame that that DB statement has nothing to do with the Activity Log shown by MB Explorer.
I don't believe there's any way to reconfigure the Activity Log viewer in MB Explorer to display a different set of information.
That doesn't mean that other things can't be used to capture and display the same, or additional, data. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jun 13, 2013 6:07 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
It's a shame that that DB statement has nothing to do with the Activity Log shown by MB Explorer.
I don't believe there's any way to reconfigure the Activity Log viewer in MB Explorer to display a different set of information.
That doesn't mean that other things can't be used to capture and display the same, or additional, data. |
I don't know why it is a shame as the statement directly supports the chain of conversation in this thread.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 13, 2013 6:11 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| I don't know why it is a shame as the statement directly supports the chain of conversation in this thread. |
So you can cite a documentation link that indicates that the Activity Log viewer in MB Explorer can read from a database table?
Or that the Activity Log configurable service can write to a database table? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jun 13, 2013 6:18 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| lancelotlinc wrote: |
| I don't know why it is a shame as the statement directly supports the chain of conversation in this thread. |
So you can cite a documentation link that indicates that the Activity Log viewer in MB Explorer can read from a database table?
Or that the Activity Log configurable service can write to a database table? |
The OP did not say he wanted to use the the Activity Log viewer to view the custom data and I did not say that custom data would be available in the off-the-shelf user interface.
The OP's question is:
| Quote: |
| Can activity logs of message broker be customized to capture incoming message fields |
My answer is:
Yes,
| Quote: |
| You can capture and log any data you want, including all or parts of any payload. You must store customized fields in a custom table. You can tie back through foreign key reference to the off-the-shelf table. |
To your point, mqjeff, no, the product's off-the-shelf data store and off-the-shelf Activity Log viewer is not designed to be expandable by the end-user.
: RFE :
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 13, 2013 6:19 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| To your point, mqjeff, no, the product's off-the-shelf data store and off-the-shelf Activity Log viewer is not designed to be expandable by the end-user. |
Which is a shame.
However, as you say, the data is easily consumable by anything and thus any reasonable viewer tool can be used to consume the existing data and enhance it with additional data from any relevant source. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jun 13, 2013 6:31 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| lancelotlinc wrote: |
| To your point, mqjeff, no, the product's off-the-shelf data store and off-the-shelf Activity Log viewer is not designed to be expandable by the end-user. |
Which is a shame.
However, as you say, the data is easily consumable by anything and thus any reasonable viewer tool can be used to consume the existing data and enhance it with additional data from any relevant source. |
What I like about Eclipse in general, and WMB toolkit in particular (also the MB Explorer), is that adding some light-hearted plug-in to display this information is a relatively trivial effort and could be accomplished to the greater good of the user community.
I use Log Viewer for Eclipse just about every day when reviewing ESQL code for places that need adjustment. The Eclipse Log Viewer is a non blocking IO stream reader that can tail any number of files and eclipse consoles. It allows you to syntax color the log files with either a regular expression or a word match.
http://marketplace.eclipse.org/content/logviewer#.UbnXwfnVA1I
One could use this Log Viewer for Eclipse to tail a log file that has detail information created by a command sent into the Broker runtime through a TCPIPInput node from a cURL script piped from an XML file stored in your toolkit workspace. I do it all the time to dump relevant Global Cache info for particular messages.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 13, 2013 6:39 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Maybe you should give the talk on MQExplorer for power users... 
Yes, Eclipse is a nice platform for doing lots of fun things. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Jun 13, 2013 6:54 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
Maybe you should give the talk on MQExplorer for power users...
Yes, Eclipse is a nice platform for doing lots of fun things. |
I'm sorry I will miss your presentation. Will it be recorded?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| 16legal |
| Posted: Thu Jun 13, 2013 9:52 am Post subject: |
|
|
Novice
Joined: 05 Jun 2013
Posts: 21
|
| Even I don't believe that there's any way to reconfigure the Activity Log viewer in MB Explorer to display a different set of information.All i intended to do is to reconfigure the activitylog file generated at runtime in UTF-8 format through configurable services. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 13, 2013 10:21 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| 16legal wrote: |
| Even I don't believe that there's any way to reconfigure the Activity Log viewer in MB Explorer to display a different set of information.All i intended to do is to reconfigure the activitylog file generated at runtime in UTF-8 format through configurable services. |
Again, that's not possible. The information gathered is not user-customizable.
There's nothing that prevents you from augmenting that information with information you store yourself, and using some method of producing a unified view of the two sets of information.... |
|
| Back to top |
|
|
|
|
