Display message summary

You can display a summary view with pigetmsg to sort through a large number of messages. Use the -sum option to summarize results by a field or by a time interval, and use the -top option to summarize results sorted by top occurrences for a specified field. For example:

• Display the number of critical, error, warning, informational, and debug messages since midnight.

  pigetmsg -st T -sum sl
  MessageSeverity, Count
  Error,52
  Warning,1
  Information,17068
  Debug,20923
  

• Display the type of error messages reported, sorted to show the top occurrences first. (The message is shown in a canonical form that ignores the message parameters.)

  pigetmsg -st T -se -top msg
  MessageID, Count, Message
  6088,37,"Connection to pinetmgr lost."
  6019,14,"Rpcservertablelist registration failure: %1"
  6023,1,"PIsessionmgr::disconnect %1 Status: %2"
  

• Display the occurrences of a particular message broken down over a given interval.

  pigetmsg -st T -id 6088 -sum 1h
  13-Jan-10 00:00:00,0
  13-Jan-10 01:00:00,0
  13-Jan-10 02:00:00,0
  13-Jan-10 03:00:00,0
  13-Jan-10 04:00:00,0
  13-Jan-10 05:00:00,0
  13-Jan-10 06:00:00,0
  13-Jan-10 07:00:00,0
  13-Jan-10 08:00:00,4
  13-Jan-10 09:00:00,31
  13-Jan-10 10:00:00,2
  13-Jan-10 11:00:00,0
  13-Jan-10 12:00:00,0
  13-Jan-10 13:00:00,0
  13-Jan-10 14:00:00,0
  13-Jan-10 15:00:00,0
  13-Jan-10 16:00:00,0
  13-Jan-10 17:00:00,0
  13-Jan-10 18:00:00,0
  13-Jan-10 19:00:00,0
  13-Jan-10 20:00:00,0
  13-Jan-10 21:00:00,0
  13-Jan-10 22:00:00,0
  13-Jan-10 23:00:00,0