Functional Specification
The backup of all the records from the log table and configuration change log table can be taken at a high speed.
However, the backup of all the records in the table is taken. It is not possible to take backup of some records by specifying the period.
Command Format
DTKTBLUNLOAD.BAT DTKDB {OPELOG | SETTINGSLOG | ALLLOG} <OutDir> [NOPROMPTLOG] [AUTOPATH]
Option
It is a fixed value.
Uppercase/lowercase letters can be used in the string of option. Fullwidth characters cannot be specified.
Specify for processing the log table.
Specify for processing the configuration change log table.
Specify for processing both the log table and the configuration change log table.
Enter the file of saving target with absolute path. The folder should be created in advance.
Specify when it is not required to take backup of the command prompt log text file under the PromptLog folder collected from the client (CT).
When NOPRONPTLOG is omitted by specifying OPELOG or ALLLOG in <Processing target>, a folder named "PromptLog" is created at the location specified in the <OutDir> and all the text files storing the command prompt log details are placed immediately under that folder.
When NOPRONPTLOG is omitted by specifying SETTINGSLOG in <Processing target >, the command prompt log is not deleted.
It can be omitted.
Create a folder named "BKyyyymmddhhmmss" (yyyymmddhhmmss is the date and time of command execution) in the folder specified under <OutDir>, and store backup files under that folder. Also, create a folder called "PromptLog" under this folder, and place all the text files storing the command prompt log details.
It can be omitted. If omitted, create a folder called "PromptLog" under <OutDir>, and place all the text files storing the command prompt log details.
Return Value
Ended normally
Option error
Other errors
Location for Saving Commands
<Installation folder for database related files>\BackupCommand\DTKTBLUNLOAD.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.
Execute after stopping all the programs that access the database in addition to the management server's services and different functions such as backup, restore, Active Directory linkage, and Systemwalker Desktop Patrol configuration information import.
Note
All the logs in the log table are output; therefore, a large quantity of data might be output. Confirm that the output destination has the sufficient empty space. While displaying a file, if it is found that the area is not sufficient, the process ends abnormally.
If the output destination folder contains a file with the same name, the process ends abnormally. Delete the file in advance or automatically create a folder on the given date and time by specifying the AUTOPATH.
As per the result output by DTKLGTB.exe, the file creation order is different from the data record output order.
Only local hard disk can be specified in the output destination folder. Do not specify network drives or removable drives. When sending files to network drives or removable drives, take a backup in the local disk, and then transfer the file to any other folder.
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".
According to the environment being used, it is necessary to edit DTKTBLUNLOAD.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.
Example of Use/Execution Results/Output Format
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKTBLUNLOAD.BAT DTKDB ALLLOG "C:\DTKBKUP" AUTOPATH Tue 06/02/2015-20:05:59.54 (1) [Start]Backup of log system table Tue 06/02/2015-20:05:59.55 (1-1) COMMONLOG1 Start of processing COPY 4052 Tue 06/02/2015-20:06:01.30 (1-2) COMMONLOG2 Start of processing COPY 16348 Tue 06/02/2015-20:06:05.10 (1-3) COMMONLOG3 Start of processing COPY 1625 Tue 06/02/2015-20:06:06.28 (1-4) FILEACCESSLOG Start of processing COPY 80519 Tue 06/02/2015-20:06:50.45 (1-5) FILEBRINGOUTLOG Start of processing COPY 39 Tue 06/02/2015-20:06:51.87 (1-6) LOGINGUARDLOG Start of processing COPY 0 Tue 06/02/2015-20:06:52.07 (1-7) LOGKEYWORDS Start of processing COPY 22073 Tue 06/02/2015-20:06:56.43 (1-8) PRINTLOG Start of processing COPY 2 Tue 06/02/2015-20:06:56.81 (1-9) SESSIONMANAGE Start of processing COPY 68 Tue 06/02/2015-20:06:57.20 (1-10) STARTUPGUARDLOG Start of processing COPY 7 Tue 06/02/2015-20:06:57.53 (1-11) USERLIST Start of processing COPY 0 Tue 06/02/2015-20:06:57.71 (1-12) Command Prompt Log File Start of processing 0 File(s) copied Tue 06/02/2015-20:06:57.85 (1) [End]Backup of log system table Tue 06/02/2015-20:06:57.87 (2) [Start]Backup of setting change log system table Tue 06/02/2015-20:06:57.87 (2-1) SETTINGS Start of processing COPY 1053 Tue 06/02/2015-20:06:58.73 (2-2) LOGONUSER_SETTINGS Start of processing COPY 0 Tue 06/02/2015-20:06:58.96 (2) [End]Backup of setting change log system table