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

Querying Log Files for Users


Use the following procedure to search log files for events associated with individual users. See Creating and Saving Log File Analyzer Queries for other options of the Log File Analyzer (LFA) query command.

NOTE:  To query log files for users, make sure the environment variable SIEBEL_LOG_EVENTS is set to 4. For further information on environment variables, see Common Event Types for Component Diagnostics.

To query for events associated with a particular user

  • Enter:

    query query_name where user = user_name

    where:

    query_name = Query command output stored in memory under this name.

    user_name = 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.

Siebel System Monitoring and Diagnostics Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.