Implementation Guide › Considerations for CA Audit Users › Importing Data from a SEOSDATA Table › Understand the LMSeosImport Command Line › Import Utility Command and Options

Import Utility Command and Options

The LMSeosImport utility supports the following command line syntax and options:

LMSeosImport -dsn dsn_name -user user_name -password password -target target_name {-sid nnn -eid nnnn -stm yyyy-mm-dd -etm yyyy-mm-dd -log logname -transport (sapi|itech) -chunk nnnn -pretend -verbose -delay -report -retry}

-dsn

Specifies the name of the host server where the SEOSDATA table resides. This parameter is required.

-user

Specifies a valid user ID that has at least Read access to the SEOSDATA table. This parameter is required.

-password

Specifies the password for the user account specified with the -user parameter. This parameter is required.

-target

Specifies the hostname or IP address of the CA Enterprise Log Manager server to receive the migrated events from the SEOSDATA table. This parameter is required.

-minid nnnn

Indicates the starting ENTRYID used when selecting events from the SEOSDATA table. This parameter is optional.

-maxid nnnn

Indicates the ending ENTRYID used when selecting events from the SEOSDATA table. This parameter is optional.

-mintm YYYY-MM-DD

Indicates the starting time (in YYYY-MM-DD format) used when selecting events from the SEOSDATA table. This parameter is optional.

-maxtm YYYY-MM-DD

Indicates the ending time (in YYYY-MM-DD format) used when selecting events from the SEOSDATA table. This parameter is optional.

-log logname

Specifies that the utility should select only event records with this specified logname. This parameter is optional. If the logname contains spaces, then it must be enclosed in double quotes.

-transport <sapi | itech >

Specifies the transport method that should be used between the import utility and CA Enterprise Log Manager. The default transport method is sapi.

-chunk nnnn

Specifies the number of event records to select from the SEOSDATA table on each pass. The default value is 5000 events (rows). This parameter is optional.

-preview

Outputs the results of the event record selections to STDOUT, but does not actually import the data. This parameter is optional.

-port

Specifies the port number to use if you set the transport option to SAPI and you configured the CA Enterprise Log Manager SAPI router to use a fixed port value (without using the portmapper).

-verbose

Specifies that the utility sends detailed processing messages to STDOUT. This parameter is optional.

-delay

Specifies the number of seconds to pause between the processing of each event. This parameter is optional.

-report

Displays a report of time range, ENTRYID range, and Log counts in the SEOSDATA table. This parameter is optional.

-retry

Specifies the total number of seconds during which retry attempts are made each time an error occurs during the import of an event. Processing continues when the send of that event is successful again. The utility automatically uses a default value of 300 seconds. You do not have to enter the parameter unless you want to specify a different value. Messages related to the retry status are sent to STDOUT.