Top
Systemwalker Desktop Keeper Installation Guide
FUJITSU Software

3.1.2 Back Up User Assets

This product provides the following three backup functions for user assets.

Backup Tool (GUI)

Set backup conditions through a GUI.

This command does not back up iOS management databases.

Backup tool (automatic)

Use the GUI window to configure the automatic backup conditions, so that backup will be performed automatically.

Backup Commands

Set backup conditions through command parameters. The commands themselves do not have a scheduling function.

Point

Adding the backup commands to the Task Scheduler will facilitate the command execution.

After being incorporated in a scheduled batch file, the backup commands can be executed at the specified time.

The Backup Tool (GUI) and backup commands can be used to perform the following operations:

The operational status of the Backup Tool (GUI) or backup commands will be output to event logs.

The Backup Tool (GUI) and the backup commands can back up the user assets (including management information and log information) except the attached data, but they do not back up the information about programs and settings information of the product. Use other software to regularly back up all the information.

3.1.2.1 Using the Backup Tool (GUI)

This section describes how to back up the user assets by using the Backup Tool (GUI).

Note

Notes on using the Backup Tool (GUI)

[Available space on the output target disk]

Ensure that there is sufficient available space on the disk specified as the output target disk for the backup files. If the disk space is insufficient to save a large amount of data, correspondingly narrow the date range of the targets to be saved.

[Available space on the installation target disk of the database-related files]

Ensure that there is sufficient available space on the installation target disk of the database-related files. When a large number of logs are to be backed up, there must be enough available space on the installation target disk of the database-related files. For details about disk capacity requirements, refer to "Operation Environment" in the Systemwalker Desktop Keeper User's Guide.

[Back up and restore on each server]

In a 3-level system architecture, each Management Server is installed with a database; therefore, perform the backup or restoration operation on each Master Management Server and Management Server separately.

[Data conversion]

The Backup Tool may convert data in a log and then output the converted log to a CSV file. The following data is converted:

  • Tab, carriage return, line feed replaced with halfwidth space

  • Double quotation mark (") escaped with double quotation mark ("")

[Attached data processing]

The Backup Tool/backup commands do not back up the attached data (including the screen capture data and backup original files). In addition, the attached data cannot be deleted even by the log deletion operation. Refer to "Attached Data" in "3.1.1 Targets and Methods" for details on backing up and restoring attached data.

[Email contents data processing]

Email contents data (email body, attachments) is not backed up when using the backup tool or backup commands. Also, even if you delete logs, the email contents data will not be deleted. Refer to "E-mail Contents" in "3.1.1 Targets and Methods" for details on backing up and restoring email contents data.

Point

Logon history of the Backup Tool (GUI)

The logon history of the Backup Tool (GUI) will be output to event logs (application).

Preparations

When backing up data for restoration, record the following setting information. (Obtain the collected bitmaps and notes of the windows.)

Target

Window to Be Backed Up

Management console

Terminal Operation Settings

Server Settings Tool

System Settings

Setting of Active Directory Linkage

Note: when the Active Directory linkage function is used

Administrator Notification Settings

Management Server Settings

Trace Settings

Self Version Upgrade Settings for Folder/CT

Perform the following steps to display the Terminal Operation Settings window:

  1. Start Management Console.

  2. Select Terminal Operation Settings from the Operation Settings menu.

    The Terminal Operation Settings window is displayed.

For details about how to display the windows of the Server Settings Tool, refer to "2.3.6 Set Environment of Management Server/Master Management Server".

Note

Properly store the recorded information.

The preceding setting information cannot be backed up using the Backup Tool. After restoring data, it is necessary to restore the terminal operation settings to the status before backup; therefore, ensure that the information recorded along with the backup data is properly stored.

Start Backup

The procedure for using the Backup Tool is as follows:

  1. When managing Android or iOS devices, use SDSVService.bat (start/stop service of Smart Device Relay Server command) to stop the service of the Smart Device Relay Server. Refer to "SDSVService.bat (Start/Stop Service of Smart Device Relay Server)" in the Systemwalker Desktop Keeper Reference Manual for details on the command.

  2. Log on to the Windows OS as a user of the Administrators group or Domain Admins group.

  3. Select All Programs > Systemwalker Desktop Keeper > Server > Backup Tool from the Start/Apps menu on the PC installed with the Master Management Server or Management Server.

    The Systemwalker Desktop Keeper - Backup Tool window is displayed.

  4. Enter the user ID (granted with the authority to back up and restore information) and password registered in the Server Settings Tool, and then click OK. (The user ID and password of the Primary Administrator can also be used for logon.)

    The Backup Tool window is displayed.

    The following table describes the menu bar in the Backup Tool window.

    Menu Bar

    Function Summary

    File

    Exit

    Exit the Backup Tool.

    Information

    Confirm number of tables

    Display the number of records in the log information table in the database.

    Service

    Conform service status

    Display the operational status of the "Level Control Service" and "Server Service" on the target server.

    Start service

    Start the "Level Control Service" and "Server Service" on the target server.

    Stop service

    Stop the "Level Control Service" and "Server Service" on the target server.

    Settings

    Set extraction item

    When backing up the logs in the Log Viewer format, backing up the log table and deleting the records in the log table, enter the date related to data item extraction and deletion.

    • Process according to Client Occurrence Date and Time (Standard)

    • Process according to Server Saving Date and Time

    Automatic backup settings

    Display the Automatic Backup Settings window.

    Backup tool trace

    No

    Do not collect the traces of the Backup Tool.

    Summary

    Collect the traces of the Backup Tool in summary mode.

    Details

    Collect the traces of the Backup Tool in details mode.

    Help

    Online Help

    Display the online help manual.

    Version Information

    Display the copyright information and version information.

  5. Before backing up the "management information" and "log information" by using the Backup Tool, it's necessary to stop the "Level Control Service" and "Server Service" on the target server.

    1. Select Stop Service from the Service menu. A confirmation window is displayed. Click OK in the window to stop the services.

    2. The operation result window is displayed.

  6. For first-time backup, set the data extraction method for log information backup and deletion. Select Extraction item settings from the Settings menu.

    The Extraction item settings window is displayed.

    The extraction item settings specify the time for log backup and deletion. This can be the time that logs were generated on the client or the time that logs were stored on the server.

    • Process in the client occurrence date and time (standard): Select this option when you want to operate based on the time that logs were generated on the client.

    • Process in the server saving date and time: Select this option when you want to operate based on the time that logs were stored on the server.

  7. To extract logs according to the time that logs were generated on the client (CT), select Process in the client occurrence date and time (standard). To extract logs according to the time that logs were stored on the server, select Process in the server saving date and time. Then, click Set.

    Note

    Do not change the extraction item settings after they are put into use.

    Do not change the extraction item settings after they are put into use. Otherwise, certain log data may fail to be backed up. If a change is required, make the change after the preceding data is backed up.

  8. In the Backup Tool window, enter the information described in steps 1 to 4.

    Step 1 Back up management information collectively

    Item Name

    Description

    Backup management information collectively

    Select it when backing up the management information.

    Target folder for saving backup files

    Select a folder for saving the backup management information. There are two methods for selecting such a folder:

    • Enter the absolute path of a folder.

    • Enter the absolute path of a folder for saving the output management information.

    • Click Browse.

    • The Viewing Folder window is displayed. Select a folder for saving the output management information and then click Open.

    An absolute path can contain a maximum of 189 single-byte characters (94 fullwidth characters). The folder name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|".

    The backup management information is saved in the MSyyyymmdd sub-folder of the specified folder. (yyyymmdd indicates the backup execution date.)

    If multiple backups are executed to the same folder on the same date, a unique sequential number enclosed by parentheses will be appended to the subfolder name. The first backup will be saved in MSyyyymmdd, the second one in MSyyyymmdd(1), the third one in MSyyyymmdd(2), and so on.

    Step 2 Back up the log information in Log Viewer format

    Item Name

    Description

    Backup the log information in Log Viewer format

    Select it when backing up the log information in the format that enables the logs to be viewed in the Log Viewer.

    Backup object period

    There are four options for specifying a backup target period:

    • Back up the logs later than the specified period.

      • The entered value of year ranges from 2000 to 9999, the value of month ranges from 1 to 12, and the value of date ranges from 1 to 31. (The period must end before or on the current date.)

    • Back up the logs earlier than the specified date.

      • The entered value of year ranges from 2000 to 9999, the value of month ranges from 1 to 12, and the value of date ranges from 1 to 31. (The date can be earlier than or equal to the current date.)

    • Back up the logs earlier than the specified number of days, counting from the current day.

      • The entered value ranges from 0 to 999.

      • If the entered value is 1, the logs earlier than the end of the last day will be backed up. If the entered value is 0, the logs earlier than the present moment will be backed up.

    • Back up the logs earlier than the specified number of months, counting from the current month.

      • The entered value ranges from 0 to 99.

      • If the entered value is 1, the logs earlier than the end of the last month will be backed up. If the entered value is 0, the logs earlier than the present moment will be backed up.

    Log type of backup target

    Select the type of logs to be backed up.

    Target folder for saving backup files

    Select a folder for saving the backup log information. There are two methods for selecting such a folder.

    • Enter the absolute path of a folder.

    • Enter the absolute path of a folder for saving the output logs.

    • Click Browse.

    • The Viewing Folder window is displayed. Select a folder for saving the output log information and then click OK.

    An absolute path can contain a maximum of 189 single-byte characters (94 fullwidth characters). The folder name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|".

    The backup logs are saved in the LVyyyymmdd sub-folder of the specified folder. (yyyymmdd indicates the backup execution date.)

    In addition, if the backup operation is performed for more than two times in a same day, a number is automatically added to the subfolder name, for example, (1).

    For the second backup operation: LVyyyymmdd(1)

    For the third backup operation: LVyyyymmdd(2)

    For the fourth backup operation: LVyyyymmdd(3)

    (The subsequent number can be deduced like this.)

    Step 3 Back up log information

    Item Name

    Description

    Backup log information

    Select it when backing up log information.

    Backup object period

    There are four options for specifying a backup target period.

    • Back up the logs later than the specified period.

      • The entered value of year ranges from 2000 to 9999, the value of month ranges from 1 to 12, and the value of date ranges from 1 to 31. (The period must end before or on the current date.)

    • Back up the logs earlier than the specified date.

      • The entered value of year ranges from 2000 to 9999, the value of month ranges from 1 to 12, and the value of date ranges from 1 to 31. (The date can be earlier than or equal to the current date.)

    • Back up the logs earlier than the specified number of days, counting from the current day.

      • The entered value ranges from 0 to 999.

      • If the entered value is 1, the logs earlier than the end of the last day will be backed up. If the entered value is 0, the logs earlier than the present moment will be backed up.

    • Back up the logs earlier than the specified number of months, counting from the current month.

      • The entered value ranges from 0 to 99.

      • If the entered value is 1, the logs earlier than the end of the last month will be backed up. If the entered value is 0, the logs earlier than the present moment will be backed up.

    Target folder for saving backup files

    Select a folder for saving the backup log information. There are two methods for selecting such a folder:

    • Enter the absolute path of a folder.

    • Enter the absolute path of a folder for saving the output logs.

    • Click Browse.

    • The Viewing Folder window is displayed. Select a folder for saving the output log information and then click OK.

    An absolute path can contain a maximum of 189 single-byte characters (94 fullwidth characters). The folder name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|".

    The backup logs are saved in the BKyyyymmdd sub-folder of the specified folder. (yyyymmdd indicates the backup execution date.)

    In addition, if the backup operation is performed for more than two times in a same day, a number is automatically added to the subfolder name, for example, (1).

    For the second backup operation: BKyyyymmdd(1)

    For the third backup operation: BKyyyymmdd(2)

    For the fourth backup operation: BKyyyymmdd(3)

    (The subsequent number can be deduced like this.)

    Step 4 Delete log information

    Item Name

    Description

    Delete log information

    Select it when deleting the log information.

    Delete object period

    There are five options for specifying a delete target period.

    • Delete the logs of the backup target period specified in step 3 "Back up log information".

    • Delete the logs of the specified period.

      • The entered value of year ranges from 2000 to 9999, the value of month ranges from 1 to 12, and the value of date ranges from 1 to 31. (The period must end before or on the current date.)

    • Delete the logs earlier than the specified date.

      • The entered value of year ranges from 2000 to 9999, the value of month ranges from 1 to 12, and the value of date ranges from 1 to 31. (The date can be earlier than or equal to the current date.)

    • Delete the logs earlier than the number of days, counting from the current day.

      • The entered value ranges from 0 to 999.

      • If the entered value is 1, the logs earlier than the end of the last day will be deleted. If the entered value is 0, the logs earlier than the present moment will be deleted.

    • Delete the logs earlier than the number of months, counting from the current month.

      • The entered value ranges from 0 to 99.

      • If the entered value is 1, the logs earlier than the end of the last month will be deleted. If the entered value is 0, the logs earlier than the present moment will be deleted.

  9. Enter the common settings in the Backup Tool window.

    Specify common setting. Execute log output

    Item Name

    Description

    Result log file

    Specify the file for saving the execution results of the Backup Tool. There are two methods for selecting such a file:

    • Enter the absolute path of a file.

    • Enter the absolute path of a file for saving the execution results.

    • Click Browse.

    • The Open File window is displayed. Select the folder for saving the result log file, enter the file name, and then click Open.

    An absolute path can contain a maximum of 255 single-byte characters (127 fullwidth characters). The file name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|".

    When the file exists

    Select the processing operation to be performed when the result log file exists at the location specified by Result Log File.

    • Add

    • Add a new result log to the end of the result log file if the file exists at the location specified by Result Log File.

    • Overwrite

    • Overwrite the last result log in the result log file if the file exists at the location specified by Result Log File.

  10. After completing all the settings, click Execute.

    In the confirmation window, click OK.

    Note

    If "Backup Target Period" and "Delete Target Period" are set to different values:
    If "Backup Target Period" and "Delete Target Period" are set to different values on the Backup Tool, the Backup Tool displays the following message informing you that this operation may delete the files that are not backed up and prompting you to check whether the settings are correct.

    [BKCI-SEL001] The [Backup Target Period] and [Delete Target Period] are set to different values. 
    Please check whether the target periods are correctly set.
    Are you sure to continue?
  11. The Backup Condition window is displayed and the backup process starts.

  12. When the backup process is completed successfully, the process completion window is displayed. Click OK in the window.

  13. After confirming the execution status, click Close.

  14. Start the stopped "Level Control Service" and "Server Service". Select Start Service from the Service menu. The service startup confirmation window is displayed. Click OK in the window to start the services.

  15. The operation result window is displayed. Click OK in the window.

  16. When managing Android or iOS devices, use SDSVService.bat (start/stop service of Smart Device Relay Server command) to start the service of the Smart Device Relay Server. Refer to "SDSVService.bat (Start/Stop Service of Smart Device Relay Server)" in the Systemwalker Desktop Keeper Reference Manual for details on the command.

Confirm Service Status

During the backup process, the Backup Tool must stop the Systemwalker Desktop Keeper services on the connected Management Server. Therefore, it is necessary to confirm the service status. This part describes how to confirm the status of the Systemwalker Desktop Keeper services by using the Backup Tool.

  1. Select Confirm Service Status from the Service menu.

    The Confirm Service Status window is displayed.

  2. Click OK after confirmation.

Confirm the Number of Records in the Log Information Table

This part describes how to use the Backup Tool to view the number of records in the log information table that are backup targets.

  1. Select Confirm Number of Tables from the Information menu.
    The Confirm Number of Tables window is displayed. For details about the contents in the table, refer to "Log Information (Not Including Command logs)" in "3.1.1.2 User Assets".

  2. Enter a target period.

    • The value of year ranges from 2000 to 9999.

    • The value of month ranges from 1 to 12.

    • The value of day ranges from 1 to 31.

  3. Click Confirm the number of tables.
    The number of logs is displayed in each table.

  4. Click Close after confirmation.

Exit the Backup Tool

  1. To exit the Backup Tool, select Exit from the File menu.

  2. The exit window is displayed.
    Select whether to save the conditions specified in the Backup Tool window. Click Yes to exit with the conditions saved, click No to exit without saving the conditions, or click Cancel to cancel the exiting operation.
    In addition, the menu settings (Extraction Item Settings and Settings of Debugging Trace) are saved when they are set.

Back up user assets

Refer to "3.1.1.2 User Assets" for details.

3.1.2.2 Automatic Data Backup and Deletion

Note

Time required by automatic data backup and deletion
The automatic data backup and deletion function will back up the management information, log information in Log Viewer format, and log information, and delete the log information.
Therefore, execution of this function may take some time.

This section describes how to set the automatic data backup and deletion function by using the Backup Tool (GUI).
Configure this if the backup and deletion settings were not configured during creation of the Operation Database.
Automatic backup and deletion are registered to Task Scheduler in Windows.

  1. Log on the Windows OS as a user of the Administrators group or Domain Admins group.

  2. Select All Programs > Systemwalker Desktop Keeper > Server > Backup Tool from the Start/Apps menu on the computer installed with the Master Management Server or Management Server.
    The Systemwalker Desktop Keeper - Backup Tool initialization window is displayed.

  3. Enter the user ID (granted with the authority to back up and restore information) and password registered in the Server Settings Tool, and then click OK. (The user ID and password of the Primary Administrator can also be used for logon.)

    The Backup Tool window is displayed.

  4. Select Automatic backup settings from the Settings menu.

    The Automatic backup settings window is displayed.

    Target

    Window to Backed Up

    Automatic backup/deletion

    Set whether to automatically back up and delete data.

    • Execute: Automatically back up and delete data.

    • Do not execute: Do not automatically back up and delete data.

    Default value: Yes

    Automatic backup/deletion settings

    Set an automatic data backup and deletion task.

    Task name

    Specify the task name registered in the Task Scheduler.

    The value (DTK_Auto_Backup_Command) is fixed.

    Backup target folder

    Specify the folder for saving data during automatic backup.
    It can be specified as follows:

    • Enter the folder name using the absolute path
      Enter the full path to the management information backup folder.

    • Select from View
      In the Browse For Folder window, select the management information backup folder, and then click OK.

    You can specify up to 94 fullwidth or 189 halfwidth characters and symbols, except for following: \ / : * ? " < > |

    The management information will be stored in the subfolder MSyyyyMmDd of the specified folder (yyyyMmDd is the date of the backup).

    If multiple backups are executed to the same folder on the same date, a unique sequential number enclosed by parentheses will be appended to the subfolder name. The first backup will be saved in MSyyyymmdd, the second one in MSyyyymmdd(1), the third one in MSyyyymmdd(2), and so on.

    The initial value is the folder specified during installation.

    Schedule Type

    Specify the interval for carrying out an automatic data backup and deletion task.

    • Day: The task is carried out every day.

    • Week: The task is carried out once a week.

    • Month: The task is carried out once a month.

    Default value: Day

    Execution week

    After selecting Weekly from Type of Schedule, select a weekday on which the task is to be carried out.

    The month and date can be selected.

    Default value: Monthly

    Execution date

    After selecting Monthly from Type of Schedule, enter the exact date on which the task is to be carried out.

    A value ranging from 1 to 31 can be entered.

    Default value: 1

    Execution start time

    Set the time at which an automatic data backup and deletion task is to be carried out.

    A time ranging from 00:00 to 23:59 can be set.

    Default value: 00:00

    Saving date

    Specify the time for saving operation logs.

    • Day: The value ranges from 1 to 366.

    • Week: The value ranges from 1 to 54.

    • Month: The value ranges from 1 to 13.

    If Daily is selected from Type of Schedule, only Day is available here.

    If Weekly is selected from Type of Schedule, Day and Week are available here.

    If Monthly is selected from Type of Schedule, Day and Month are available here.

    Default value:

    • Day: 30

    • Week: 4

    • Month: 1

    Operation log data outside the specified period will be deleted.

    Example: When a period of 30 days is specified, operation log data for the 31st and later days will be deleted

  5. Click Set.

Note

If a date 29 or later is specified for Execution Date, a message will be displayed indicating that the operation cannot be carried out on an unavailable date.

If the selected date is unavailable in the specified execution month, the automatic data backup and deletion task cannot be carried out. To ensure that the task can be carried out every month, specify a date earlier than 28.

Note

Edit a scheduled task by using the Task Scheduler of the OS.

After completing the Automatic Backup Settings, create a task named "DTK_Auto_Backup_Command" in the Task Scheduler of the OS. If the task is directly changed, the change cannot be updated in the Automatic backup settings window.

In addition, if the settings are changed in the Automatic backup settings window after a direct task change, the task change is overwritten by the change of settings in the Automatic backup settings window.

The saving period used by the automatic backup feature is calculated not from the date when the log information was created on the client (CT) but from the date when the log information was saved to the Management Server.

Considerations during backup

[Attached data processing]

Attached data (screen capture data, original email storage data) is not backed up when using the backup tool or backup commands. The attached data folder structure is shown below. Back up each folder individually according to your operations. Refer to "2.3.6.9 Set Saving Target Folder" for details on the storage folder for attached data. Note that even if DTKDELR (delete logs command) is executed, the attached data will not be deleted.
[Structure]

Attached data folder

+-Folder by date
+-Folder by CT

Example:

[Email contents data processing]

Email contents data (email body, attachments) is not backed up when using the backup commands. The email contents data folder structure is shown below. Back up each folder individually according to your operations. Refer to "2.3.6.9 Set Saving Target Folder" for details on the storage folder for email contents data.

Note that even if DTKDELR (delete logs command) is executed, the email contents data will not be deleted.
To delete the data, use DTKMLDL.BAT (delete e-mail content command). Refer to "DTKMLDL.BAT (Delete E-mail Content)" in the Systemwalker Desktop Keeper Reference Manual for details.
[Structure]

Email contents data folder

+-Folder by date
+-Folder by CT

Example:

Back up user assets

Refer to "3.1.1.2 User Assets" for details,

3.1.2.3 Using the Backup Commands

This section describes how to process the data in the database by using the backup commands provided by the Systemwalker Desktop Keeper.
The backup commands do not provide the task scheduling function.

Point

Adding the backup commands to the Task Scheduler will facilitate the command execution.

The Task Scheduler provided by the OS by default or the task scheduling software ARCserve can be used to set scheduled backup tasks. If using the Windows Server(R) 2008 or later, be aware that the user who executes the tasks is required to have administrator privileges.

Note

Notes on using the backup commands

[Level at which this command can be used]

This command can be used in V15.1.0 or later. These commands may fail if they are used in the environment constructed under other versions.

[Current folder during command execution]

When manually running the backup commands, set the current folder of the backup commands to the folder that saves the backup commands.

[Saving folder]
Installation folder of the database-related files\BackupCommand
(when newly installing Management Server V15.1.0, the installation folder for database-related files is mgmtServerInstallFolder\DB.)

Example: C:\DTKDB\BackupCommand

Example: C:\Program Files (x86)\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand

[Available space on the output target disk]

Ensure that there is sufficient available space on the disk specified as the output target disk for the backup files. If the disk space is insufficient to save a large amount of data, correspondingly narrow the date range of the targets to be saved.

[Available space on the installation target disk of the database-related files]

Ensure that there is sufficient available space on the installation target disk of the database-related files. When a large number of logs are to be backed up, there must be enough available space on the installation target disk of the database-related files. For details about disk capacity requirements, refer to "Operation Environment" in the Systemwalker Desktop Keeper User's Guide.

[Command execution authority in Windows Server(R) 2008]

In the Windows Server(R) 2008 OS, execution of the backup commands requires the administrator authority. Before running the backup commands, log on to the Windows OS as a user of the Administrators group or Domain Admins group.

[Enable the command extension function of the command prompt]

Execution of the backup commands requires that the command extension function of the command prompt be enabled.
The command extension function is enabled by default. Run "echo %CMDEXTVERSION%" in the command prompt window. If the output value is larger than or equal to 2, the command extension function is enabled.

[Date supported by the backup commands]

The date range that supports execution of the backup commands is from 2001-01-01 to 2034-12-31. The backup commands may not function on other dates.

[Data conversion]

The backup commands may convert data in a log and then output the converted log to a CSV file. The following data is converted:

  • Tab, carriage return, line feed replaced with halfwidth space

  • Double quotation mark (") escaped with double quotation mark ("")

[Attached data processing]

The backup tool/commands do not back up the attached data (including the screen capture data and backup original files). The structure of the target folder that saves the attached data is as follows. Back up the attached data separately by application. For details about the target folder that saves the attached data, refer to "2.3.6.9 Set Saving Target Folder". In addition, the attached data cannot be deleted even by the log deletion command (DTKDELR).
[Structure]

Target folder for saving attached data

+- Folder of day unit
+- Folder of CT unit

[Example]

[Email contents data processing]

The backup commands do not back up the E-mail contents (including the E-mail Text and attachments). The structure of the target folder that saves the E-mail contents is as follows. Back up the E-mail contents separately by application. For details about the target folder that saves the E-mail contents, refer to "2.3.6.9 Set Saving Target Folder".

In addition, the E-mail contents cannot be deleted even by the log deletion command (DTKDELR).
The DTKMLDL.BAT (Delete E-mail Content) command can be used to delete the E-mail contents. For details about how to use the command, refer to "DTKMLDL.BAT (Delete E-mail Content)" of the Systemwalker Desktop Keeper Reference Manual.
[Structure]

Target folder for saving e-mail content

+- Folder of day unit
+- Folder of CT unit

[Example]

Types of Backup Commands

The Systemwalker Desktop Keeper provides 13 types of backup commands. Each command performs different operations on the data in the database. The following table describes the commands. The folders used for saving backup commands are as follows:

Target folder for saving the backup commands:

Installation target folder of the database-related files\BackupCommand
(when newly installing Management Server V15.1.0, the installation folder for database-related files is mgmtServerInstallFolder\DB.)

Example: C:\DTKDB\BackupCommand
Example: C:\Program Files (x86)\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand C:\DTKDB\BackupCommand

No.

Command

Description

1

DTKMSTB.EXE

Back up each table described in "Management Information" of "3.1.1.2 User Assets" as a CSV file.

When managing iOS devices, the iOS management database is also backed up.

2

DTKLGTB.EXE

Back up each table described in "Log Information (Not Including Command logs)" of "3.1.1.2 User Assets" as a CSV file.

3

DTKLG1T.EXE

Output the log information from the database to CSV files in a specified format supported by the Log Viewer for one type only or for all data of all log types in batch, and view the log information.

4

DTKLGAT.BAT

Collectively output the log information from the database to CSV files in Log Viewer format, and view the log information.

5

DTKDELR.EXE

Delete the data in all the tables described in "Log Information (Not Including Command logs)" of "3.1.1.2 User Assets" and the data described in "Log Information (Command logs)".

6

DTKBKDL.BAT

Back up each table described in "Log Information (Not Including Command logs)" of "3.1.1.2 User Assets" as a CSV file and then delete the backed up table data from the database.

7

DTKCVDL.BAT

Back up each table described in "Log Information (Not Including Command logs)" of "3.1.1.2 User Assets" as a CSV file and collectively output log information from the database to CSV files. Then, delete the backed up table data from the database.

8

DTKSTCV.EXE

Output the collected setting change log information to a CSV file for the specified period.

9

DTKDELST.EXE

Delete logs registered within the specified period for the collected setting change log information.

10

DTKMLDL.BAT

Delete "E-mail Contents" in "3.1.1.2 User Assets" from the Management Server or Master Management Server.

11

DTKBFDM.EXE

Internal command invoked by other backup commands

Used for calculating the number of past days

12

DTKELSET.BAT

Internal command invoked by other backup commands

Used for re-setting the value of ERRORLEVEL

13

DTKNUMCK.BAT

Internal command invoked by other backup commands

Used for checking whether the input parameter values of the backup commands are numeric

14

DTKSERVICE.BAT

Display the start status of PostgreSQL and Desktop Keeper services, and start or stop these services.

15

DTKTBLTRUNCATE.BAT

Delete data in all tables described in "Log Information (Not Including Command logs)" in "3.1.1.2 User Assets" from the database.

This command initializes the tables, deletes all logs of the applicable tables, and releases the expansion area.

Unlike DTKDELR.EXE, the deletion period cannot be specified.

16

DTKTBLUNLOAD.BAT

Back up data in all tables described in "Log Information (Not Including Command logs)" in "3.1.1.2 User Assets" as a CSV file for each table.

This command outputs all data of the applicable tables.

Unlike DTKLGTB.EXE, the backup period cannot be specified.

17

DailySch.bat

Sample command that backs up and deletes logs that are 91 days old or more.

Refer to "Example I: Backing Up and Deleting the Logs Saved 91 Days Ago (Log Storage Life: 3 Months)" for details.

18

DailySch2.bat

Sample command that backs up and deletes logs that are 91 days old or more, and backs up logs for the most recent week.

Refer to "Examples of Creating Batch Files" for details.

19

DTKTask_DailySchBackup.bat

Sample command used to register tasks when DailySch.bat and DailySch2.bat are executed from tasks.

Refer to "Example I: Backing Up and Deleting the Logs Saved 91 Days Ago (Log Storage Life: 3 Months)" and "Examples of Creating Batch Files" for details.

Refer to "Command Reference" in the Systemwalker Desktop Keeper Reference Manual for details on each command (except DailySch.bat, DailySch2.bat, and DTKTask_DailySchBackup.bat).

Refer to "Example I: Backing Up and Deleting the Logs Saved 91 Days Ago (Log Storage Life: 3 Months)" and "Examples of Creating Batch Files" for details on DailySch.bat, DailySch2.bat and DTKTask_DailySchBackup.bat.

Edit Backup Commands

The following commands must be edited before they are used. Edit the following backup commands based on the operating environment.

DTKLGAT.BAT

To use "DTKLGAT.BAT", open it with a text editor and edit the following contents that are underlined and in bold type.

rem *****************************************************************
rem * Block for specifying operational parameters     *
rem *****************************************************************

rem Database name
set SQLDB=DTKDB

rem User ID used for connecting to the database
set SQLuser=(*1)

rem Password corresponding to the preceding user ID
set SQLpsw=(*2)

set startday=%1
set endday=%2

rem Name of the target drive for saving the output files
set bkdrive=(*3)

rem Name of the target folder for saving the output files (in the output process)
set bkdir=(*4)

rem Name of the folder created under the preceding bkdir folder
set csvdir=(*5)

rem Extraction key (A  null value indicates that the client time is used. The value "SERVER" indicates that the server time is used.)
set how=(*6)
rem ****************************************************
rem * Block for completing the process     *
rem ****************************************************

:allend0
pause(*7)
EXIT /B 0

:allend1
pause(*7)
EXIT /B 1

No.

Editing Content

Configuration Example

(*1)

Enter the user ID (granted with the authority to back up and restore information) registered in the Server Settings Tool.

BKUSER

(*2)

Enter the password corresponding to the preceding user ID.

BKPSW

(*3)

Enter the name of the target drive for saving the output files. (The drive letter must be followed by ":".)

C:

(*4)

Enter the name of the target folder for saving the output files in the output process. ("\" must be added before the folder name.)

\DTKBKUP

(*5)

Enter the name of the target folder for saving the output files, created under the folder set in (*4).

%2 indicates the end date of the backup target period, after which the folder is named. (Example: If the end date of the backup target period is April 20, 2007, the folder name is 20070420.)

LV%2

(*6)

Set whether client time (log occurrence date and time on the CT) or server time (log saving time on the server) is used in extraction of logs of the backup/delete target period.

  • Not specified
    Use the client time (log occurrence date and time on the CT).

  • SERVER
    Use the server time (log saving time on the server).

SERVER

(*7)

Enter "pause" or "rem pause".

  • "pause"
    The program will remain paused after the command execution ends. To exit the pause state, press any key in the command prompt window.

  • "rem pause"
    The program will close after the command execution ends.

rem pause

DTKBKDL.BAT

To use "DTKBKDL.BAT", open it with a text editor and edit the following contents that are underlined and in bold type.

rem ************************************************************
rem * Block for specifying operational parameters *
rem ************************************************************

rem Database name
set SQLDB=DTKDB

rem User ID used for connecting to the database
set SQLuser=(*1)

rem Password corresponding to the preceding user ID 
set SQLpsw=(*2)

rem Name of the target drive for saving the output files
set bkdrive=(*3)

rem Name of the target folder for saving the output files (in the output process)
set bkdir=(*4)

rem Name of the folder created under the preceding bkdir folder 
set logdir=(*5)

rem Extraction key (A null value indicates that the client time is used. The value "SERVER" indicates that the server time is used.) 
set how=(*6)
rem **************************************************************
rem * Block for completing the process             *
rem **************************************************************

:allend0
pause(*7)
EXIT /B 0

:allend1
pause(*7)
EXIT /B 1

No.

Editing Content

Configuration Example

(*1)

Enter the user ID (granted with the authority to back up and restore information) registered in the Server Settings Tool.

BKUSER

(*2)

Enter the password corresponding to the preceding user ID.

BKPSW

(*3)

Enter the name of the target drive for saving the output files. (The drive letter must be followed by ":".)

C:

(*4)

Enter the name of the target folder for saving the output files. ("\" must be added before the folder name.)

\DTKBKUP

(*5)

Enter the name of the target folder for saving the output files, created under the folder set in (*4).

%2 indicates the end date of the backup target period, after which the folder is named. (Example: If the end date of the backup target period is April 20, 2007, the folder name is 20070420.)

BK%2

(*6)

Set whether client time (log occurrence date and time on the CT) or server time (log saving time on the server) is used in extraction of logs of the backup/delete target period.

  • Not specified
    Use the client time (log occurrence date and time on the CT).

  • SERVER
    Use the server time (log saving time on the server).

SERVER

(*7)

Enter "pause" or "rem pause".

  • "pause"
    The program will remain paused after the command execution ends. To exit the pause state, press any key in the command prompt window.

  • "rem pause"
    The program will close after the command execution ends.

rem pause

DTKCVDL.BAT

To use "DTKCVDL.BAT", open it with a text editor and edit the following contents that are underlined and in bold type.

rem ************************************************************
rem * Block for specifying operational parameters *
rem ************************************************************

rem Database name
set SQLDB=DTKDB

rem User ID used for connecting to the database
set SQLuser=(*1)

rem Password corresponding to the preceding user ID 
set SQLpsw=(*2)

rem Number of days from the end date of the target period to the execution date
set bkdays=(*3)
set bkMonth=(*3)
set bkdate=(*3)

rem State date of the target period (date of the first record to be processed)

set startday=(*4)

DTKBFDM.EXE %bkdays% %bkMonth% %bkdate%
if errorlevel 20350101 goto errend4
if errorlevel 20010101 goto next1
goto errend4

:next1
set endday=%errorlevel%

rem Name of the target drive for saving the output files
set bkdrive=(*5)

rem Name of the target folder for saving the output files (in the output process)
set bkdir=(*6)

rem Name of the folder created under the preceding bkdir folder (BK indicates the backup data format.)
set logdir=(*7)

rem Name of the folder created under the preceding bkdir folder (LV indicates the Log Viewer format.)
set csvdir=(*8)

rem Extraction key (A null value indicates that the client time is used. The value "SERVER" indicates that the server time is used.)
set how=(*9)
rem **************************************************************
rem * Block for completing the process             *
rem **************************************************************

:allend0
pause(*10)
EXIT /B 0

:allend1
pause(*10)
EXIT /B 1

No.

Editing Content

Configuration Example

(*1)

Enter the user ID (granted with the authority to back up and restore information) registered in the Server Settings Tool.

BKUSER

(*2)

Enter the password corresponding to the preceding user ID.

BKPSW

(*3)

Enter the end date of the backup/delete target period, that is, a date several days or months before the date that "DTKCVDL.BAT" is executed. For details about the values, refer to "Backup/Delete Target Period".

  • set bkdays= Enter the number of days or months
    The number of days can range from 0 to 2000, and the number of months can range from 0 to 120. <bkmonth> determines whether the value of <bkdays> indicates the number of days or months.

  • set bkMonth= If it is set to "MONTH", the value of <bkdays> indicates the number of months. If it is not set to any value, the value of <bkdays> indicates the number of days.
    If it is set to "MONTH", set <bkdays> to the number of months.

  • set bkdate= If the value of <bkmonth> is "MONTH", set <bkdate> to 99 or a value ranging from 1 to 31. The value ranging from 1 to 31 indicates a corresponding specific date in the specified month. The value 99 indicates the end of the specified month. If <bkmonth> does not have any value, it is not necessary to set <bkdate>.

(To specify 90 days ago:)

set bkdays=90
set bkMonth=
set bkdate=

(To specify the first day of the month that is three months ago:)

set bkdays=3
set bkMonth=MONTH
set bkdate=1

(To specify the last day of the month that is three months ago:)

set bkdays=3
set bkMonth=MONTH
set bkdate=99

(*4)

Enter the start date of the backup/delete target period. The data between the start date and the end date set in (*4) will be backed up or deleted.

The start date can be set to "00000000" or a value ranging from "20010000" to "20349999". The start date must be earlier than the end date set in (*3). Otherwise, errors may occur.

If the last four digits of the value ranging from 20010000 to 20349999 cannot be found in the calendar, the following dates will be specified:

  • If the last four digits are "0000", the start date is January, 1.

  • If the last four digits are a value ranging from "1232" to "9999", the start date is January, 1 of the next year.

  • If the last two digits are "00", the start date is the first day of the specified month.

  • If the last two digits are a value ranging from "the day after the end date of the specified month" to "99", the start date is the first day of the month following the specified month.

If "00000000" is entered, the start date is the date from which the database starts storing data.

For details about the values, refer to "Backup/Delete Target Period".

00000000

(*5)

Enter the name of the target drive for saving the output files. (The drive letter must be followed by ":".)

C:

(*6)

Enter the name of the target folder for saving the output files in the output process. ("\" must be added before the folder name.)

\DTKBKUP

(*7)

Enter the name of the target folder for saving the output files, created under the folder set in (*6).

%endday% indicates the end date of the backup target period, after which the folder is named. (Example: If the end date of the backup target period is April 20, 2007, the folder name is 20070420.)

BK%endday%

(*8)

Enter the name of the target folder for saving the output files, created under the folder set in (*6).

%endday% indicates the end date of the backup target period, after which the folder is named. (Example: If the end date of the backup target period is April 20, 2007, the folder name is 20070420.)

LV%endday%

(*9)

Set whether client time (log occurrence date and time on the CT) or server time (log saving time on the server) is used in extraction of logs of the backup/delete target period.

  • Not specified
    Use the client time (log occurrence date and time on the CT).

  • SERVER
    Use the server time (log saving time on the server).

SERVER

(*10)

Enter "pause" or "rem pause".

  • "pause"
    The program will remain paused after the command execution ends. To exit the pause state, press any key in the command prompt window.

  • "rem pause"
    The program will close after the command execution ends.

rem pause

Backup/Delete Target Period

To use "DTKCVDL.BAT", the backup/delete target period must be specified. The following figure shows (*3) and (*4) described in the preceding table, which are related to the configuration of the target period. For details about the editing contents, refer to the preceding table.

DTKTBLTRUNCATE.BAT

To use " DTKTBLTRUNCATE.BAT ", open it with a text editor and edit the following contents that are underlined and in bold type.

rem *********************************************************
rem * Operating Parater Specification Block                 *
rem *********************************************************

rem Describe database name
set SQLDB=DTKDB

rem Describe user ID connecting to database(Manager ID of operation DB is set)
set SQLuser=(*1)

rem Describe the password corresponding to the user ID connecting to the database
set SQLpsw=(*2)

No.

Editing Content

Configuration Example

(*1)

Enter the user ID (granted with the authority to back up and restore information) registered in the Server Settings Tool.

BKUSER

(*2)

Enter the password corresponding to the preceding user ID.

BKPSW

DTKTBLUNLOAD.BAT

To use " DTKTBLUNLOAD.BAT ", open it with a text editor and edit the following contents that are underlined and in bold type.

rem *********************************************************
rem * Operating Parater Specification Block                 *
rem *********************************************************

rem Describe database name
set SQLDB=DTKDB

rem Describe user ID connecting to database(Manager ID of operation DB is set)
set SQLuser=(*1)

rem Describe the password corresponding to the user ID connecting to the database
set SQLpsw=(*2)

No.

Editing Content

Configuration Example

(*1)

Enter the user ID (granted with the authority to back up and restore information) registered in the Server Settings Tool.

BKUSER

(*2)

Enter the password corresponding to the preceding user ID.

BKPSW

Preparations

When backing up data for restoration, record the following setting information. (Obtain the collected bitmaps and notes of the windows.)

Target

Window to Be Backed Up

Management console

Terminal Operation Settings

Server Settings Tool

System Settings

Setting of Active Directory Linkage

Note: When the Active Directory linkage function is used

Administrator Notification Settings

Management Server Settings

Self Version Upgrade Settings for Folder/CT

Perform the following steps to display the Terminal Operation Settings window:

  1. Start Management Console.

  2. Select Terminal Operation Settings from the Operation Settings menu.
    The Terminal Operation Settings window is displayed.

For details about how to display the windows of the Server Settings Tool, refer to "2.3.6 Set Environment of Management Server/Master Management Server".

Note

Properly store the recorded information.

The preceding setting information cannot be backed up by the Backup Tool. After restoring data, it is necessary to restore the terminal operation settings to the status before backup; therefore, ensure that the information recorded along with the backup data is properly stored.

Start Backup

For details about how to use the backup commands, refer to "Command Reference" of the Systemwalker Desktop Keeper Reference Manual.

Note

Ensure that services are stopped before command execution.

Stop the "Level Control Service", "Server Service" and Smart Device Relay Server before the backup or restoration operation is performed. Otherwise, data may be incomplete during backup or restoration.

When selecting backup commands after batch files are created, ensure that the Server Service and Level Control Service are stopped, as described in "Examples of Creating Batch Files in the Task Scheduler".

In addition, after starting SWServerService or during date change (12am), confirmation of available database capacity will be performed. In the 15 minutes till the confirmation operation has completed, service may not be able to be stopped.

Therefore, when registering to scheduled task, prevent it from executing batch file at the above time frame.

The following procedure must be manually performed:

  1. Log on the PC as a user of the local Administrators group or Domain Admins group.
    If there is another running application, exit it.

  2. In the displayed Windows Services window, select the following services and select Stop from the Action menu. It will take 30 seconds to 1 minute. In addition, after starting SWServerService or during date change (12am), confirmation of available database capacity will be performed. In the 15 minutes till the confirmation operation has completed, service may not be able to be stopped. Wait for a while and check if the service has stopped.

    • SWLevelControlService

    • SWServerService

Also, when managing Android or iOS devices, use SDSVService.bat (start/stop service of Smart Device Relay Server command) to stop the service of the Smart Device Relay Server. Refer to "SDSVService.bat (Start/Stop Service of Smart Device Relay Server)" in the Systemwalker Desktop Keeper Reference Manual for details.


The following examples are used to illustrate how to add the backup commands to the Task Scheduler and execute the commands in two modes.

Example I: Backing Up and Deleting the Logs Saved 91 Days Ago (Log Storage Life: 3 Months)

Execution Conditions
  • Set the data storage life to 90 days. The data stored longer than this period will be backed up to files and no longer be kept in the database.

  • Create a folder named after the backup date in the specified drive every day and back up the data stored in the database for longer than 91 days to the created folder.

  • The backup targets are as follows:

    • All the tables described in "Management Information" (with DTKMSTB)

    • All the tables (log data in the database and command logs) described in "Log Information", as well as the log information stored in the database (with DTKCVDL)

    For details about the data to be backed up, refer to "3.1.1.2 User Assets".

  • Delete the data that is already backed up from the database (with DTKCVDL).

  • Use the Task Scheduler of the OS to enable automatic backup. Stop the services on the Systemwalker Desktop Keeper Server side before command execution in order to avoid conflict between the access operation of services and the database record deletion operation.

  • After the server-side services are stopped, start command execution at 02:00 a.m. when there are fewer database connections.

  • Verify the time required by backup and deletion of the database records. Assume that it takes about 30 minutes in total.

Execution Settings

To perform operations under the preceding execution conditions, use the provided backup commands DTKMSTB, DTKCVDL, DailySch, and DTKTask_DailySchBackup.bat.

In the execution settings, the structures of the target drive and folder for saving backup files are as follows (XXXXXXXX indicates the end date):

  • All the tables described in "Management Information"
    In D:\BACKUP\XXXXXXXX\MSXXXXXXXX\

  • All the tables (log data in the database and command logs) described in "Log Information"
    In D:\BACKUP\XXXXXXXX\BKXXXXXXXX\

  • Log information stored in the database
    In D:\BACKUP\XXXXXXXX\LVXXXXXXXX\

For details about the data to be backed up, refer to "3.1.1.2 User Assets".
To implement the execution settings, perform the following steps:

  1. Modify the DTKCVDL contents as follows:

    set  SQLuser=bkuser           ...Set the user ID used for connecting to the database.
    set  SQLpsw=bkpsw            ...Set the password corresponding to the preceding user ID.
    set  bkdays=90                 ...Set the data storage life.
    set  bkdrive=D:                 ...Set the target drive for backing up the logs.
    set  bkdir=\BACKUP\%endday%  ...Set the target folder for backing up the logs.
    Change pause to rem pause.
  2. Rewrite "DailySch.bat". Refer to "Examples of Creating Batch Files" below for details on the content that is to be rewritten.

  3. Add "DTKTask_DailySchBackup.bat" to the "Task Scheduler".

    1. Click Administrative Tools > Task Scheduler, and then select Create Task.

    2. Click Browse in the Start a Program window and select "DTKTask_DailySchBackup.bat".

    3. Enter the task name and set the task to run at 02:00 a.m. every day.

    4. Since task execution requires a user ID and a password, set the user ID and password of a user with administrator authority.

Examples of Creating Batch Files

Examples describing how to create a registration batch file to be registered to "DailySch.bat" and "DTKTask_DailySchBackup.bat" are stored in the following folder.

dbRelatedFileInstallFolder\BackupCommand\

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

In this example of creating batch commands, the return value of the Net command invoked inside the batch file is not used as the return value of the batch commands. Take cautions when using the return value of the Net command to control the further processing.

Open "DailySch.bat" in a text editor, and edit the underlined section in bold below.

Example of Creating DailySch.bat

@ECHO OFF
SETLOCAL
rem ****************************************************************************
rem *                                                                          *
rem *   Systemwalker Desktop Keeper Maintenance Tool                           *
rem *                                                                          *
rem *   Process Name : Example-The log before 91 days ago is backed up deleted *
rem *            (Log preservation period:Three months)                        *
rem *   Function Name : DailySch.bat                                           *
rem *                                                                          *
rem *   Copyright (C) FUJITSU LIMITED 2012-2015                                *
rem *                                                                          *
rem ****************************************************************************
rem
rem ***********************************************************
rem * Setting                                                 *
rem ***********************************************************
rem The drive letter at the output target is described
SET BKDRIVE=D:

rem The folder name at the output target is described
SET BKFOLDERNAME=\BACKUP

rem The measurement days to set the processing end date are described
SET DELEND=90

rem Describe user ID connecting to database
SET SQLUSER=dtkbkuser

rem Describe password connecting to database
SET SQLPASSWORD=dtkpsw

rem The backup command storage target is described
SET BACKUPCOMMANDFOLDER=dbRelatedFileInstallFolder\BackupCommand

rem Extraction Key(Client date when omitting it,Server date when specifying SERVER)
SET HOW=SERVER

rem ***************************************************************
rem * Processing part                                             *
rem ***************************************************************
path "%BACKUPCOMMANDFOLDER%";%path%
echo Backup processing start(%TIME%)

%BKDRIVE%
CD %BKFOLDERNAME%
if ERRORLEVEL 1 goto recover5

rem Calculation on backup end day
"%BACKUPCOMMANDFOLDER%\DTKBFDM.EXE" %DELEND%

rem The directory is made on the execution day
SET TEMPDATE=%ERRORLEVEL%
MKDIR %TEMPDATE%

rem the backup target folder is made
SET MSFOLDER=%BKDRIVE%%BKFOLDERNAME%\%TEMPDATE%\MS%TEMPDATE%
MKDIR "%MSFOLDER%"

echo DTK service is stopped.
call "%BACKUPCOMMANDFOLDER%\DTKSERVICE.BAT" stop
if ERRORLEVEL 1 goto recover2

rem Backup of mastering system data
"%BACKUPCOMMANDFOLDER%\DTKMSTB.EXE" DTKDB %SQLUSER% %SQLPASSWORD% "%MSFOLDER%"

if ERRORLEVEL 1 goto recover3

rem Backup and deletion of log system data
CALL "%BACKUPCOMMANDFOLDER%\DTKCVDL.BAT"
if ERRORLEVEL 1 goto recover4

echo The DTK service is started.
call "%BACKUPCOMMANDFOLDER%\DTKSERVICE.BAT" start
echo The schedule ended normally.(%TIME%)
EXIT /B 0

:recover1
echo It made an error of the stop of level control service.
echo The backup is discontinued, and the DTK service (level control service) is started.
goto allend1

:recover2
echo It made an error of the stop of server service.
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover3
echo It made an error of the backup of administrative information. 
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover4
echo It made an error of the backup and the deletion of the log.
echo The backup and the deletion of the log are discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover5
echo The backup folder does not exist.
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:allend1
echo The DTK service is started.
call "%BACKUPCOMMANDFOLDER%\DTKSERVICE.BAT" start
echo The schedule ended abnormally.(%TIME%)
EXIT /B 1

Example of Creating DTKTask_DailySchBackup.bat

Change the database-related file installation folder according to the environment.
Change the underlined item in bold to "DailySch.bat" below.

@echo off
SETLOCAL

rem *************************************************************
rem *                                                           *
rem *   Systemwalker Desktop Keeper Maintenance tool            *
rem *                                                           *
rem *   Process Name : Registration batch                       *
rem *   Function Name : DTKTask_DailySchBackup.bat              *
rem *                                                           *
rem *   Copyright (C) FUJITSU LIMITED 2012-2015                 *
rem *                                                           *
rem *************************************************************
rem
rem ***********************************************************
rem * Setting                                                 *
rem ***********************************************************
set BACKUPCOMMANDFOLDER=dbRelatedFileInstallFolder\BackupCommand

rem ***********************************************************
rem * Processing                                              *
rem ***********************************************************
rem Calculation on execution day
"%BACKUPCOMMANDFOLDER%\DTKBFDM.EXE" 0
SET EXECDAY=%ERRORLEVEL%

rem The execution log is made by the log file name at the execution date.(e.g.20140112.log)
rem The log file is stored in the folder set to "Start in (optional)" when the task is registered.
call "%BACKUPCOMMANDFOLDER%\DailySch.bat" > %EXECDAY%.log
if ERRORLEVEL 1 goto allend1

EXIT /B 0

:allend1
EXIT /B 1
Example of Result Logs of Batch File Execution

The execution result log (%EXECDAY%.log) records the execution results of the registered DailySch.bat file in the preceding example.

Backup processing start(18:45:42.11)
DTK service is stopped.
Sat 05/23/2015-18:45:42.45 -DTKSERVICE-------------------------------------------------------
Sat 05/23/2015-18:45:42.47 [ Service termination processing of the management server (STOP) ]
Sat 05/23/2015-18:45:42.48 ------------------------------------------------------------------
Sat 05/23/2015-18:45:42.97 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-18:45:43.26 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-18:45:43.28 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-18:45:43.53 The service of management server(SWLevelControlService)       :operating
Sat 05/23/2015-18:45:43.69 The service of management server(SWServerService)       :operating
Sat 05/23/2015-18:45:43.70 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-18:45:43.72 The service of iOS management database       :unregistration
Sat 05/23/2015-18:45:43.72 The service inquiry of the management server ended.
Sat 05/23/2015-18:45:43.73 The service of the management server (SWLevelControlService) is stopped.
Sat 05/23/2015-18:45:46.30 The SWLevelControlService was stopped.
Sat 05/23/2015-18:45:46.31 The service of the management server (SWServerService) is stopped.
Sat 05/23/2015-18:45:49.18 The SWServerService was stopped.
Sat 05/23/2015-18:45:49.93 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-18:45:50.10 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-18:45:50.10 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-18:45:50.26 The service of management server(SWLevelControlService)       :halt condition
Sat 05/23/2015-18:45:50.42 The service of management server(SWServerService)       :halt condition
Sat 05/23/2015-18:45:50.42 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-18:45:50.43 The service of iOS management database       :unregistration
Sat 05/23/2015-18:45:50.45 Service stopped.
2015/05/23 18:45:50  Backup management information collectively - Start
2015/05/23 18:45:50  
2015/05/23 18:45:50   Database   :  DTKDB
2015/05/23 18:45:50   Directory   :  D:\BACKUP\20150222\MS20150222
2015/05/23 18:45:50  
2015/05/23 18:45:50   - LEVELOBJECT
2015/05/23 18:45:50     Output file name  : D:\BACKUP\20150222\MS20150222\LEVELOBJECT.csv
2015/05/23 18:45:50     Number of output items.....11
2015/05/23 18:45:50  
2015/05/23 18:45:50   - LEVELCOMPOSITION
2015/05/23 18:45:50     Output file name  : D:\BACKUP\20150222\MS20150222\LEVELCOMPOSITION.csv
2015/05/23 18:45:50     Number of output items.....10


(Omitted)


2015/05/23 18:45:58   - LOGKEYWORDS
2015/05/23 18:45:58     Number of deleted items.....0
2015/05/23 18:45:58  
2015/05/23 18:45:58   - FILEACCESSLOG
2015/05/23 18:45:58     Number of deleted items.....0
2015/05/23 18:45:58  
2015/05/23 18:45:58   - SESSIONMANAGE
2015/05/23 18:45:58     Number of deleted items.....0
2015/05/23 18:45:58  
2015/05/23 18:45:58  Delete log information - End
2015/05/23 18:45:58  Delete configuration change log information - Start
2015/05/23 18:45:58  
2015/05/23 18:45:58  Database    :  DTKDB
2015/05/23 18:45:58  Processing start date     :  00000000
2015/05/23 18:45:58  Processing finish date      :  20150222
2015/05/23 18:45:58  Deletion indication         :  -Y
2015/05/23 18:45:58  
2015/05/23 18:45:58     Processing 2015/01/01 ... 71 items are deleted
2015/05/23 18:45:59     Number of deleted items.....71
2015/05/23 18:45:59  
2015/05/23 18:45:59   Delete configuration change log information - End
The DTK service is started.
Sat 05/23/2015-18:45:59.29 -DTKSERVICE-----------------------------------------------------
Sat 05/23/2015-18:45:59.31    [ service start processing (START) of the Management server ]
Sat 05/23/2015-18:45:59.33 ----------------------------------------------------------------
Sat 05/23/2015-18:45:59.81 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-18:46:00.00 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-18:46:00.01 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-18:46:00.37 The service of management server(SWLevelControlService)       :halt condition
Sat 05/23/2015-18:46:00.53 The service of management server(SWServerService)       :halt condition
Sat 05/23/2015-18:46:00.54 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-18:46:00.56 The service of iOS management database       :unregistration
Sat 05/23/2015-18:46:00.58 The service inquiry of the management server ended.
Sat 05/23/2015-18:46:00.61 The service of the management server (SWLevelControlService) is started.
Sat 05/23/2015-18:46:02.74 The service of the management server (SWServerService) is started.
Sat 05/23/2015-18:46:07.60 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-18:46:07.80 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-18:46:07.82 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-18:46:08.02 The service of management server(SWLevelControlService)       :operating
Sat 05/23/2015-18:46:08.21 The service of management server(SWServerService)       :operating
Sat 05/23/2015-18:46:08.23 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-18:46:08.23 The service of iOS management database       :unregistration
Sat 05/23/2015-18:46:08.24 Service was started.
The schedule ended normally.(18:46:08.27)

Example II: Deleting the Logs Saved 91 Days Ago and Backing Up the Logs Saved in the Recent Week (Log Storage Life: 3 Months)

Execution Conditions
  • Set the data storage life to 90 days. The data stored longer than this period will be backed up to files and no longer be kept in the database.

  • Create a folder named after the backup start date in the specified drive every day and back up the data of the recent week to the created folder.

  • The backup targets are as follows:

    • All the tables described in "Management Information" (with DTKMSTB)

    • All the tables (log data in the database and command logs) described in "Log Information", as well as the log information stored in the database

    For details about the data to be backed up, refer to "3.1.1.2 User Assets".

  • Delete the data saved in the database 91 days ago.

  • Use the Task Scheduler of the OS to enable automatic backup. Stop the services on the Systemwalker Desktop Keeper Server side before command execution in order to avoid conflict between the access operation of services and the database record deletion operation.

  • After the server-side services are stopped, start command execution at 02:00 a.m. when there are fewer database connections.

  • Verify the time required by backup and deletion of the database records. Assume that it takes about 30 minutes in total.

The following figure shows an example.

For example, set the backup target period to the week before the execution date and delete the logs saved 91 days ago.

Execution Settings

To perform operations under the preceding execution conditions, use the provided backup commands DTKMSTB, DTKLGTB, DTKLG1T, DTKDELR, DailySch2, and DTKTask_DailySchBackup.bat.

In the execution settings, the structures of the target drive and folder for saving backup files are as follows (XXXXXXXX indicates the backup start date):

  • All the tables described in "Management Information"

    In D:\BACKUP\XXXXXXXX\MSXXXXXXXX\

  • All the tables (log data and command logs in the database) described in "Log Information"

    In D:\BACKUP\XXXXXXXX\BKXXXXXXXX\

  • Log information stored in the database

    In D:\BACKUP\XXXXXXXX\LVXXXXXXXX\

For details about the data to be backed up, refer to "3.1.1.2 User Assets".

To implement the execution settings, perform the following steps:

  1. Rewrite DailySch2.bat. Refer to "Examples of Creating Batch Files" below for details on the content that is to be rewritten. Create the target folder for log backup, specified in the execution settings.
    That is, D:\BACKUP in the example of execution settings.

  2. Add "DTKTask_DailySchBackup.bat" to the "Task Scheduler".

    1. Click Administrative Tools > Task Scheduler, and then select Create Task.

    2. Click Browse in the Start a Program window and select "DTKTask_DailySchBackup.bat".

    3. Enter the task name and set the task to run at 02:00 a.m. every day.

    4. Since task execution requires a user ID and a password, set the user ID and password of a user with administrator authority.

Examples of Creating Batch Files

Examples describing creation of DailySch2.bat and DTKTask_DailySchBackup.bat are stored in the following folder.

dbRelatedFileInstallFolder\BackupCommand\

When newly installing Management Server V15.1.0, the installation folder of database-related files is mgmtServerInstallFolder\DB.
In this example of creating batch commands, the return value of the Net command invoked inside the batch file is not used as the return value of the batch commands. Take caution when using the return value of the Net command to control the further processing.
Open "DailySch2.bat" in a text editor, and edit the underlined section in bold below.

Example of Creating DailySch2.bat

@ECHO OFF
SETLOCAL
rem **********************************************************************
rem *                                                                    *
rem *   Systemwalker Desktop Keeper Maintenance Tool                     *
rem *                                                                    *
rem *   Process Name : Example-The log before 91 days ago is deleted     *
rem *            and the log during one week ago from today is backed up *
rem *            (Log preservation period:Three months)                  *
rem *   Function Name : DailySch2.bat                                    *
rem *                                                                    *
rem *   Copyright (C) FUJITSU LIMITED 2012-2015                          *
rem *                                                                    *
rem **********************************************************************
rem
echo Setting begins
rem *****************************************************************
rem * Setting                                                       *
rem *****************************************************************
rem The drive letter at the output target is described
SET BKDRIVE=D:

rem The folder name at the output target is described
SET BKFOLDERNAME=\BACKUP

rem Whether how many days the backup begins is described
rem Example When you specify seven days ago
SET BKSTART=7

rem From how many days to ago data is deleted is described
rem Example When specifying it before 90 days ago
SET DELEND=90

rem Describe user ID connecting to database
SET SQLUSER=dtkbkuser

rem Describe password connecting to database
SET SQLPASSWORD=dtkpsw

rem The backup command storage target is described
SET BACKUPCOMMANDFOLDER=dbRelatedFileInstallFolder\BackupCommand

rem Extraction Key(Client date when omitting it,Server date when specifying SERVER)
SET HOW=SERVER

rem ***************************************************************
rem * Processing part                                             *
rem ***************************************************************
path "%BACKUPCOMMANDFOLDER%";%path%

echo Backup processing start(%TIME%)

%BKDRIVE%
CD %BKFOLDERNAME%
if ERRORLEVEL 1 goto recover7

echo Calculation on backup beginning day
rem Calculation on backup beginning day
"%BACKUPCOMMANDFOLDER%\DTKBFDM.EXE" %BKSTART%
SET BKSTARTDAY=%ERRORLEVEL%

rem Calculation on backup end day
"%BACKUPCOMMANDFOLDER%\DTKBFDM.EXE" 0
SET BKENDDAY=%ERRORLEVEL%

rem Calculation at deletion end date
"%BACKUPCOMMANDFOLDER%\DTKBFDM.EXE" %DELEND%
SET DELENDDAY=%ERRORLEVEL%

rem The folder is made at the backup start date(Log data)
MKDIR %BKSTARTDAY%
SET BKFOLDER=%BKDRIVE%%BKFOLDERNAME%\%BKSTARTDAY%\BK%BKSTARTDAY%
MKDIR "%BKFOLDER%"

rem The folder is made at the backup start date(Reference data)
SET LVFOLDER=%BKDRIVE%%BKFOLDERNAME%\%BKSTARTDAY%\LV%BKSTARTDAY%
MKDIR "%LVFOLDER%"

rem the backup target folder is made
SET MSFOLDER=%BKDRIVE%%BKFOLDERNAME%\%BKSTARTDAY%\MS%BKSTARTDAY%
MKDIR "%MSFOLDER%"

echo DTK service is stopped.
call "%BACKUPCOMMANDFOLDER%\DTKSERVICE.BAT" STOP

rem Backup of mastering system data
"%BACKUPCOMMANDFOLDER%\DTKMSTB.EXE" DTKDB %SQLUSER% %SQLPASSWORD% "%MSFOLDER%"

if ERRORLEVEL 1 goto recover3

rem Backup of log system data
"%BACKUPCOMMANDFOLDER%\DTKLGTB.exe" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% "%BKFOLDER%" %HOW%

if ERRORLEVEL 1 goto recover4

rem Backup of log system (Reference)
"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 3 "%LVFOLDER%\Application startup prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 9 "%LVFOLDER%\Printing prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 10 "%LVFOLDER%\Logon prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 12 "%LVFOLDER%\PrintScreen key prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 1 "%LVFOLDER%\Application startup log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 2 "%LVFOLDER%\Application termination log.csv" %how%
if ERRORLEVEL 1 goto recover5
"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 4 "%LVFOLDER%\Window title obtaining log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 17 "%LVFOLDER%\Window title obtaining (with URL) log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 5 "%LVFOLDER%\E-mail sending log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 7 "%LVFOLDER%\Device configuration change log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 8 "%LVFOLDER%\Printing operation log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 11 "%LVFOLDER%\File export log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 6 "%LVFOLDER%\Command operation log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 13 "%LVFOLDER%\File operation log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 16 "%LVFOLDER%\E-mail attachment prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 90 "%LVFOLDER%\Linkage application log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 14 "%LVFOLDER%\Logon,Logoff log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 24 "%LVFOLDER%\FTP operation prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 25 "%LVFOLDER%\FTP operation log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 29 "%LVFOLDER%\Web operation prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 31 "%LVFOLDER%\Web operation log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 34 "%LVFOLDER%\E-mail sending interruption log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 37 "%LVFOLDER%\Clipboard operation log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 38 "%LVFOLDER%\Clipboard operation prohibition log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 106 "%LVFOLDER%\Incoming outgoing calls log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKLG1T.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% 107 "%LVFOLDER%\Application configuration change log.csv" %how%
if ERRORLEVEL 1 goto recover5

"%BACKUPCOMMANDFOLDER%\DTKSTCV.EXE" DTKDB %SQLUSER% %SQLPASSWORD% %BKSTARTDAY% %BKENDDAY% "%LVFOLDER%\Configuration Change Log.csv"
if ERRORLEVEL 1 goto recover5

rem Deletion of log system data
"%BACKUPCOMMANDFOLDER%\DTKDELR.exe" DTKDB %SQLUSER% %SQLPASSWORD% 00000000 %DELENDDAY% -Y %HOW%
if %ERRORLEVEL% LSS 100 goto recover6

"%BACKUPCOMMANDFOLDER%\DTKDELST.EXE" DTKDB %SQLUSER% %SQLPASSWORD% 00000000 %DELENDDAY% -Y
if %ERRORLEVEL% LSS 100 goto recover6

goto allend0

:recover1
echo It made an error of the stop of level control service.
echo The backup is discontinued, and the DTK service (level control service) is started.
goto allend1

:recover2
echo It made an error of the stop of server service.
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover3
echo It made an error of the backup of administrative information. 
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover4
echo It made an error of the backup of log information.
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover5
echo It made an error of the backup of log information (Reference).
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover6
echo It made an error of the deletion of log information. 
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:recover7
echo The backup folder does not exist.
echo The backup is discontinued, and the DTK service (level control service,server service) is started.
goto allend1

:allend0
echo The DTK service is started.
call "%BACKUPCOMMANDFOLDER%\DTKSERVICE.BAT" START
echo The schedule ended normally.(%TIME%)
EXIT /B 0

:allend1
echo The DTK service is started.
call "%BACKUPCOMMANDFOLDER%\DTKSERVICE.BAT" START
echo The schedule ended abnormally.(%TIME%)
EXIT /B

Example of Creating DTKTask_DailySchBackup.bat

Change the database-related file installation folder according to the environment.
Change the underlined item in bold to "DailySch2.bat" below.

@echo off
SETLOCAL

rem *************************************************************
rem *                                                           *
rem *   Systemwalker Desktop Keeper Maintenance tool            *
rem *                                                           *
rem *   Process Name : Registration batch                       *
rem *   Function Name : DTKTask_DailySchBackup.bat              *
rem *                                                           *
rem *   Copyright (C) FUJITSU LIMITED 2012-2015                 *
rem *                                                           *
rem *************************************************************
rem
rem ***********************************************************
rem * Setting                                                 *
rem ***********************************************************
set BACKUPCOMMANDFOLDER=dbRelatedFileInstallFolder\BackupCommand

rem ***********************************************************
rem * Processing                                              *
rem ***********************************************************
rem Calculation on execution day
"%BACKUPCOMMANDFOLDER%\DTKBFDM.EXE" 0
SET EXECDAY=%ERRORLEVEL%

rem The execution log is made by the log file name at the execution date.(e.g.20140112.log)
rem The log file is stored in the folder set to "Start in (optional)" when the task is registered.
call "%BACKUPCOMMANDFOLDER%\DailySch2.bat" > %EXECDAY%.log
if ERRORLEVEL 1 goto allend1

EXIT /B 0

:allend1
EXIT /B 1
Example of Result Logs of Batch File Execution

The execution result log (%EXECDAY%.log) records the execution results of the registered DailySch2.bat file in the preceding example.

Setting begins
Backup processing start(19:30:50.97)
Calculation on backup beginning day
DTK service is stopped.
Sat 05/23/2015-19:30:51.23 -DTKSERVICE-------------------------------------------------------
Sat 05/23/2015-19:30:51.23 [ Service termination processing of the management server (STOP) ]
Sat 05/23/2015-19:30:51.25 ------------------------------------------------------------------
Sat 05/23/2015-19:30:51.83 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-19:30:52.14 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-19:30:52.15 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-19:30:52.48 The service of management server(SWLevelControlService)       :operating
Sat 05/23/2015-19:30:52.75 The service of management server(SWServerService)       :operating
Sat 05/23/2015-19:30:52.76 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-19:30:52.78 The service of iOS management database       :unregistration
Sat 05/23/2015-19:30:52.79 The service inquiry of the management server ended.
Sat 05/23/2015-19:30:52.81 The service of the management server (SWLevelControlService) is stopped.
Sat 05/23/2015-19:30:55.39 The SWLevelControlService was stopped.
Sat 05/23/2015-19:30:55.40 The service of the management server (SWServerService) is stopped.
Sat 05/23/2015-19:30:58.29 The SWServerService was stopped.
Sat 05/23/2015-19:30:59.04 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-19:30:59.21 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-19:30:59.23 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-19:30:59.38 The service of management server(SWLevelControlService)       :halt condition
Sat 05/23/2015-19:30:59.54 The service of management server(SWServerService)       :halt condition
Sat 05/23/2015-19:30:59.54 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-19:30:59.55 The service of iOS management database       :unregistration
Sat 05/23/2015-19:30:59.57 Service stopped.
2015/05/23 19:30:59  Backup management information collectively - Start
2015/05/23 19:30:59  
2015/05/23 19:30:59   Database   :  DTKDB
2015/05/23 19:30:59   Directory   :  D:\BACKUP\20150516\MS20150516
2015/05/23 19:30:59  
2015/05/23 19:30:59   - LEVELOBJECT
2015/05/23 19:30:59     Output file name  : D:\BACKUP\20150516\MS20150516\LEVELOBJECT.csv
2015/05/23 19:30:59     Number of output items.....11
2015/05/23 19:30:59  
2015/05/23 19:30:59   - LEVELCOMPOSITION
2015/05/23 19:30:59     Output file name  : D:\BACKUP\20150516\MS20150516\LEVELCOMPOSITION.csv
2015/05/23 19:30:59     Number of output items.....10
2015/05/23 19:30:59  
2015/05/23 19:30:59   - PRINTPERMISSION
2015/05/23 19:30:59     Output file name  : D:\BACKUP\20150516\MS20150516\PRINTPERMISSION.csv
2015/05/23 19:30:59     Number of output items.....0
2015/05/23 19:30:59  


(Omitted)


2015/05/23 19:31:15  
2015/05/23 19:31:15   - FILEBRINGOUTLOG
2015/05/23 19:31:15     Number of deleted items.....0
2015/05/23 19:31:15  
2015/05/23 19:31:15   - LOGKEYWORDS
2015/05/23 19:31:15     Number of deleted items.....0
2015/05/23 19:31:15  
2015/05/23 19:31:15   - FILEACCESSLOG
2015/05/23 19:31:15     Number of deleted items.....0
2015/05/23 19:31:15  
2015/05/23 19:31:15   - SESSIONMANAGE
2015/05/23 19:31:15     Number of deleted items.....0
2015/05/23 19:31:15 
2015/05/23 19:31:15  Delete log information - End
2015/05/23 19:31:15  Delete configuration change log information - Start
2015/05/23 19:31:15  
2015/05/23 19:31:16  Database    :  DTKDB
2015/05/23 19:31:16  Processing start date     :  00000000
2015/05/23 19:31:16  Processing finish date      :  20150222
2015/05/23 19:31:16  Deletion indication         :  -Y
2015/05/23 19:31:16  
2015/05/23 19:31:16     Processing 2015/01/01 ... 71 items are deleted
2015/05/23 19:31:16     Number of deleted items.....71
2015/05/23 19:31:16  
2015/05/23 19:31:16   Delete configuration change log information - End
The DTK service is started.
Sat 05/23/2015-19:31:17.10 -DTKSERVICE-----------------------------------------------------
Sat 05/23/2015-19:31:17.10    [ service start processing (START) of the Management server ]
Sat 05/23/2015-19:31:17.11 ----------------------------------------------------------------
Sat 05/23/2015-19:31:17.55 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-19:31:17.82 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-19:31:17.83 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-19:31:18.07 The service of management server(SWLevelControlService)       :halt condition
Sat 05/23/2015-19:31:18.27 The service of management server(SWServerService)       :halt condition
Sat 05/23/2015-19:31:18.29 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-19:31:18.30 The service of iOS management database       :unregistration
Sat 05/23/2015-19:31:18.30 The service inquiry of the management server ended.
Sat 05/23/2015-19:31:18.35 The service of the management server (SWLevelControlService) is started.
Sat 05/23/2015-19:31:20.46 The service of the management server (SWServerService) is started.
Sat 05/23/2015-19:31:25.30 The service of POSTGRESQL(Operation)       :operating
Sat 05/23/2015-19:31:25.52 The service of POSTGRESQL(Log view)       :operating
Sat 05/23/2015-19:31:25.54 The service of SYMFOWARE(Log analyze)       :unregistration
Sat 05/23/2015-19:31:25.72 The service of management server(SWLevelControlService)       :operating
Sat 05/23/2015-19:31:25.91 The service of management server(SWServerService)       :operating
Sat 05/23/2015-19:31:25.91 The service of management server(Log analyze)       :unregistration
Sat 05/23/2015-19:31:25.93 The service of iOS management database       :unregistration
Sat 05/23/2015-19:31:25.94 Service was started.
The schedule ended normally.(19:31:26.35)

Back up user assets

Refer to "3.1.1.2 User Assets" for details.