Bookshelf v8.0: Configuring Output from the Siebel ARM Query Tool

This section discusses the output options that are available to you when you use the Siebel ARM Query Tool. The Siebel ARM Query Tool can simultaneously write output to files in the .TXT, .XML and .CSV format. You can use the Siebel ARM Query Tool to write different types of information to different files as illustrated in the following examples while Table 15 describes the flags that you can use to configure output.

> sarmquery -i d:\sarmdata -sel subarea=infra_entry -sel resp=1000 -out header=hdr.csv -out sarm=sarm.csv -aggregate area -out agg=agg.xml

You can also specify a maximum number of lines to write to a file. When the file contains the maximum number of lines specified, the Siebel ARM Query Tool creates a new file with the same filename plus N where N equals a number. The following example illustrates the use of this option:

This command writes Siebel ARM data Comma Separated Values (CSV) format to the file named sarmdata.csv. The optional value #20000 writes a maximum of 20000 lines to sarmdata.csv. Once sarmdata.csv contains 20000 lines, the Siebel ARM Query Tool writes to a new file with the name sarmdata_0002.csv and so on until all data is output.

Table 15. Output Flags for the Siebel ARM Query Tool
Flag	Description
fdr=<filename>	Converts all fdr files (specified using -input) to CSV format and write them to the specified file.
fdrhdr=<filename>	Converts all the fdr headers to CSV and write them to the specified file.
error=<filename>	By default, the Siebel ARM Query Tool writes output stderr.txt. This command redirects error messages to the specified file.
debug=<filename>	By default, Siebel ARM query does not write debug messages. This command enables the Siebel ARM Query Tool to write debug messages to the file specified file.
dbglines=<filename>	This command enables the Siebel ARM Query Tool to write more debug information.
verbose=<filename>	By default, the Siebel ARM Query Tool writes to the file stderr.txt. This command redirects verbose output to the specified file.
map=<filename>	Creates a file which lists all areas and subareas for Siebel ARM.
header=<filename> appheader=<filename> webheader=<filename> cliheader=<filename>	The available flags are: header Writes all header information to the specified file. appheader Writes header information from Siebel ARM files generated by the Siebel Server. webheader Writes header information from Siebel ARM files generated by the Siebel Web Server. cliheader Writes header information from the Siebel ARM files generated by clients. The following example writes information about all headers to all.csv and then writes information for each specific part to a different file: > sarmquery -i dir -o header=all.csv -o appheader=app.csv -o webheader=web.csv -o cliheader=cli.csv
sarm=<filename> appsarm=<filename> websarm=<filename> clisarm=<filename>	The available flags are: sarm Writes all Siebel ARM data to the specified file. appsarm Writes all Siebel ARM data generated by the Siebel Server to the specified file. websarm Writes all Siebel ARM data generated by the Siebel Web Server (SWSE) to the specified file. clisarm Writes all Siebel ARM data generated by clients. The following example writes Siebel ARM data generated by the Siebel Server and the SWSE to different files: > sarmquery -output appsarm=app.csv -output websarm=web.csv
agg=<filename> iagg=<filename> sagg=<filename>	The available flags are: agg Write the aggregation report to the specified file. sagg Write a subset of the aggregation report to the specified file. This flag specifies exclusive metrics. iagg Write a subset of the aggregation report to the specified file. This flag specifies inclusive metrics. To use the options, you must have aggregated Siebel ARM data by using the flag -aggregate.
avginclresp=<filename> pctcount=<filename> pctinclresp=<filename> pctselftime=<filename>	The available flags are: avginclresp Writes the average response time to the specified file. pctcount Writes the percentage of server requests that complete within the specified time to the specified file. The following example write the percentages of server requests that complete within 100 milliseconds, between 100 milliseconds to 500 milliseconds and so on: > sarmquery -hist resp=100,500,1000,2000,5000 - out pctcount=stdout.txt pctselftime Writes the percentage of time spent in internal parts of the Siebel Server. This is also know as SLA fingerprint.