Functional Specification
When modifying the environment without collective management of users to the environment with collective management of users in three-level system structure, it is necessary to migrate "user information, definition of user policy" registered in each lower-level Management Server to Master Management Server.
This command migrates "user information, definition of user policy" out from lower-level Management Server into Master Management Server.
("Settings information of department administrator of user group" and "user tree information" are also the migration targets.)
Command Format
DTKTBLCV.EXE 15.2 {/UI|/UP|/IN|/CK} <File Name>Option
Enter the current system version, which is "15.2".
In user definition data, specify it when extracting user data (USERINFO) of administrator.
In user definition data, specify it when extracting user policy data.
Specify it when importing user definition data into the database of migration target.
Specify it when checking the import of user definition data. In addition, confirm whether the user in data file exists in the database environment of migration target.
Uppercase/lowercase letters can be used in the string of option. Fullwidth characters cannot be specified.
When outputting user definition data, specify a new file name. An error will occur when the specified file name already exists.
When outputting user definition data, specify an existing file name. Only one file can be specified.
Specify the file name with absolute path that contains drive name and folder name.
Return Value
Ended normally
Ended abnormally
Location for Saving Commands
Installation folder of database related files\DBEnv\DTKTBLCV.EXE
Authority Required for Execution/Execution Environment
Execute with a user that belongs to the Administrators group of the local computer or a user that belongs to the Domain Admins group of the domain.
Execute on the Management Server/Master Management Server.
Execute after stopping all the services of Management Server, backup function, restoration function, Active Directory Linkage function, or Systemwalker Desktop Patrol configuration information import function .etc, as well as other programs that accesses the database.
Execute in the environment in which both Management Server/Master Management Server is V15.2.0. The data migrated out by V15.1.0 can only be migrated into the environment of V15.2.0. It is unable to migrate old data to V15.2.0 or transfer data from V15.2.0 to an old environment.
Note
Execute in the database environment in which Systemwalker Desktop Keeper V15.2.0 has already been constructed.
Execute this command by setting Manage on each Management Server for the Manage user information in the System Settings of Server Settings Tool. Modify the setting of Manage user information to Manage collectively on Master Management Server after data migration.
Execute this command on each Management Server and copy the output file to Master Management Server.
Execute this command for each file that has been migrated on Master Management Server.
If the number of registered items of user policy data has reached to 100,000, it will be unable to register any more. Error will be output and processing will be interrupted.
If the number of registered items of user data of administrator has reached to 100,000, it will be unable to register any more. Error will be output and processing will be interrupted.
When repeated user data exists, the repeated data will not be registered (if multiple identical IDs exist in Management Server, only the user ID processed at first will be registered).
This command also migrates the tree information of user group, and the configuration value of department administrator set in the user group.
When executing this command in Windows Server 2008, Windows Server 2012, or Windows Server 2016, it is necessary to open the command prompt with "Run as Administrator".
Example of Use/Execution Results/Output Format
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\DBEnv>DTKTBLCV.EXE 15.2 /UI C:\Temp\USERINFO.DAT
Example of Output:
2013/06/30 18:03:30 Systemwalker Desktop Keeper Data Transfer - Start 2013/06/30 18:03:30 Option: UI (Export the transfer data of management information) 2013/06/30 18:03:30 Output file name : C:\Temp\USERINFO.dat 2013/06/30 18:03:30 Number of processed objects : 4 2013/06/30 18:03:30 Ended normally. 2013/06/30 18:03:30 Systemwalker Desktop Keeper Data Transfer - End
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\DBEnv>DTKTBLCV.EXE 15.2 /UP C:\Temp\USERPOLICY.DAT
Example of Output:
2013/06/30 18:04:31 Systemwalker Desktop Keeper Data Transfer - Start 2013/06/30 18:04:31 Option: UP (Export the transfer data of user/user group) 2013/06/30 18:04:31 Output file name : C:\Temp\USERPOLICY.dat 2013/06/30 18:04:31 Number of processed object : 3 2013/06/30 18:04:31 Ended normally. 2013/06/30 18:04:31 Systemwalker Desktop Keeper Data Transfer - End
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\DBEnv>DTKTBLCV.EXE 15.2 /CK C:\Temp\USERINFO.DAT
Example of Output:
2013/06/30 18:23:47 Systemwalker Desktop Keeper Data Transfer - Start 2013/06/30 18:23:47 Option: CK (Check transfer data) 2013/06/30 18:23:47 Input file name : C:\Temp\USERINFO.dat 2013/06/30 18:23:47 Input data: Administrator information 2013/06/30 18:23:47 Number of processed objects : 2 2013/06/30 18:23:47 dtk : Register 2013/06/30 18:23:47 dtkbk : Discard repetitively 2013/06/30 18:23:47 Number of items can be registered : 1 2013/06/30 18:23:47 Number of items reserved to discard : 1 2013/06/30 18:23:47 Ended normally. 2013/06/30 18:23:47 Systemwalker Desktop Keeper Data Transfer - End
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\DBEnv>DTKTBLCV.EXE 15.2 /CK C:\Temp\USERPOLICY.DAT
Example of Output:
2013/06/30 19:01:13 Systemwalker Desktop Keeper Data Transfer - Start 2013/06/30 19:01:13 Option: CK (Check transfer data) 2013/06/30 19:01:13 Input file name: C:\Temp\USERPOLICY.dat 2013/06/30 19:01:13 Input data : User/User Group Information 2013/06/30 19:01:13 GP Sales Department : Register 2013/06/30 19:01:13 US User001 : Register 2013/06/30 19:01:13 US User002 : Register 2013/06/30 19:01:13 US User003 : Register 2013/06/30 19:01:13 Number of processed objects : 4 2013/06/30 19:01:13 Number of items can be registered : 4 2013/06/30 19:01:13 Number of items reserved to discard : 0 2013/06/30 19:01:13 Ended normally. 2013/06/30 19:01:13 Systemwalker Desktop Keeper Data Transfers - End
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\DBEnv>DTKTBLCV.EXE 15.2 /IN C:\Temp\USERINFO.DAT
Example of Output:
2013/06/30 18:54:54 Systemwalker Desktop Keeper Data Transfer - Start 2013/06/30 18:54:54 Option: IN (Record transfer data) 2013/06/30 18:54:54 Input file name : C:\Temp\USERINFO.dat 2013/06/30 18:54:54 Input data : Administrator information 2013/06/30 18:54:54 dtk : Register 2013/06/30 18:54:54 dtkbk : Register 2013/06/30 18:54:54 Number of registered items: 2 2013/06/30 18:54:54 Number of discarded items : 0 2013/06/30 18:54:54 Ended normally. 2013/06/30 18:54:54 Systemwalker Desktop Keeper Data Transfer - End
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\DBEnv>DTKTBLCV.EXE 15.2 /IN C:\Temp\USERPOLICY.DAT
Example of Output:
2013/06/30 19:03:10 Systemwalker Desktop Keeper Data Transfer - Start 2013/06/30 19:03:10 Option: IN (Record transfer data) 2013/06/30 19:03:10 Input file name : C:\Temp\USERPOLICY.dat 2013/06/30 19:03:10 Input data : User/User Group information 2013/06/30 19:03:10 GP Sales Department : Register 2013/06/30 19:03:10 US User001 : Register 2013/06/30 19:03:10 US User002 : Register 2013/06/30 19:03:10 US User003 : Register 2013/06/30 19:03:10 Number of processed objects : 4 2013/06/30 19:03:10 Number of registered items: 4 2013/06/30 19:03:10 Number of discarded items : 0 2013/06/30 19:03:10 Ended normally. 2013/06/30 19:03:10 Systemwalker Desktop Keeper Data Transfer - End