Functional Specification
All tables of operation logs, prohibition logs and configuration change logs of Systemwalker Desktop Keeper recorded as "Log Information" managed in database can be backed up as a CSV file in tables and the tables that have been backed up can be 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.17 DTKSTCV.EXE (Output of Configuration Change Log)". In addition, for log information accumulated in database, refer to "1.11 DTKLG1T.EXE (Individual Output of Referrer Logs)".
Command Format
DTKCVDL
Option
None
Return Value
Ended normally.
Ended abnormally.
Location for Saving Commands
Installation folder of database related files\BackupCommand\DTKCVDL.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.
Internally Used Command
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
DTKLG1T.EXE
DTKDELR.EXE
DTKBFDM.EXE
DTKSTCV.EXE
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 Command" 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 image file of the screen hard copy collected from the client (CT) through the screen capture function will be saved in 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>DTKCVDL
Today is Mon 06/08/2009.
Process the data before 20090509 that is 30 prior to today.
2009/06/08 16:25:01 Backup Log information - Start
2009/06/08 16:25:01
2009/06/08 16:25:01 Database : DTKDB
2009/06/08 16:25:01 Processing Start date : 00000000
2009/06/08 16:25:01 Processing finish date : 20090509
2009/06/08 16:25:01 Directory : c:\DTKBKUP\BK20090509
2009/06/08 16:25:01 Extraction Key :
2009/06/08 16:25:01
2009/06/08 16:25:02 - COMMONLOG1
2009/06/08 16:25:02 Output file Name : c:\DTKBKUP\BK20090509\COMMONLOG1.csv
2009/06/08 16:25:02 Number of output items......2
~~(Omitted)~~
2009/06/08 16:25:02 Backup log information - End
2009/06/08 16:25:02
2009/06/08 16:25:02 Backup log information of Log Viewer format - Start
2009/06/08 16:25:02
2009/06/08 16:25:02 Database : DTKDB
2009/06/08 16:25:02 Processing start date : 00000000
2009/06/08 16:25:02 Processing finish date : 20090509
2009/06/08 16:25:02 Log type : 3
2009/06/08 16:25:02 Output file : c:\DTKBKUP\LV20090509\Application startup prohibition Log.csv
2009/06/08 16:25:02 Extraction key :
2009/06/08 16:25:02
2009/06/08 16:25:02 - Application startup prohibition log
2009/06/08 16:25:02 Output file name : c:\DTKBKUP\LV20090509\Application startup prohibition Log.csv
2009/06/08 16:25:02 Number of output items......0
2009/06/08 16:25:02
2009/06/08 16:25:02 Backup log information of Log Viewer format - End
~~(Omitted)~~
2009/06/08 16:25:07 Delete log information - Start
2009/06/08 16:25:07
2009/06/08 16:25:07 Database : DTKDB
2009/06/08 16:25:07 Processing start date : 00000000
2009/06/08 16:25:07 Processing finish date : 20090509
2009/06/08 16:25:07 Deletion indication : -Y
2009/06/08 16:25:07 Extraction key :
2009/06/08 16:25:07
2009/06/08 16:25:08 - COMMONLOG1
2009/06/08 16:25:08 Number of deleted items.....2
~~ (Omitted)~~
2009/06/08 16:27:19
2009/06/08 16:27:19 Delete log information - End