Functional Specification
All tables of operation logs and prohibition logs of Systemwalker Desktop Keeper recorded as "Log Information" managed in database can be backed up as a CSV file in the tables and the tables that have been backed up can be deleted from the database. Also, the configuration change log is deleted from the database.
For log information that can be backed up and deleted, refer to "1.13 DTKLGTB.EXE (Backup of Log Information)" and "1.8 DTKDELST.EXE (Delete Configuration Change Log)"
Command Format
DTKBKDL <StartDate> <EndDate>
Option
Enter the start day for data processing (8 digits). The range of value is "20010000" - "20349999" and "00000000". When the values of the last 4 digits of "20010000" - "20349999" do not exist in the calendar, the following date will be specified.
When the last 4 digits are specified to "0000"
Jan. 1 of the specified year will be the start date.
When the last 4 digits are specified to "1232" - "9999"
Jan. 1 of the next year of the specified year will be start date.
When the last 2 digits are specified to "00"
1st of the specified month will be the start date.
When the last 2 digits are specified to "second day after the end of month" - "99"
1st of the next month of the specified month will be the start date.
In addition, when "00000000" is entered, the start date will be determined as the time when data started to be accumulated in the database.
Enter the end date for data processing (8 digits). The range of the value is "20010000" - "20349999" and must be larger than the value of <StartDate>. When the last 4 digits of "20010000" - "20349999" do not exist in the calendar, the following date will be specified.
When the last 4 digits are specified to "0000"
Dec. 31 of the year previous to the specified year will be the end date.
When the last 4 digits are specified to "1232" - "9999"
Dec. 31 of the specified year will be the end date.
When the last 2 digits are specified to "00"
The last date of the last month of specified month will be the end date.
When the last 2 digits are specified to "second day after the end of month" - "99"
The last date of the specified month will be the end date.
In the command option, an option that contains space, etc., cannot be specified.
Return Value
Ended normally
Ended abnormally
Location for Saving Commands
Installation folder of database related files\BackupCommand\DTKBKDL.BAT
Authority Required for Execution/Execution Environment
Execute with a user that belongs to the Administrators group of the local computer or a user that belongs to the Domain Admins group of the domain.
Execute on the Management Server/Master Management Server.
Command for Internal Use
The following commands are used internally.
Before using this command, check how to use the command for internal use and the notes. Some command requires settings of options in advance.
DTKLGTB.EXE
DTKDELR.EXE
DTKELSET.BAT
DTKNUMCK.BAT
DTKDELST.EXE
Note
The command execution result will be output to the command prompt. If you wish to keep the execution result, specify the file for output through redirection when executing the command.
According to the environment being used, it is necessary to edit DTKBKDL.BAT. For information on how to edit, refer to relevant content in "Edit Backup Commands" of "Using the Backup Commands" of Installation Guide. In addition, error check is not performed in backup command for database name, connection user ID and password. When the set value is incorrect, an error will occur during the execution of backup command.
An error will occur when the folder with same name exist in the folder of output target.
The time required for deletion will be extended with the increasing number of records to be deleted. Verify the time consumed for deleting data in a day, and in order to complete backup and deletion operation within available time, arrange the number of days for backup and deletion rationally.
When deleting, the disk I/O inside PostgreSQL will become very high, which may affect the service processing at server side of Systemwalker Desktop Keeper. When the deletion process consumes too much time, consider to stop the service on the server side of Systemwalker Desktop Keeper and start the service of server side again after the deletion process has finished.
The screen hard copy collected from the client (CT) through the screen capture function will be saved in the Management Server/Master Management Server collected with the client (CT). In database, only the index information of image file is saved in the "COMMONLOG2" table. Backup and deletion process only processes the index information while the image file will not be processed.
Example of Use/Execution Results/Output Format
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKBKDL 20010000 20349999
2014/10/30 16: 18:24 Backup Log Information - Start
2014/10/30 16: 18:24
2014/10/30 16: 18:24 Database : DTKDB
2014/10/30 16: 18:24 Processing start date : 20010000
2014/10/30 16: 18:24 Processing finish date : 20349999
2014/10/30 16: 18:24 Directory : c: \DTKBKUP\BK20349999
2014/10/30 16: 18:24 Extraction Key :
2014/10/30 16: 18:24
2014/10/30 16: 18:24 - COMMONLOG1
2014/10/30 16: 18:24 Output file name : c:\DTKBKUP\BK20349999\COMMONLOG1.csv
2014/10/30 16: 18:26 Number of output items......3,209
2014/10/30 16: 18:26
- - (omitted) - -
2014/10/30 16:19:20 - FILEACCESSLOG
2014/10/30 16:19:21 Process 2014/10/30... 3 items deleted
2014/10/30 16:19:21 Process 2014/10/27... 1 item deleted
2014/10/30 16:19:21 Processed on 2014/10/26... 53 items deleted
2014/10/30 16:19:21 Processed on 2014/10/23... 8 items deleted
2014/10/30 16:19:22 Processed on 2014/10/21...23,207 items deleted
2014/10/30 16:19:26 Number of deleted items.... 23,272
2014/10/30 16:19:26
2014/10/30 16:19:26 Delete Configuration change log information - Start
2014/10/30 16:19:26
2014/10/30 16:19:26 Database: DTKDB
2014/10/30 16:19:26 Processing start date: 20010000
2014/10/30 16:19:26 Processing end date: 20349999
2014/10/30 16:19:26 Deletion instruction:
2014/10/30 16:19:26
2014/10/30 16:19:26 Processed on 2014/10/30... 40 items deleted
2014/10/30 16:19:26 Processed on 2014/10/28... 21 items deleted
2014/10/30 16:19:26 Processed on 2014/10/27... 10 items deleted
2014/10/30 16:19:26 Number of deleted items... 71
2014/10/30 16:19:26
2014/10/30 16:19:26 Delete Configuration change log information - End
2014/10/30 16:19:26
2014/10/30 16:19:26 Delete Log Information - End