IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
Specify the query string
The query string has the following format:
select column[,column] where Filter_PredicateFollowing the reserved word "select" comes one or more column headers. These are the elements of the log or trace records that will appear n the output. A timestamp is always displayed in the output for each record.
After the reserved word "where" comes a filter predicate, which determines which records will be present in the output.
The default query string is:
select default where true
Table 1 lists the column names.
Available column names for LogViewer queries
column header datatype content all select all columns default default columns are Time, Severity, MessageId, LogText, Server, ProductId, Component, and ProductInstance Element string either Message or Trace Time string localized time Millis long int time in milliseconds Server string server name or IP address ServerFormat string for example, TCP/IP Client string client name ProductId string three letters Component string ProductInstance string LogText string SourceFile string name of the source file where the event was generated SourceMethod string name of the method that generated the event SourceLine string line number where the event was generated CorrelationId string Principal string Process string Thread string Exception string MessageId string TraceLevel string Severity string LogAttribs string
The column headers are not case sensitive.