Functional Specification
Output log information such as operation log, prohibition log and configuration change log of Systemwalker Desktop Keeper managed in database to CSV file collectively.
For log information that can be backed up, refer to "1.11 DTKLG1T.EXE (Individual Output of Referrer Logs)" and "DTKSTCV.EXE (Output of configuration change log)".
Command Format
Execute according to the following format in the command prompt.
DTKLGAT <StartDate> <EndDate>
Option
Enter the start day for data processing (8 digits). The range of value is "20010000" - "20349999" and "00000000". When the value of 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 database.
Enter the end date for data processing (8 digits). The range of value is "20010000" - "20349999" that is larger than the value of <StartDate>. When the value of 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 a space, etc., cannot be specified.
Return Value
Ended normally
Ended abnormally
Location for Saving Commands
Installation folder of database related files\BackupCommand\DTKLGAT.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.
DTKLG1T.EXE
DTKNUMCK.BAT
DTKSTCV.EXE
Note
The command execution result will be output to the command prompt. To remain the execution result, specify the file to output execution result through redirection when executing this 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 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.
The image file of screen captured at the client (CT) by the screen capture function will be saved to the Management Server/Master Management Server that is connected 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.
When executing this command in Windows Server 2008, Windows Server 2012, or Windows Server 2016, it is necessary to open the command prompt with "Run as Administrator".
Example of Use/Execution Results/Output Format
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKLGAT 20010000 20349999
2009/06/08 16:48:32 Backup log information of Log Viewer format - Start
2009/06/08 16:48:32
2009/06/08 16:48:32 Database : DTKDB
2009/06/08 16:48:32 Processing start date : 20010000
2009/06/08 16:48:32 Processing finish date : 20349999
2009/06/08 16:48:32 Log type : 3
2009/06/08 16:48:32 Output file : c:\DTKBKUP\LV20349999\Application Startup Prohibition Log.csv
2009/06/08 16:48:32 Extraction key :
2009/06/08 16:48:32
2009/06/08 16:48:32 - Application startup prohibition log
2009/06/08 16:48:32 Output file name : c:\DTKBKUP\LV20349999\Application Startup Prohibition Log.csv
2009/06/08 16:48:32 Number of output items......0
2009/06/08 16:48:32
~~(Omitted)~~ *Repetition in log category
2009/06/08 16:48:41