Functional Specification
In Management Console, when the settings information of the client (CT) and user policy is modified, it will be collected as configuration change log in Management Server. In addition, operations performed in the Management Console and Log Viewer will also be collected as configuration change log. The information of collected configuration change log will be output after specifying a period.
Command Format
DTKSTCV.EXE DTKDB <User> <Password> <StartDate> <EndDate> <OutFile>
Option
Fixed value.
Enter the logon ID registered in Server Settings Tool (The access authority is the logon ID of "Backup/Restore").
Enter the password of the above logon ID.
Enter the start day for data processing (8 digits). The range of value is "20010000" - "20349999" and "00000000". When the value of last 4 digits of "20010000" - "20349999" do not exist in the calendar, the following date will be specified.
When the last 4 digits are specified to "0000"
Jan. 1 of the specified year will be the start date.
When the last 4 digits are specified to "1232" - "9999"
Jan. 1 of the next year of the specified year will be start date.
When the last 2 digits are specified to "00"
1st of the specified month will be the start date.
When the last 2 digits are specified to "second day after the end of month" - "99"
1st of the next month of the specified month will be the start date.
In addition, when "00000000" is entered, the start date will be determined as the time when data started to be accumulated in database.
Enter the end date for data processing (8 digits). The range of value is "20010000" - "20349999" that is larger than the value of <StartDate>. When the value of last 4 digits of "20010000" - "20349999" do not exist in the calendar, the following date will be specified.
When the last 4 digits are specified to "0000"
Dec. 31 of the year previous to the specified year will be the end date.
When the last 4 digits are specified to "1232" - "9999"
Dec. 31 of the specified year will be the end date.
When the last 2 digits are specified to "00"
The last date of the last month of specified month will be the end date.
When the last 2 digits are specified to "second day after the end of month" - "99"
The last date of the specified month will be the end date.
Enter the file of saving target with absolute path. The folder should be created in advance.
In the command option, an option that contains a space, etc., cannot be specified.
When specifying an option, data enclosed with double quotations cannot be specified.
In particular, pay attention when entering the file name of <OutFile>.
Return Value
Ended normally
Ended abnormally
Location for Saving Commands
Installation folder of database related files\BackupCommand\DTKSTCV.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.
Note
The command execution result will be output to the command prompt. To remain the execution result, specify the file to output execution result through redirection when executing this command.
When the file with same name as the output file in the folder, replace it by force. Confirmation message will not be displayed.
Since the CSV data output function of configuration change log is different from the backup function, the data that has been output cannot be restored to the original table.
When executing this command in the environment of Windows Server(R) 2008, or Windows Server(R) 2012, 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\BackupCommand>DTKSTCV.exe DTKDB User Password 20010000 20349999 C:\DTKBKUP\settingslog.csv 2009/06/08 17:26:00 CSV export of setting change log - Start 2009/06/08 17:26:00 2009/06/08 17:26:00 Database : DTKDB 2009/06/08 17:26:00 Processing start date : 20010000 2009/06/08 17:26:00 Processing finish date : 20349999 2009/06/08 17:26:00 Output file : C:\DTKBKUP\settingslog.csv 2009/06/08 17:26:00 2009/06/08 17:26:00 - Configuration Change Log (Related to CT/CT Group 2009/06/08 17:26:00 Number of output items......32 2009/06/08 17:26:00 2009/06/08 17:26:00 - Configuration Change Log (Related User/User Group) 2009/06/08 17:26:02 Number of output items......11 2009/06/08 17:26:02 2009/06/08 17:26:02 - Configuration Change Log (Other) 2009/06/08 17:26:02 Number of output......1 2009/06/08 17:26:02 2009/06/08 17:26:02 CSV export of setting change log - End 2009/06/08 17:26:02
Items output in CSV file are as follows.
No. | Data Item | Type | Digits | Output Format |
|---|---|---|---|---|
1 | [Date and Time] | Character | 19 | "YYYY/MM/DD HH:MM:SS" format |
2 | [No.] | Number | 9 | No. beginning from 1 of each operation |
3 | [Identification ID] | Character | 36 | Item set uniquely for client (CT), etc. |
4 | [Category] | Number | 9 | Code value is 0 - 99 0: Terminal Settings 1: Level Composition Settings 2: Services Control 3: Process Control 10: User Settings 11: User Level Composition Settings 99: Other 0-3 In the case of CT 0 - 1 In the case of CT group 10 - 11 In the case of user/user group 99 In the case of Management Console/Log Viewer |
5 | [Operation] | Number | 9 | 0: Register 1: Update (Modify) 2: Delete 3: Search (Screen Output) 4: File Output 5: File Input |
6 | [Setting Content] | Character | 2048 | Settings saved on DB |
7 | [User ID] | Character | 40 | User ID during authentication in the Management Console or Log Viewer. |
8 | [Operation Object] | Number | 9 | 1:CT 2:CT Group 3:User 4:User Group 0: Other 9: Set when CT/CT group is deleted at the time of migration during data migration from V13.0.0 or earlier |
9 | [Operation Computer Name] | Character | 15 | Name of computer on which Management Console/Log Viewer has been started When operating on the Log Viewer of V14.2.0 or later, "Operation Computer name" will not be recorded (this information cannot be obtained on Web). |
10 | [Operation Logon User Name] | Character | 40 | Logon ID to the terminal on which Management Console/Log Viewer has been started When operating on the Log Viewer of V14.2.0 or later, "Operation Logon User name" will not be recorded (this information cannot be obtained on Web). |
11 | [Operation Logon Domain Name] | Character | 156 | Authentication domain name during logon in terminal on which Management Console/Log Viewer has been started When operating on the Log Viewer of V14.2.0 or later, "Operation Logon Domain name" will not be recorded (this information cannot be obtained on Web). |
12 | [Operation Application] | Number | 9 | 1: Management Console (when used by administrator) 2: Management Console (when used by department administrator) 16: Log Viewer (when used by administrator) 32: Log Viewer (when used by department administrator) |
13 | [Name] | Character | 40 | When "Operation Object" is 1 - 4: CT Name/CT Group Name/User Name/User Group Name When "Operation Object" is 0 or 9: Halfwidth space of 1 character |
14 | [Computer Name/User ID] | Character | 40 | In the case of CT: Computer Name In the case of user: Windows Logon ID In the case of CT group/user group/others: Halfwidth space of 1 character |
15 | [Operation Category] | Number | 9 |
1002: Real-time service control 1003: Real-time process control 1004: Create CT group, user group 1005: Delete CT, CT group, user, user group 1006: Move CT, CT group, user, user group 1007: Communication settings 1008: User, user group policy settings 1009: Delete user 1010: CT operation settings 1011: Delete all groups 1012: Copy level object 1013: Department administrator settings 1101: Logon operation 1102: Logoff operation 1103: Export CT information in CSV format 1104: Export user information in CSV format 1105: Import user information in CSV format 1106: Export Desktop Patrol linkage in CSV format 1107: Import Desktop Patrol linkage in CSV format 1109: When modifying debugging trace 1110: When modifying Management Console trace 1112: When executing CT updating configuration 1114: When executing user updating configuration 1115: Change password 1116: Export department administrator information in CSV format 1117: Import department administrator information in CSV format 1118: Export USB device file 1119: Import USB device file 1120: Export IP address file of CT 1121: Register/Update/Delete USB device 1122: Cancel CT debugging trace settings 1123: Export CT group information in CSV format 1124: Update USB device operation settings 1125: Remote control
2110: Save original file of log details 2115: Change password |
16 | [Reserved Number 1 - 4] | Number | 9 each | Reserved item |
17 | [Reserved Character 1 - 5] | Character | - | Reserved item |
