Use the -o and -O options in vwlog to output log records to a text file or stdout device (usually the screen), respectively.
When outputting records to a file, you can import the file into a spreadsheet such as Microsoft Excel for subsequent analysis. Refer to Output file contents for details on the vwlog output file.
NOTE This option does not remove records from the event logging table in the database. To remove records from the event logging database table, refer to Purging data from the event logging table.
The following parameters apply to the -o and -O options:
Parameters | Use | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
-s, -S, -e, -E |
Use these parameters to specify an interval for statistics database coalescing: |
||||||||||||||||||||||||||||
-r |
Use this parameter to specify the isolated regions to process. |
||||||||||||||||||||||||||||
-T |
Use this parameter to display log records associated with completed workflows. Log records associated with workflows still in progress do not display. |
||||||||||||||||||||||||||||
-v |
Use this parameter to specify verbose output to the stdout device. |
||||||||||||||||||||||||||||
-H |
Use this parameter to print column headings. |
||||||||||||||||||||||||||||
-d |
Use this parameter to specify a delimiter for the log record fields. The default delimiter is "," (the comma character). |
||||||||||||||||||||||||||||
-f |
Use this parameter to define which fields to output. The format for this parameter is:
where string is a concatenation of valid format characters. The order in which these characters are placed determines the order in which the corresponding data appear. The default format is "rteuwWcpioMdkx". Refer to the Valid format characters used in strings, which lists each valid format character, as well as the information output when you include the format character in the string. |
||||||||||||||||||||||||||||
-F |
Use this parameter to define the output format for the fields specified in the -f parameter. The format for this parameter is:
where <string> is a concatenation of valid format characters. The default format is n. You can use alternate formats if you have a problem importing the text file into Microsoft Excel or another application. The valid field formats are:
|
||||||||||||||||||||||||||||
-w | Use this parameter to filter the log records for a specific condition by specifying a SQL "WHERE" clause. | ||||||||||||||||||||||||||||
-Y |
Use this parameter to specify the user name and password in the format <user_name>+<password>. The user must belong to theProcess Engine Administrator Group. |
For example:
vwlog -r 7 -o output.log -d '*' -f rewIA -Y Administrator+password
or
vwlog -r 7 -O -d '*' -f rewIA -Y Administrator+password
will output records from the event log tables to the file "output.log" or the screen, respectively. The following fields will be output for each record, separated by a "*":
With this information, you can determine where each work item was in processing when a specific message was generated.