The droImported action deletes the imported data between the given dates from the following supported 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 there is no data imported between two specified dates, the command returns a notification.
This command uses the following flags:
Table 8 Deleting Imported Data Flags
|
|
---|---|
-action |
dropImported |
-startDate |
<mm/dd/yyyy hh24:mi:ss> |
-endDate |
<mm/dd/yyyy hh24:mi:ss> |
-tableName |
<table name> |
-connectFile |
<filePath> |
NOTE: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.
To run dropImported:
Execute this command as follows:
-action dropImported -startDate <mm/dd/yyyy hh24:mi:ss> -endDate <mm/dd/yyyy hh24:mi:ss> -tableName <table name> -connectFile <filePath>
The following example deletes the imported data between the given dates from the tables.
PostgreSQL Example:
./sdm –action dropImported –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.