ResultsUtil Command-Line Options
Published: February 29, 2012
Updated: May 31, 2012
Applies To: Windows 8
The ResultsUtil command is used when you want to store assessment results in a SQL Server database. By default the results are stored on the Windows® Assessment Services server in a results store. The ResultsUtil command is used to configure the Windows Assessment Services server to automatically access the results from the results share when a job is completed, and store them into a SQL database. It is also used to import existing results into a SQL database. After you install Windows Assessment Services on a server, use the ResultsUtil commands to initialize the results database on a SQL Server instance before you import individual results or configure Windows Assessment Services to post results to the database automatically.
 Warning |
|---|
| Results that are stored in a SQL Server database do not include the Assessment Platform presentation layer and cannot be viewed in the Windows® Assessment Services - Client (Windows ASC). A custom reporting solution is required to view the results. |
The following are system requirements for running the ResultsUtil command:
-
Windows® Assessment Services
-
Windows Server® 2008 R2 or Windows Server® 2012
-
A full version of SQL Server 2005 Standard Edition or later
The syntax to initialize the database with the ResultsUtil command is:
ResultsUtil /InitializeDatabase [/DB <Database Connection String>] [/User <Database user name>] [/FileSave]
The syntax to import results with ResultsUtil is:
ResultsUtil /ImportResults /InputFile <File name> [/DB <Database Connection String>] [/User <Database user name>] [/Project <Project name>] [/TestPass <Test pass name>] [/RunTag <Run tag>] [/Tags <User defined tags>] [/NoSyncResult]
The syntax to configure the instance of Windows Assessment Services to store results to the database with the ResultsUtil command is:
ResultsUtil /ConfigureWASserver [/DB <Database Connection String>] [/User <Database user name>] [/WasServer <WAS server address>] [/Quiet]
The following table provides a description of how each option can be used. These options are not case sensitive.
| Option | Description | ||
|---|---|---|---|
|
/InitializeDatabase |
Installs the results database on the specified instance of SQL Server. Example: ResultsUtil /InitializeDatabase /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /user MyName /filesave |
||
|
/ImportResults |
Imports the specified results file into the results database. Example: ResultsUtil /ImportResults /inputfile C:\WAS\Results\JobRestulsCompouterGUID.xml /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /user MyName /project MyProject /testpass Milestone1 /runtag Run1 /tags M1Results |
||
|
/ConfigureWASserver |
Configures the specified instance of Windows Assessment Services to store results to the specified results database. Example: ResultsUtil /ConfigureWASserver /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /user MyName /WasServer http://WASserver:8000/relax/service |
||
|
/InputFile <filename> |
Identifies a results file to be imported into the results database. The full path to the results file must be specified. Example: ResultsUtil /ImportResults /inputfile C:\WAS\Results\JobRestulsCompouterGUID.xml |
||
|
/DB <database_connection_string> |
Points to a connection string with the instance of SQL Server and the database to be created. Example: ResultsUtil /InitializeDatabase /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /user MyName /filesave |
||
|
/User <user_name> |
Identifies the user name that will be used for the connection to the SQL server instance. Example: ResultsUtil /ImportResults /inputfile C:\WAS\Results\JobRestulsCompouterGUID.xml /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /user MyName |
||
|
/Project <project_name> |
Creates a project name or overwrites it if it already exists. For assessment results imported from a job that ran in the Windows® Assessment Console on a local computer, the project name does not exist. If the results were generated from a job that ran in a lab environment that uses Windows® Assessment Services, the project name already exists. Example: ResultsUtil /ImportResults /inputfile C:\WAS\Results\JobRestulsCompouterGUID.xml /project Project1 |
||
|
/TestPass <test_pass_name> |
Creates a test pass metadata tag or overwrites it if one already exists. The test pass metadata helps you organize results for a specific milestone or test cycle. Example: ResultsUtil /ImportResults /inputfile C:\WAS\Results\JobRestulsCompouterGUID.xml /project Project1 /testpass Milestone1 |
||
|
/RunTag <run_tag_name> |
Creates run tag metadata or overwrites it if it already exists. Run tag metadata helps you identify a specific job run instance when you search for results. Example: ResultsUtil /ImportResults /inputfile C:\WAS\Results\JobRestulsCompouterGUID.xml /project MyProject /testpass Milestone1 /runtag Run1 |
||
|
/Tags <user_defined_tags> |
Creates custom metadata tags or overwrites them if they already exist. These metadata tags are used to help you identify or sort job results when you search. Example: ResultsUtil /ImportResults /inputfile C:\WAS\Results\JobRestulsCompouterGUID.xml /project MyProject /testpass Milestone1 /runtag Run1 /tags M1Results |
||
|
/FileSave |
Saves the database configuration file, resultsutil.exe.config, to the same location as the ResultsUtil. The database configuration file is prepopulated with the database connections string and user name so that you don’t have to enter it every time that you import results.
Example: ResultsUtil /InitializeDatabase /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /user MyName /filesave |
||
|
/WASServer <WAS_server_address> |
Configures the Windows Assessment Services server to move results from the results store to the SQL database after a job is completed. The default format for specifying a server is http://<server_name>:8000/relax/service. Example: ResultsUtil /ConfigureWASserver /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /user MyName /WasServer http://MyServer:8000/relax/service |
||
|
/Quiet |
Suppresses status messages. Example: ResultsUtil /ConfigureWASserver /db “Data Source=localhost\WAS_SQLSERVER;Initial Catalog=WAS;Integrated Security=True” /User MyName /WasServer http://MyServer:8000/relax/service /Quiet |
||
|
/NoSyncResult |
By default some tables are indexed to increase performance. This option will suppress index updates. Example: ResultsUtil /NoSyncResult |
||
|
/ResyncAllResults |
Rebuilds results database indexes. This option is only needed after a call to import results with NoSyncResult. Example: ResultsUtil /ResyncAllResults /Quiet |
Note
