Siebel System Monitoring and Diagnostics Guide > Querying System Log Files > Creating and Saving LFA Queries >

Querying Log Files for Users

To query log files for users, you must first set an environment variable log level, and add sections to the logreader.cfg file.

NOTE:  To run queries for a specific user using the option user, you must run the query against the Siebel Web Server log files.

Use the following procedures to query log files for users.

To prepare for querying events associated with users

1. Make sure the SIEBEL_LOG_EVENTS environment variable is set to 4.

   For more information on setting environment variables, see Setting Log Levels for Component Event Types.

2. Add new sections to the logreader.cfg file by doing the following:
   1. Add a SWE=plugin section under the [elements] section.
   2. Create a new [SWE] section with the following:

      Path = <swe log files directory location>.

Use the following procedure to search log files for events associated with individual users.

To query for events associated with a particular user

• Using the command-line interface, enter:

  query query_name where user = user_name

  where:

  • query_name is the query command output stored in memory under this name.
  • user_name is the user of interest in log files.

An example of this query command is as follows:

query asqry where user = asmith

This command queries log files for events associated with user asmith and saves the output to memory under the name asqry.

For other options of the Log File Analyzer (LFA) query command, see Creating and Saving LFA Queries.