Top
Systemwalker Desktop Keeper Reference Manual
FUJITSU Software
Chapter 1 Command Reference > 1.13 DTKLGTB.EXE (Backup of Log Information)
PreviousNext

1.13 DTKLGTB.EXE (Backup of Log Information)

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 tables and the tables that have been backed up can be output as a CSV file.
The log information that can be backed up is shown as follows.

No.

Table Name

Logs being Saved

Output File Name

1

COMMONLOG1

Common Log 1

  • Application Startup Log

  • Application Termination Log

  • E-mail Sending Log

  • E-mail Sending Interruption Log

  • E-mail Attachment Prohibition Log (*1)

  • E-mail Receiving Log

  • Device Configuration Change Log (*2)

  • PrintScreen Key Prohibition Log

  • PrintScreen Key Operation Log

  • Clipboard Operation Prohibition Log

  • Clipboard Operation Log

COMMONLOG1.csv

2

COMMONLOG2

Common Log 2

  • Window Title Obtaining Log

  • Printing Prohibition Log

  • Command Operation Log (index information only)

  • Linkage Application Log

COMMONLOG2.csv

3

COMMONLOG3

Common Log 3

  • E-mail Attachment Prohibition Log (*1)

  • Window Title (with URL) Obtaining Log (with URL)

  • Logon/Logoff Log

  • Device Configuration Change Log (*2)

  • Web Operation Log

  • Web Operation Prohibition Log

  • FTP Operation Log

  • FTP Operation Prohibition Log

  • Environment Change Log

  • Wi-Fi Connection Log

  • Wi-Fi Connection Prohibition Log

  • Bluetooth Connection Log

  • Bluetooth Connection Prohibition Log

  • Application Usage Log

  • Application Usage Prohibition Log

  • Web Access Log

  • SD Card Mount/Unmount Log

  • SIM Card Mount/Unmount Log

  • Phone Outgoing and Incoming Call Log

  • Application Configuration Change Log

COMMONLOG3.csv

4

STARTUPGUARDLOG

Application Startup Prohibition Log

STARTUPGUARDLOG.csv

5

LOGINGUARDLOG

Logon Prohibition Log

LOGINGUARDLOG.csv

6

PRINTLOG

Printing Operation Log

PRINTLOG.csv

7

FILEBRINGOUTLOG

File Export Log

FILEBRINGOUTLOG.csv

8

LOGKEYWORDS

Log Keyword Search

LOGKEYWORDS.csv

9

FILEACCESSLOG

File Operation Log

FILEACCESSLOG.csv

10

SESSIONMANAGE

Information of Connection to Virtual Environment

SESSIONMANAGE.csv

11

USERLIST

Information for Searching User Operation Log

USERLIST.csv

*1:
The E-mail attachment prohibition log in V13.2.0 or earlier is saved in COMMONLOG3 as [E-mail Attachment Prohibition Log]. The E-mail attachment prohibition log in V14.2.0 or later, the E-mail file attachment prohibition log that satisfies one of the following conditions will be saved in COMMONLOG1 as [E-mail Attachment Prohibition Log].

- The policy of confirming recipient address during E-mail sending is not applied.
- The compatible mode of V12.0L20 - V13.0.0 is used.

*2:
The device configuration change log of V13.2.0 or earlier is saved in COMMONLOG1. The device configuration change log of V14.2.0 or later is saved in COMMONLOG3. After upgrading to V14.2.0 or later, when restoring device configuration change log, the device configuration change log of V14.2.0 or later to be restored is saved in COMMONLOG1. After version upgrade, the newly collected device configuration change log is saved in COMMONLOG3.

For the CSV file, the line feeding code "two characters of CR+LF", separator "Comma", and character items should be enclosed with double quotations and output. There is no "double quotations" before and after numeral items.

Through restoring all "Log Information" that has been backed up, operation logs and prohibition logs of Systemwalker Desktop Keeper at the time of backup can be viewed in Log Viewer.

Command Format

Execute according to the following format in the command prompt.

DTKLGTB.EXE DTKDB <User> <Password> <StartDate> <EndDate> <OutDir> [SERVER]

Option

DTKDB:

Fixed value.

<User>:

Enter the logon ID registered in Server Settings Tool (The access authority is the logon ID of "Backup/Restore").

<Password>:

Enter the password of the above logon ID.

<StartDate>:

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.

<EndDate>:

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.

<OutDir>:

Enter the file of saving target with absolute path. The folder should be created in advance.

SERVER:

When specifying "SERVER" (Halfwidth character), processing is performed based on the date when log information is saved in Management Server/Master Management Server. If "SERVER" is omitted, processing will be performed by taking the date specified in <StartDate> and <EndDate> as condition, based on the date when log information is collected on client.

In the command option, an option that contains a space, etc., cannot be specified.

When specifying an option, data enclosed with double quotations cannot be specified.

Pay particular attention when entering the folder name of <OutDir>.

Return Value

[ERRORLEVEL] 0:

Ended normally

[ERRORLEVEL] 1:

Ended abnormally

Location for Saving Commands

Installation folder of database related files\BackupCommand\DTKLGTB.EXE

Authority Required for Execution/Execution Environment

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.

  • Create the output file under the folder entered in <OutDir>.

  • When the file with same name as the output file in the folder, replace it by force. A confirmation message will not be displayed.

  • The command log collected from the client (CT) will be saved to the Management Server/Master Management Server connected with the client (CT) in text format. In database, only the index information to the text file will be saved to the "COMMONLOG2" table. In backup processing, create the "PromptLog" folder under the folder entered in <OutDir> and save the text file to this folder.

  • The image file of screen hard copy 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 the database, only the index information to the image file will be saved to the "COMMONLOG2" table. Backup and deletion processes can only process index information, and image file will not be processed.

  • The original file backup file in the File Export Utility is saved on the Management Server/Master Management Server connected with the client (CT). In database, only the index information to the original file will be saved in the "FILEBRINGOUTLOG" table. Backup and deletion processes can only process index information, and original file will not be processed.

  • The E-mail content file backed up during E-mail sending is saved on the Management Server/Master Management Server connected with the client (CT). In the database, only the index information to the E-mail content file will be saved in the "COMMONLOG1" table. Backup and deletion processes can only process index information, and E-mail content 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

[Example of use when outputting all logs that are kept]
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKLGTB.exe DTKDB User Password 20010000 20349999 C:\DTKBKUP
2009/06/08 16:52:35  Backup log information- Start
2009/06/08 16:52:35
2009/06/08 16:52:35  Database    :  DTKDB
2009/06/08 16:52:35  Processing start date    :  20010000
2009/06/08 16:52:35  Processing finish date     :  20349999
2009/06/08 16:52:35  Directory    :  C:\DTKBKUP
2009/06/08 16:52:35  Extraction key      : 
2009/06/08 16:52:35
2009/06/08 16:52:35   - COMMONLOG1
2009/06/08 16:52:35     Output file Name  :   C:\DTKBKUP\COMMONLOG1.csv
2009/06/08 16:52:37     Number of output items......4,001
2009/06/08 16:52:37

    ~~ (Omitted) ~~

2009/06/08 16:52:46
2009/06/08 16:52:46  Backup log information- End
2009/06/08 16:52:46
PreviousNext
Copyright 2005 - 2018 FUJITSU LIMITED