Using EELS

Using eels_log_report

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''.

© 2004 The SCO Group, Inc. All rights reserved.
UnixWare 7 Release 7.1.4 - 22 April 2004