|
|
You can use
eels_log_report(1Meels)
to format a report from the output of any SQL query
you make on your EELS database. eels_log_report
enables you to use abbreviations for database column names, specify
maximum widths for output columns, page length and so on.
If you do not specify a SQL query, a default query of
``select * from events'' is used. For example, to print
a report of all the EventSpecificInformation and related
UniqEventID fields, use the following command:
eels_log_report -o "UniqEventID EventSpecificInformation"|lp
To be more selective, you may want to use the -f option to
select just records that contain references to ``routed''
in the EventSpecificInformation field, for example:
eels_log_report -o "UniqEventID EventSpecificInformation" \
-f "EventSpecificInformation(routed)"|lp
eels_log_report also provides a mechanism that enables you
to specify abbreviations for the database table fields. You can display
a full list of abbreviations by using the following command:
eels_log_report -l
Using these abbreviations makes it easier for you to enter report
commands on the command line. For example, using the abbreviated
field names, the following command:
eels_log_report -o "UniqEventID(Event ID) \
EventSpecificInformation(Specific Information)" \
-f "EventSpecificInformation(routed)"|lp
would look like this:
eels_log_report -o "UEID(Event ID) ESI(Specific Information)" -f "ESI(routed)"|lp
Rather than creating your reports on the command line, you can use predefined reports that are contained in a file called report.rc. How to use these predefined reports is described in ``Using standard reports''. How to define your own standard reports is described in ``Creating a standard report''.