Relog

Extracts performance counters from performance counter logs into other formats, such as text-TSV (for tab-delimited text), text-CSV (for comma-delimited text), binary-BIN, or SQL.

Syntax

relog [FileName [filename ...]] [-a] [-c Path [path ...]] [-cf FileName] [-f {bin|csv|tsv|SQL}] [-t value] [-o {output file | DSN!counter_log}] [-b M/d/yyyy [[hh:]mm:]ss] [-e M/d/yyyy [[hh:]mm:]ss] [-config FileName] [-q]

Parameters

FileName [ filename ... ] : Specifies the pathname of an existing performance counter log. You can specify multiple input files.

-a   : Appends output file instead of overwriting. This option does not apply to SQL format where the default is always to append.

-c   Path [ path ... ] : Specifies the performance counter path to log. To specify multiple counter paths, separate them with a space and enclose the counter paths in quotation marks (for example, "CounterPath1 CounterPath2").

-cf   FileName   : Specifies the pathname of the text file that lists the performance counters to be included in a relog file. Use this option to list counter paths in an input file, one per line. Default setting is all counters in the original log file are relogged.

-f { bin | csv | tsv | SQL } : Specifies the pathname of the output file format. The default format is bin. For a SQL database, the output file specifies the DSN!counter_log. You can specify the database location by using the ODBC manager to configure the DSN (Database System Name).

-t   value   : Specifies sample intervals in "n" records. Includes every nth data point in the relog file. Default is every data point.

-o { output file | DSN!counter_log } : Specifies the pathname of the output file or SQL database where the counters will be written.

-b   M/d/yyyy   hh[:mm[:ss]]   : Specifies begin time for copying first record from the input file. Date and time must be in this exact format M/d/yyyy hh:mm:ss.

-e   M/d/yyyy   hh[:mm[:ss]]   : Specifies end time for copying last record from the input file. Date and time must be in this exact format M/d/yyyy hh:mm:ss.

-config   FileName   : Specifies the pathname of the settings file that contains command-line parameters.

-q   : Displays the performance counters and time ranges of log files specified in the input file.

/?   : Displays help at the command prompt.

Remarks

  • Counter path format

    The general format for counter paths is as follows: [\\Computer]\object[parent/instance#index]\counter] where:

    The parent, instance, index, and counter components of the format may contain either a valid name or a wildcard character. The computer, parent, instance, and index components are not necessary for all counters.

    You determine the counter paths to use based on the counter itself. For example, the LogicalDisk object has an instance index, so you must provide the #index or a wildcard. Therefore, you could use the following format:

    \LogicalDisk(*/*#*)\*

    In comparison, the Process object does not require an instance index. Therefore, you could use the following format:

    \Process(*)\ID Process

    The following is a list of the possible formats:

    • \\machine\object(parent/instance#index)\counter

    • \\machine\object(parent/instance)\counter

    • \\machine\object(instance#index)\counter

    • \\machine\object(instance)\counter

    • \\machine\object\counter

    • \object(parent/instance#index)\counter

    • \object(parent/instance)\counter

    • \object(instance#index)\counter

    • \object(instance)\counter

    • \object\counter

    If a wildcard character is specified in the parent name, all instances of the specified object that match the specified instance and counter fields will be returned.

    If a wildcard character is specified in the instance name, all instances of the specified object and parent object will be returned if all instance names corresponding to the specified index match the wildcard character.

    If a wildcard character is specified in the counter name, all counters of the specified object are returned.

    Partial counter path string matches (for example, pro*) are not supported.

  • Counter files

    Counter files are text files that list one or more of the performance counters in the existing log. Copy the full counter name from the log or the -q output in [\\Computer \ object [instance] \ counter] format. List one counter path on each line.

  • Copying counters

    When executed, Relog copies specified counters from every record in the input file, converting the format if necessary. Wildcard paths are allowed in the counter file.

  • Saving input file subsets

    Use the -t parameter to specify that input files are inserted into output files at intervals of every nth record. By default, data is relogged from every record.

  • Using -b and -e parameters with log files

    You can specify that your output logs include records from before begin-time (-b) to provide data for counters that require computation values of the formatted value. The output file will have the last records from input files with timestamps less than the end-time (-e) parameter.

  • Using the -config option

    The contents of the setting file used with the -config option should have the following format:

    [command_option]

    value

    where command_option is a command line option and value specifies its value. For example:

    [o]

    output.txt

    [f]

    csv

    [t]

    5

  • For more information about incorporating Relog into your Windows Management Instrumentation (WMI) scripts, see Scripting Logs and Monitoring at the Microsoft Windows Resource Kits Web site.

Examples

To resample existing trace logs at fixed intervals of 30, list counter paths, output files and formats, type the following command:

Relog c:\perflogs\daily_trace_log.blg -cf counter_file.txt -o c:\perflogs\reduced_log.csv -t 30 -f csv

To resample existing trace logs at fixed intervals of 30, list counter paths and output files, type the following command:

Relog c:\perflogs\daily_trace_log.blg -cf counter_file.txt -o c:\perflogs\reduced_log.blg -t 30

Formatting legend

Format

Meaning

Italic

Information that the user must supply

Bold

Elements that the user must type exactly as shown

Ellipsis (...)

Parameter that can be repeated several times in a command line

Between brackets ([])

Optional items

Between braces ({}); choices separated by pipe (|). Example: {even|odd}

Set of choices from which the user must choose only one

Courier font

Code or program output

Logman

Tracerpt

Typeperf

Command-line reference A-Z