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 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\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 |
|
16 | [Reserved Number 1 - 4] | Number | 9 each | Reserved item |
17 | [Reserved Character 1 - 5] | Character | - | Reserved item |
