Hello 아름 한,
To gather the labels from the checkpoints of the project history, we will need to run another command in addition to the one above.
I have created a batch file that will prompt the user for which Server to connect to, which Port to use, which User to use, which Project you are polling, and the File Name to output the information to. You can copy this batch file and modify it for your use. You can change the fields returned by modifying the --fields argument. For si viewprojecthistory your --fields options are: associatedIssues, author, date, description, labels, revision, and state. For si viewproject your --fields options are: attributes, cpid, labels, memberarchive, memberdescription, memberrev, name, state, symboliclink, and type. You can add/remove and change the order of these --fields options to get the output to your desired organization.
The bat file:
ECHO off
set /p UserInputHostname= Please enter the hostname of the Integrity Server to connect to:
set /p UserInputPort= Please enter the port that the server is listening on:
set /p UserInputUserName= Please enter the username to use:
set /p UserInputProject= Please enter the project name (full path):
set /p UserInputFile= Please enter the filename for the output file:
si viewprojecthistory --hostname=%UserInputHostname% --port=%UserInputPort% --user=%UserInputUserName% --fields=description,labels,revision -P %UserInputProject% >> Temp.txt
si viewproject --hostname=%UserInputHostname% --port=%UserInputPort% --user=%UserInputUserName% --fields=name,type,memberrev,labels -P %UserInputProject% >> Temp.txt
copy Temp.txt %UserInputFile%
del Temp.txt
ECHO Please see %UserInputFile% for the output of project %UserInputProject%
You can then open the file defined by the user as %UserInputFile% with Excel, using space delimiting, and continue on with Excel as you normally would.