This command displays event log records. Via the selective query option,
you can use an index name to control the query and return the records
in ascending index order for the range of the index specified.
You can optionally specify verbose output to output all fields of the
selected records. When you don't select verbose output, logquery prints
out all data fields and a subset of the system
fields for each record selected.
You cannot view an event log record if you do not have access to the
roster corresponding to the referenced work item. See About
workflow security for further information.
Syntax
The syntax varies depending on whether you use a selective query.
The parameters required depend on whether you use a selective query.
Following is an alphabetical listing of all valid parameters for the logquery
command.
filter
This is a standard SQL WHERE clause using fields of the event log
table.
For details on the syntax for your query, see the documentation
for the SQL database server to which you're sending the query.
getvaluesequalmax
Whether output should include records with values equal to maxfieldval.
Enter "y" to include these records or "n" to
exclude them.
getvaluesequalmin
Whether output should include records with values equal to minfieldval.
Enter "y" to include these records or "n" to
exclude them.
indexname
Index key name.
In prompt mode, enter "?" to view a list of the available
indices.
logtablename
Name of event log table. Use the config
command to find the event log table name. The default value is DefaultEventLog.
maxfieldval
The maximum value of the database field indicated by fieldname.
The data type displays in datatype to help you determine the proper
input. Depending on your answer, you may receive additional prompts
for other minimum or maximum field values.
minfieldval
The minimum value of the database field indicated by fieldname.
The data type displays in datatype to help you determine the proper
input. Depending on your answer, you may receive additional prompts
for other minimum or maximum field values.
n
No selective query specified.
verbose
Output the selected records in verbose mode.
Enter "y" to display all fields or "n" to display
all data fields and a subset of the system fields.
y
Selective query specified.
When using a selective query, you must specify an index key name
to control the query. The records display in ascending index order
for the range of the index specified.
TIP In
vwtool, you can enter parameters on the command line (following the command
name) or let vwtool prompt you for the information by entering just the
command name. Generally, we recommend prompt mode for all but the simplest
commands. Entering the parameters on the command line is intended primarily
for script-driven input.