Top
Systemwalker Desktop Keeper User's Guide for Administrator
FUJITSU Software

3.5 Export CT information/User information

According to the results of log viewing, if the existence of the client (CT) and user that perform violation is confirmed, the search result of client (CT) information and user information can be exported in CSV format.

The following section describes how to export the information displayed in the CT list of The Management Console, CT policy information and user information of user policy to CSV files.

Export CT Information

This section describes how to export the information displayed in the CT list of the Management Console to a CSV file.

The users who satisfy all the following conditions can perform the operation:

The settings of all these conditions are configured in the Server Settings Tool during installation.

Note

The CT information that belongs to the "Deleted CT" group cannot be exported to CSV files.

Follow the procedure below:

  1. Start Management Console.

  2. Select Export CT Information in CSV Format from the File menu.

    The Specify a File for Export CT Information in CSV Format window is displayed.

  3. After entering the following information, click the Start Export button.

    Item Name

    Description

    Export Files

    Specify the CSV file for export. The specification method is as follows:

    • Enter a file name with full path
      Enter the full path of imported CSV file in the input field.

    • Enter by clicking the View button
      The Specify an Export File window is displayed, after entering the drive and the file name of the CSV file to be exported, click the Save button.

    The length of the full path should be within 218 halfwidth characters (109 fullwidth characters). The following symbols are not allowed in a file name:
    "\""/"":""*""?"""""<"">""|"

    Separator

    Select the Separator when the CSV file is exported.

    Quotation Marks of String

    Select the String Quotation when the CSV file is exported.

    Export Format

    Select the format of the exported CSV file.

    V12.0L20 Base Edition Compatible Format: Export in V12.0L20 Base Edition format.
    V12.0L20 Standard Edition Compatible Format: Export in V12.0L20 Standard Edition compatible format
    V13.0.0 Compatible Format: Export in V13.0.0 format.
    V13.2.0 - V14.1.0 Compatible Format: Export in V13.2.0 format.

    V14.2.0 Format: Export in V14.2.0 format.

    For item names of the exported CSV file and exported information, refer to "CT Information" of Reference Manual.

    The CSV file is exported.

    Among the exported items, if there is a character that is identical to the one selected in the String Quotation, one character selected in Quotation Marks of String will be added in front of that character.

    When a file with same name exists in the export destination, the window for selecting whether to overwrite will be displayed. To overwrite, click the OK button.

Export CT Group Information

This section describes how to export the information displayed in the CT group tree of the Management Console to CSV files.

The users who satisfy all the following conditions can perform the operation. The settings of all these conditions are configured in Server Settings Tool during installation.

CT group information can be exported to every Management Server.
When CT group information is exported from the Management Console that connects to the Master Management Server, the group information of the CT under the Master Management Server will be exported.
When linking with Active Directory, only the information of the Local group can be exported.

Follow the procedure below:

  1. Start Management Console.

  2. Select Export CT Group Information in CSV Format from the File menu.

    The Specify a File for Exporting CT Group Information in CSV Format window is displayed.

  3. After entering the following information, click the Start Export button.

    Item Name

    Description

    Export Files
    (Required)

    Specify the CSV file for exporting CT group information with a full path.

    The length of the full path should be within 218 halfwidth characters (109 fullwidth characters). The following symbols are not allowed in a file name:
    "\""/"":""*""?"""""<"">""|"

    • When it is not Windows 7, Windows 8.1, Windows 10, Windows Server 2008, Windows Server 2012 or Windows Server 2016
      Initial Value: [OS Installation Drive]\Documents and Settings\Logon User Name\My Documents\DTKCTEntry.csv

    • When it is Windows 7, Windows 8.1, Windows 10, Windows Server 2008, Windows Server 2012 or Windows Server 2016
      Initial Value: [OS Installation Drive]\User\Logon User Name \Documents\DTKCTEntry.csv

    Result Log File
    (Required)

    Specify the file for saving the execution result with a full path.

    Specify the full path using up to 218 halfwidth characters (109 fullwidth characters). However the following symbols are not allowed in a file name:
    "\""/"":""*""?"""""<"">""|"

    • When it is not Windows 7, Windows 8.1, Windows 10, Windows Server 2008, Windows Server 2012 or Windows Server 2016
      Initial Value: [OS Installation Drive]\Documents and Settings\Logon User Name\My Documents\DTKCTEntry.log

    • When it is Windows 7, Windows 8.1, Windows 10, Windows Server 2008, Windows Server 2012 or Windows Server 2016
      Initial Value: [OS Installation Drive]\User\Logon User Name \Documents\DTKCTEntry.log

    When result log file exists

    When the original result log file exists, make sure to set it.

    • Add: Select to add new files to the original result log file.

    • Overwrite: Select to overwrite the original result file.

    The CSV file is exported.
    For item names of the exported CSV file and exported information, refer to "CT Group Information" of Reference Manual.

Export User Information

The following section describes how to export the information that is displayed in the user list of the User Policy Setting window in CSV format.

The users who satisfy all the following conditions can perform the operation:

The settings of all these conditions are performed in the Server Settings Tool during installation.

Follow the procedure below:

  1. Start Management Console.

  2. Select User Policy Settings from the User Settings menu.

    The User Policy Settings window is displayed.

  3. Select Export User Information in CSV Format from the Link with CSV window

    The Specify a File for Exporting User Information in CSV Format window is displayed.

  4. After entering the following information, click the Start Export button.

    Item Name

    Description

    Export Files
    (Required)

    Specify the CSV file for export. The specification method is as follows:

    • Enter a file name with full path
      Enter the full path of imported CSV file in the input field.

    • Enter by clicking the Browse button
      The Specify an Export File window is displayed, after entering the drive and the file name of the CSV file to be exported, click the Save button.

    The length of the full path should be within 218 halfwidth characters (109 fullwidth characters). The following symbols are not allowed in a file name:
    "\""/"":""*""?"""""<"">""|"

    Separator (Required)

    Select the Separator when the CSV file is exported.

    Quotation Marks of String (Required)

    Select the String Quotation when the CSV file is exported.

    Export Format

    Select the format of the exported CSV file.

    V12.0L20 ~ V13.0.0 Compatible Format: Export in the format that is same as V13.0.0 or earlier.
    V13.2.0 - V14.1.0 Compatible Format: Export in V13.2.0 format.

    V14.2.0 Format: Export in V14.2.0 format.

    For the item name of the exported CSV file and exported information, refer to "User Information" of Reference Manual.

    The CSV file is exported.

    Among the exported items, if there is a character that is identical to the one selected in Quotation Marks of String, one character selected in Quotation Marks of String will be added in front of that character.

    When a file with same name exists in the export destination, the window for selecting whether to overwrite will be displayed. To overwrite, click the OK button.

    Note

    The user information CSV output file is used for verifying registered user information and policy settings information.

    The CSV file output here cannot be used to register using the feature described in "Register Users Collectively Using CSV File" in "3.3.2 Register a User". This is because there are too many items in the output CSV file.

    Refer to "Output CSV files for use" in "User Information" in the Reference Manual for details on the output format for the user information CSV output file.

Export IP Address of Client (CT)

In following cases, the client (CT) with self version upgrade can be selected. The IP address of client (CT) under the server or CT group is exported as the format of file to be used at the time.

For details on how to use the exported file, refer to "Upgrading the client (CT)" of Installation Guide.

In addition, the system administrator and department administrators can also confirm the managed PC in the CT group unit.

Follow the procedure below to export the file:

  1. Start Management Console, and select a server or CT group in the CT group tree.

  2. Select Output IP Address of Subordinate CT from the File menu.
    Or right-click on a server or a CT group and select Output IP Address of Subordinate CT.

    The Specify a File for Exporting the IP Address of Subordinate CT window is displayed.

    • Export Files (Required): Specify the CSV file for exporting IP address with full path.

      Specify the full path using up to 218 halfwidth characters (109 fullwidth characters). However, the following symbols are not allowed in a file name.
      "\""/"":""*""?"""""<"">""|"

    • Result Log File (Required): Specify the file for saving the execution result with full path.

      Specify the full path using up to 218 halfwidth characters (109 fullwidth characters). However the following symbols are not allowed in a file name.
      "\""/"":""*""?"""""<"">""|"

    • When result log file exists: When the original result log file exists, make sure to set it.
      Add: Select to add new files to the original result log file.
      Overwrite: Select to overwrite the original result file.

  3. Set the above information and click the Start Export button.
    For the item name of exported CSV file and exported information, refer to "IP Address Export File of CT under a Group" of Reference Manual.