This action (dropImported) deletes the imported data between the given dates from the following supported tables:
SQL Server
HIST_EVENTS
HIST_CORRELATED_EVENTS
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, it returns a notification.
This command uses the following 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 above mentioned tables.
Oracle Example:
./sdm action dropImported startDate 09/25/2007 00:00:00 endDate 09/26/2007 00:00:00 -tableName Events connectFile sdm.connect
SQL Server Example:
sdm action dropImported startDate 09/25/2007 00:00:00 endDate 09/26/2007 00:00:00 -tableName Events connectFile sdm.connect