Top
Systemwalker Desktop Keeper Reference Manual
FUJITSU Software
Chapter 1 Command Reference > 1.15 DTKMSTB.EXE (Backup of Management Information)
PreviousNext

1.15 DTKMSTB.EXE (Backup of Management Information)

Functional Specification

All the tables recorded as "Management Information" such as operating environment, CT information, policy information of Systemwalker Desktop Keeper managed in database can be backed up as a CSV file for each table. The tables to be backed up are shown as follows.

No.

Table Name

Purpose

Output File Name

1

LEVELOBJECT

Level object information

LEVELOBJECT.csv

2

LEVELCOMPOSITION

Level composition

LEVELCOMPOSITION.csv

3

PRINTPERMISSION

Printing permission

PRINTPERMISSION.csv

4

LOGINGUARD

Logon prohibition

LOGINGUARD.csv

5

STARTUPGUARD

Application startup prohibition

STARTUPGUARD.csv

6

MAILATTACHSET

E-mail attachment prohibition

MAILATTACHSET.csv

7

USERINFO

User information

USERINFO.csv

8

NODEINFO

Note information

NODEINFO.csv

9

PHYSICALNODELIST

Physical node list

PHYSICALNODELIST.csv

10

SETTINGS

Setting value

SETTINGS.csv

11

SETTINGSLOG

Configuration change log

SETTINGSLOG.csv

12

FILEACC_ACQUIREPROCESS

File operation log registration process

FILEACC_ACQUIREPROCESS.csv

13

FILEACC_ACQUIREEXTENSION

File operation log registration extension

FILEACC_ACQUIREEXTENSION.csv

14

USERPOLICYINFO

User policy information

USERPOLICYINFO.csv

15

LOGONUSER_PRINTPERMISSION

Printing permission registered in user unit

LOGONUSER_PRINTPERMISSION.csv

16

LOGONUSER_STARTUPGUARD

Application startup prohibition registered in user unit

LOGONUSER _STARTUPGUARD.csv

17

USERMAILATTACHSET

E-mail attachment prohibition registered in user unit

USERMAILATTACHSET.csv

18

LOGONUSER_SETTINGSLOG

Configuration change log registered in user unit

LOGONUSER_SETTINGSLOG.csv

19

WINDOWTITLELOGFILTER

Filtering condition of window title log

WINDOWTITLELOGFILTER.csv

20

LOGONUSER_WINDOWTITLELOGFILTER

Filtering condition of window title log registered in user unit

LOGONUSER_WINDOWTITLELOGFILTER.csv

21

WINDOWCAPTUREFILTER

Screen capture condition

WINDOWCAPTUREFILTER.csv

22

LOGONUSER_WINDOWCAPTUREFILTER

Screen capture condition registered in user unit

LOGONUSER_WINDOWCAPTUREFILTER.csv

23

EXCLUSIONCONTROL

Exclusion control information

EXCLUSIONCONTROL.csv

24

DOMAINSETTINGS

Domain settings information

DOMAINSETTINGS.CSV

25

OBJECT_CONTROL

CT department administrator settings information

OBJECT_CONTROL.CSV

26

LOGONUSER_LEVELCOMPOSITION

User level composition information

LOGONUSER_LEVELCOMPOSITION.CSV

27

LOGONUSER_CONTROL

User department administrator settings information

LOGONUSER_CONTROL.CSV

28

USBMASTER

USB settings information

USBMASTER.csv

29

POLICYTABLE

Common policy

POLICYTABLE.csv

30

DTK_AUDIT_SETTING

Status window settings information

DTK_AUDIT_SETTING.csv

31

DTK_TOTAL_ALERTLOG

Aggregation information of abnormal operation items

DTK_TOTAL_ALERTLOG.csv

32

DTK_ALERT_LIST

Exception list information

DTK_ALERT_LIST.csv

33

DTK_ALERTPC_LIST

Exception PC list information

DTK_ALERTPC_LIST.csv

34

DTK_PRINTER_OBJECTMASTER

Multifunction machine object management

DTK_PRINTER_OBJECTMASTER.csv

35

DTK_PRINTER_PRINTUSERMASTER

Multifunction machine user management

DTK_PRINTER_PRINTUSERMASTER.csv

36

DTK_PRINTER_PAPERNUM_BASIC

Total multifunction machine copies

DTK_PRINTER_PAPERNUM_BASIC.csv

37

All tables of iOS management database

iOS Management Data

MDMBackup.dump

For CSV file, 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.

If all "Management Information" that have been backed up is restored, the operating environment, CT information and policy information of Systemwalker Desktop Keeper at the time of backup can be reconstructed. However, it is necessary to set the same computer name and IP address for Management Server/Master Management Server.

Command Format

Execute according to the following format in the command prompt.

DTKMSTB.EXE DTKDB <User> <Password> <OutDir>

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.

<OutDir>:

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

Some characters cannot be used in the folder name. The character type restrictions conform to the Windows restrictions.

The following restrictions are applicable when specifying a folder name when managing iOS devices:

  • The halfwidth alphanumeric characters and symbols can be specified.

  • A maximum of 244 characters can be specified.

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.
In particular, pay 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\DTKMSTB.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.

    Example: DTKMSTB.EXE DTKDB bkuser bkpsw d:\backup > c:\temp\kekka.txt

  • 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. Confirmation message will not be displayed.

  • 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".

  • When managing iOS device, it is required to execute the SDSVService.bat command and stop the service of the Relay server before executing this command.

Example of Use/Execution Results/Output Format

[Example of use when outputting all management information to "C:\DTKBKUP"]
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKMSTB.exe DTKDB User Password C:\DTKBKUP
2009/06/08 16:54:46  Backup management information collectively - Start
2009/06/08 16:54:46
2009/06/08 16:54:46   Database   :  DTKDB
2009/06/08 16:54:46   Directory   :  C:\DTKBKUP
2009/06/08 16:54:46
2009/06/08 16:54:46   - LEVELOBJECT
2009/06/08 16:54:47     Output file name  : C:\DTKBKUP\LEVELOBJECT.csv
2009/06/08 16:54:48     Number of output items.....172
2009/06/08 16:54:48

    ~~ (Omitted) ~~

2009/06/08 16:54:49   - POLICYTABLE
2009/06/08 16:54:49     Output file name  :   C:\DTKBKUP\POLICYTABLE.csv
2009/06/08 16:54:49     Number of output items.....1
2009/06/08 16:54:49
2009/06/08 16:54:49    -  iOS Management database
2009/06/08 16:54:49        Output file name  :  C:\DTKBKUP\MDMBackup.dump
2009/06/08 16:54:49
2009/06/08 16:54:49  Backup management information collectively - End
2009/06/08 16:54:49

Output cases are not displayed in the backup of iOS management database.

PreviousNext
Copyright 2005 - 2018 FUJITSU LIMITED