Top
Systemwalker Desktop Keeper Installation Guide
FUJITSU Software

3.1.1 Targets and Methods

The following are two purposes for the backup and restoration of Systemwalker Desktop Keeper Management Server/Master Management Server.

For precaution against environmental exceptions

Data backup is necessary to prevent data loss and restore data in case of a hard disk failure or file corruption.

For stable usage of backup logs
  • To avoid database space becoming insufficient, set the storage life of the log information and delete the log information saved for a period longer than the set storage life.
    Note: For details about the related windows, refer to "1.2.7 Determine How to Operate Logs".

  • Regular backups with the aim of browsing using the Log Viewing Database

The backup targets can be classified into the "product assets" related to the product operation, including configuration files, and the "user assets" including the log information. The following table describes the backup targets of the product asset classification and user asset classification and the backup targets and methods corresponding to the preceding purposes:

Classification

Backup Target

Format

Backup Method

Backup in Case of Environmental Exceptions

Stable Log Backup

Product asset

Configuration file

File

Manual backup

Y

N

CT update module of the self version management function

File

Manual backup

Y

N

User asset

Management information

Database

Backup Tool

(GUI/Command)

Y

Y

Log information (not including command logs)

Database

Backup Tool

(GUI/Command)

Y

Y

Log information (command logs)

File

Backup Tool

(GUI/Command)

Y

Y

Attached data

File

Manual backup

Y

O

E-mail contents

File

Manual backup

Y

O

Configuration Change Logs

Database

Command

(DTKSTCV.EXE and DTKDELST.EXE)

Y

Y

iOS management database

Database

Backup tool (command)

Y

Y

Legend: Y=back up, N=do not back up, O=optional

3.1.1.1 Product Assets

This section describes the data to be backed up and restored as product assets and the backup methods.

Configuration Files

The following table describes the configuration files that require backup and restoration. In addition, if the OS installation folder changes, it is possible that the file saving folders are different from those listed in the table. (In the following table, it is assumed that the OS is installed on drive C.)

No.

Backup Target

Content and Target Folder

1

SWCTVerSettings.ini

Configuration file of the self version management function

This file is saved to the Master Management Server and Management Server.

For Windows Server(R) 2012: C:\Windows\SYSWOW64

For Windows Server(R) 2008: C:\Windows\system32

For Windows Server(R) 2008 64-bit edition and Windows Server(R) 2008 R2: C:\Windows\SYSWOW64

For Windows Server(R) 2003: C:\Windows\system32

For Windows Server(R) 2003 x64 edition and Windows Server(R) 2003 R2, x64 edition: C:\Windows\SYSWOW64

2

SWCTVerSettings2.ini

Configuration file of the self version management function

This file is saved to the Master Management Server and Management Server only when the self version upgrade function is used to perform version or edition upgrade.

For Windows Server(R) 2012: C:\Windows\SYSWOW64

For Windows Server(R) 2008: C:\Windows\system32

For Windows Server(R) 2008 64-bit edition and Windows Server(R) 2008 R2: C:\Windows\SYSWOW64

For Windows Server(R) 2003: C:\Windows\system32

For Windows Server(R) 2003 x64 and Windows Server(R) 2003 R2, x64 edition: C:\Windows\SYSWOW64

3

SWDB.ini

Configuration file of the Systemwalker Desktop Keeper database connection

For Windows Server(R) 2012: C:\Windows

For Windows Server(R) 2008: C:\Windows

For Windows Server(R) 2003: C:\Windows

4

SWMailSettings.ini

Configuration file of the administrator notification function (E-mail notification)

For Windows Server(R) 2012: C:\Windows

For Windows Server(R) 2008: C:\Windows

For Windows Server(R) 2003: C:\Windows

5

SWEventViewer.ini

Configuration file of the administrator notification function (event log)

This file is saved to the Master Management Server or Management Server.

For Windows Server(R) 2012: C:\Windows\SYSWOW64

For Windows Server(R) 2008: C:\Windows\system32

For Windows Server(R) 2008 64-bit edition and Windows Server(R) 2008 R2: C:\Windows\SYSWOW64

For Windows Server(R) 2003: C:\Windows\system32

For Windows Server(R) 2003 x64 edition and Windows Server(R) 2003 R2, x64 edition: C:\Windows\SYSWOW64

6

TRANS_SETTING.ini

Configuration file of the data transmission command

This file is saved to the Master Management Server or Management Server.

<Management Server installation folder>\LogAnalyzer\TRANS

7

taskmng.ini

Configuration file of the Web console

This file is saved to the Master Management Server or Management Server.

IIS folder\Scripts\DTK

8

swdtkenv.ini

Configuration file for database construction

This file is saved to the Master Management Server or Management Server.

<Installation target folder of the database-related files>\DBEnv\Env

When newly installing Management Server V15.1.0, the installation folder for database-related files is mgmtServerInstallFolder\DB.

9

DTKTaskRegist.ini

Configuration file of the statistical command

This file is saved to the Master Management Server or Management Server.

<Management Server installation folder>\Server\LogCount

10

mail.ini

E-mail configuration file

This file is saved to the Master Management Server or Management Server.

<Management Server installation folder>\Server\LogCount

11

LA_connect_Info.csv

Configuration file of the Log Analyzer

This file is saved to the Master Management Server or Management Server.

<Management Server installation folder>\LogAnalyzer\TRANS

12

CONV_SETTING.ini

Data import configuration file.

This file is stored under the Log Analyzer Server folder.

logAnalyzerServerInstallFolder\bin\SWDTLAENV

[Backup and restoration methods]
Backup:

Back up the files saved at the locations described in the preceding table.

Restoration:

Save the backup files to the locations described in the preceding table.

For No.7, perform the following steps to edit the file after saving the file:

  1. Open the file by using the text editor (notepad).

  2. If the Update section contains the "Flag=0" statement, change the statement to "Flag=1". If the original statement is "Flag=1," do not change it.

  3. Save the file and exit the text editor.

CT Update Module of the Self Version Management Function

The following table describes the target folder for saving the CT update module of the self version management function. When the default value of Target for Saving CT Upload Module is changed, backup the modification target.

No.

Backup Target

Target Folder

1

All the contents in the UpdateModule folder.

Target folder for saving the CT upload module of the self version management function, specified by the Server Settings Tool of the Master Management Server or Management Server
Default value: C:\DTK\UpdateModule

[Backup and restoration methods]

Backup:

Back up all the contents in the backup target folder.

Restoration:

Save all the contents in the backup folder to the location described in the preceding table.

3.1.1.2 User Assets

This section describes the data to be backed up and restored as user assets and the backup methods.

Management Information

The following table describes the management information that requires backup and restoration.

No.

Backup Target (Table Name)

Content

1

LEVELTARGET

Level target information

2

LEVELCOMPOSITION

Level structure information

3

PRINTPERMISSION

Printing permission

4

LOGINGUARD

Logon prohibition

5

STARTUPGUARD

Application startup prohibition

6

MAILATTACHSET

E-mail attachment prohibition

7

USERINFO

User information

8

NODEINFO

Node information

9

PHYSICALNODELIST

Physical node list

10

SETTINGS

Configuration value

11

SETTINGSLOG

Configuration change log

12

FILEACC_ACQUIREPROCESS

Registered process for file operation log

13

FILEACC_ACQUIREEXTENSION

Registered extension for file operation log

14

USERPOLICYINFO

User policy information

15

LOGONUSER_PRINTPERMISSION

Registered Printing permission by user

16

LOGONUSER_STARTUPGUARD

Registered Application startup prohibition by user

17

USERMAILATTACHSET

Registered E-mail attachment prohibition by user

18

LOGONUSER_SETTINGSLOG

Registered Configuration change log by user

19

WINDOWTITLELOGFILTER

Filtering conditions of window title logs

20

LOGONUSER_WINDOWTITLELOGFILTER

Registered Filtering conditions of window title logs by user

21

WINDOWCAPTUREFILTER

Screen capture conditions

22

LOGONUSER_WINDOWCAPTUREFILTER

Registered Screen capture conditions by user

23

EXCLUSIONCONTROL

Exclusion control information

24

DOMAINSETTINGS

Domain setting information

25

TARGET_CONTROL

Setting information of CT Department administrator

26

LOGONUSER_LEVELCOMPOSITION

User level configuration information

27

LOGONUSER_CONTROL

Setting information of user Department administrator

28

USBMASTER

USB setting information

29

POLICYTABLE

Common policy

30

DTK_AUDIT_SETTING

Setting information of status window

31

DTK_TOTAL_ALERTLOG

Number of abnormal operations

32

DTK_ALERT_LIST

Abnormality list

33

DTK_ALERTPC_LIST

Abnormal PC list

34

DTK_PRINTER_TARGETMASTER

Target management for all-in-one PC

35

DTK_PRINTER_PRINTUSERMASTER

Operator management for all-in-one PC

36

DTK_PRINTER_PAPERNUM_BASIC

Aggregate number of pages for all-in-one printer

37

All tables of the iOS management database

iOS management database

[Backup and restoration methods]

Backup:

Use the Backup Tool (GUI) or backup commands. For details, see "3.1.2 Back Up User Assets".

When managing iOS devices, use the backup commands. The backup tool (GUI) does not back up iOS management databases.
When Management Server or Master Management Server for Systemwalker Desktop Keeper coexists with CS for Systemwalker Desktop Patrol, and iOS devices are being managed by both products, back up the management information of Systemwalker Desktop Patrol.

Restoration:

Use the Restoration Tool (GUI). For details, see "3.1.3 Restoring User Assets".

When managing iOS devices, execute the restore command for iOS management databases in addition to the Restoration Tool (GUI) to recover iOS management databases.
When Management Server or Master Management Server for Systemwalker Desktop Keeper coexists with CS for Systemwalker Desktop Patrol, and iOS devices are being managed by both products, restore the management information of Systemwalker Desktop Patrol.

Log Information (Not Including Command logs)

The following table describes the log information that requires backup and restoration.

No.

Backup Target (Table Name)

Content

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 (note 1)

  • PrintScreen Key Prohibition Log

  • PrintScreen key operation log

  • Clipboard operation prohibition log

  • Clipboard operation log

2

COMMONLOG2

Common log 2

  • Window Title Obtaining Log

  • Printing prohibition log

  • Command log (including only the index information)

  • Linkage application log

3

COMMONLOG3

Common log 3

  • E-mail attachment prohibition log (note 1)

  • Window Title Obtaining Log (with URL)

  • Logs of logon, logoff, PC startup, PC shutdown, PC hibernate, PC recovery, PC connection, and PC disconnection

  • Device Configuration Change Log (note 2)

  • Web operation log

  • Web operation prohibition log

  • FTP operation log

  • FTP operation prohibition log

  • Application usage log (smart device)

  • SD card mount/unmount log (smart device)

  • Bluetooth connection log (smart device)

  • SIM card mount/unmount log (smart device)

  • Wi-Fi connection log (smart device)

  • Web access log (smart device)

  • Incoming/outgoing calls log (smart device)

  • Application configuration change log (smart device)

  • Application usage prohibition (smart device)

  • Bluetooth connection prohibition (smart device)

  • Wi-Fi connection prohibition (smart device)

4

STARTUPGUARDLOG

Application startup prohibition log

5

LOGINGUARDLOG

Logon prohibition log

6

PRINTLOG

Printing operation log

7

FILEBRINGOUTLOG

File export log

8

LOGKEYWORDS

Keywords for log searching

9

FILEACCESSLOG

File operation log

10

SESSIONMANAGE

Virtual environment connection information

11

USERLIST

Management information for user searching

Note 1:
For the product versions earlier than V13.2.0, the E-mail attachment prohibition logs are saved in COMMONLOG3. For the product versions later than V14.2.0, the E-mail attachment prohibition logs are saved in COMMONLOG1, or they are saved in COMMONLOG3 under the following condition:

The V12.0L20-V13.0.0 interchangeable mode is used.

Note 2:
For the product versions earlier than V13, the device configuration change logs are saved in COMMONLOG1.

[Backup and restoration methods]

Backup:

Use the Backup Tool (GUI) or backup commands. For details, see "3.1.2 Back Up User Assets".

Restoration:

Use the Restoration Tool (GUI). For details, see "3.1.3 Restoring User Assets".

Log Information (Command logs)

The following table describes the target folder for saving command logs. When the default value of Target for Saving Command Line and Logs is changed, backup the modification target.

No.

Backup Target

Target Folder

1

All the contents in the PromptLog folder

Target folder for saving the command lines and logs, specified by the Server Settings Tool of the Master Management Server or Management Server

(Default value: C:\DTK\PromptLog)

[Backup and restoration methods]

Backup:

Use the Backup Tool (GUI) or backup commands. For details, see "3.1.2 Back Up User Assets".

Restoration:

Use the Restoration Tool (GUI). For details, see "3.1.3 Restoring User Assets".

Attached Data

The following table describes the target folder for saving the attached data. When the default value of Target for Saving Attached Data is changed, backup the modification target.

No.

Backup Target

Target Folder

1

All the contents in the ScreenCapture folder

Target folder for saving the attached data, specified by the Server Settings Tool of the Master Management Server or Management Server
(Default value: C:\DTK\ScreenCapture)

The attached data is saved in [Folder of Day Unit]-[Folder of CT Unit] under the preceding target folder.

[Backup and restoration methods]

Backup:

Back up all the contents in the backup target folder.

Back up the attached data separately as required. In addition, the attached data cannot be deleted even by the Backup Tool or backup commands.

Restoration:

Save all the contents under the backup folder to the location described in the preceding table.

E-mail Contents

The following table describes the target folder for saving the E-mail contents. When the default value of Target for Saving E-mail Content is changed, backup the modification target.

No.

Backup Target

Target Folder

1

All the contents in the MainContents folder

Target folder for saving the E-mail contents, specified by the Server Settings Tool of the Master Management Server or Management Server

(Default value: C:\DTK\MailContents)

The E-mail contents are saved in [Folder of Day Unit]-[Folder of CT Unit] under the preceding target folder.

[Backup and restoration methods]

Backup:

Back up all the contents in the backup target folder.

Back up the E-mail contents separately as required. In addition, the E-mail contents cannot be deleted even by the Backup Tool or backup commands.

Restoration:

Save all the contents under the backup folder to the location described in the preceding table.

Trouble Investigation Data

The following table describes the target folder for saving the trouble investigation data. When the default value of Target for Saving Trouble Investigation Data is changed, backup the modification target.

No.

Backup Target

Target Folder

1

All the contents in the CTQSSSave folder

Target folder for saving the trouble investigation data, specified by the Server Settings Tool of the Master Management Server or Management Server

(Default value: C:\DTK\CTQSSSave)

The trouble investigation data is saved in [Folder of Day Unit]-[Folder of CT Unit] under the preceding target folder.

[Backup and restoration methods]

Backup:

Back up all the contents in the backup target folder.

Back up the trouble investigation data separately as required. In addition, the trouble investigation data cannot be deleted even by the Backup Tool or backup commands.

Restoration:

Save all the contents under the backup folder to the location described in the preceding table.