Implementation Guide › Considerations for CA Audit Users › Importing Data from a SEOSDATA Table › Create an Event Report

Create an Event Report

Running a SEOSDATA event report prior to the actual import of data provides you with needed information about the events in the table. The report shows the event time range, the event count per log type, and the entry ID range. You can use the values displayed in the report to refine your command line options for either a preview command or the actual import command.

To show a report of current SEOSDATA event information on Windows

1. Access a command prompt on the CA Audit Data Tools server.
2. Navigate to the directory, \Program Files\CA\SharedComponents\iTechnology.
3. Enter the command line:

   LMSeosImport -dsn eAudit_DSN -user sa -password sa -target <Log_Manager_host_name> -report
   

   The generated report display is similar to the following example:

   SEOSProcessor::InitOdbc: successfully attached to source [eAudit_DSN]
   
   ---------- SEOSDATA Event Time Range ----------
   
   Minimum TIME = 2007-08-27
   Maximum TIME = 2007-10-06
   
   ---------- Event Count Per Log ----------
   
   com.ca.iTechnology.iSponsor : 3052
   EiamSdk : 1013
   NT-Application : 776
   NT-System : 900
   
   ---------- SEOSDATA EntryID Range ----------
   
   Minimum ENTRYID : 1
   Maximum ENTRYID : 5741
   
   Report Completed.