The importData action imports data between the given dates into the Sentinel database so it can be used for historical reporting or other purposes. The data is imported into the following tables:
PostgreSQL
EVENTS
AUDIT_RECORDS
CORRELATED_EVENTS
EVT_DEST_EVT_NAME_SMRY_1
EVT_DEST_SMRY_1
EVT_DEST_TXNMY_SMRY_1
EVT_PORT_SMRY_1
EVT_SEV_SMRY_1
EVT_SRC_SMRY_1
NOTE:The tables are imported in Oracle with the same name they are archived with.
If the data has already been imported or there is no archived data found between the specified dates, the command returns a notification.
The application imports data from each file into a table and builds the historical view on all the historical tables. The report view joins on the original table and historical view. All Sentinel reports use the report view, so they see any imported data.
This command uses the following flags:
Table 7 Importing Data Flags
Command |
Command Flags |
---|---|
-action |
importData |
-tableName |
<table name> |
-startDate |
<mm/dd/yyyy hh24:mi:ss> |
-endDate |
<mm/dd/yyyy hh24:mi:ss> |
-connectFile |
<filePath> |
hh24 is hours represented in 24-hour format. For example, 1:15:00 p.m. is 13:15:00 and 3:00:00 a.m. is 03:00:00.
NOTE:The files to be imported must exist in the directory with their originalfile names.
Place all the files you want to import in a specific directory (that is, dirPath - <directory to import files from>) and execute the following command
-action importData -startDate <mm/dd/yyyy hh24:mi:ss> -endDate <mm/dd/yyyy hh24:mi:ss> -tableName <table name> -connectFile <filePath>
The following example imports the archived files from the
directory containing the data between dates 09/25/2007 00:00:00 (Sep 25 midnight) and 09/26/2007 00:00:00 (Sep 26 midnight).PostgreSQL Example:
./sdm –action importData –startDate 09/25/2007 00:00:00 –endDate 09/26/2007 00:00:00 -tableName Events –connectFile sdm.connect
For trademark and copyright information, see Legal Notices.