test_results

Creates, updates, deletes, gets or lists a test_results resource.

Overview

Name	test_results
Type	Resource
Id	azure_extras.testbase.test_results

Fields

The following fields are returned by SELECT queries:

get_console_log_download_url

Name	Datatype	Description
downloadUrl	string	The download URL.
expirationTime	string (date-time)	Expiry date of the download URL.

get

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
analysisSummaries	array	List of analysis summaries.
applicationName	string	Application name.
applicationVersion	string	Application version.
baselineTestResultId	string	Azure Id of the baseline test result.
buildRevision	string	The build revision of the tested release (OS update).
buildVersion	string	The build version of the tested release (OS update).
executionStatus	string	The execution status of the test. Known values are: "None", "InProgress", "Processing", "Completed", "NotExecuted", "Incomplete", "Failed", and "Succeeded".
flightingRing	string	The flighting ring, only for release of feature updates.
grade	string	The grade of the test. Known values are: "None", "NotAvailable", "Pass", and "Fail".
interopMediaType	string	Interop media type.
interopMediaVersion	string	Interop media version.
isDownloadDataAvailable	boolean	Whether download data is available.
isVideoAvailable	boolean	Whether video data is available.
kbNumber	string	KB number.
osName	string	The operating system name, e.g. Windows 10 1809.
packageId	string	Resource Id of the package.
packageVersion	string	The version of the Windows update package.
releaseName	string	The name of the tested release (OS update).
releaseVersionDate	string (date-time)	The release version date of the tested release.
systemData	object	The system metadata relating to this resource.
testRunTime	string	The run time of the test.
testStatus	string	The status of the test. Known values are: "None", "TestExecutionInProgress", "DataProcessing", "TestFailure", "UpdateFailure", "TestAndUpdateFailure", "InfrastructureFailure", and "Completed".
testType	string	Test type. E.g. 'Out of box test' or 'Functional test'.
type	string	Resource type.

list

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
analysisSummaries	array	List of analysis summaries.
applicationName	string	Application name.
applicationVersion	string	Application version.
baselineTestResultId	string	Azure Id of the baseline test result.
buildRevision	string	The build revision of the tested release (OS update).
buildVersion	string	The build version of the tested release (OS update).
executionStatus	string	The execution status of the test. Known values are: "None", "InProgress", "Processing", "Completed", "NotExecuted", "Incomplete", "Failed", and "Succeeded".
flightingRing	string	The flighting ring, only for release of feature updates.
grade	string	The grade of the test. Known values are: "None", "NotAvailable", "Pass", and "Fail".
interopMediaType	string	Interop media type.
interopMediaVersion	string	Interop media version.
isDownloadDataAvailable	boolean	Whether download data is available.
isVideoAvailable	boolean	Whether video data is available.
kbNumber	string	KB number.
osName	string	The operating system name, e.g. Windows 10 1809.
packageId	string	Resource Id of the package.
packageVersion	string	The version of the Windows update package.
releaseName	string	The name of the tested release (OS update).
releaseVersionDate	string (date-time)	The release version date of the tested release.
systemData	object	The system metadata relating to this resource.
testRunTime	string	The run time of the test.
testStatus	string	The status of the test. Known values are: "None", "TestExecutionInProgress", "DataProcessing", "TestFailure", "UpdateFailure", "TestAndUpdateFailure", "InfrastructureFailure", and "Completed".
testType	string	Test type. E.g. 'Out of box test' or 'Functional test'.
type	string	Resource type.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_console_log_download_url	select	resource_group_name, test_base_account_name, package_name, test_result_name, subscription_id		Gets the download URL of the test execution console log file.
get	select	resource_group_name, test_base_account_name, package_name, test_result_name, subscription_id		Get the Test Result by Id with specified OS Update type for a Test Base Package.
list	select	resource_group_name, test_base_account_name, package_name, subscription_id, osUpdateType	$filter	Lists all the Test Results with specified OS Update type for a Test Base Package. Can be filtered by osName, releaseName, flightingRing, buildVersion, buildRevision.
get_download_url	exec	resource_group_name, test_base_account_name, package_name, test_result_name, subscription_id		Gets the download URL of the test result.
get_video_download_url	exec	resource_group_name, test_base_account_name, package_name, test_result_name, subscription_id		Gets the download URL of the test execution screen recording.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
osUpdateType	string	The type of the OS Update. Known values are: "SecurityUpdate" and "FeatureUpdate". Required.
package_name	string	The resource name of the Test Base Package. Required.
resource_group_name	string	The name of the resource group that contains the resource. Required.
subscription_id	string
test_base_account_name	string	The resource name of the Test Base Account. Required.
test_result_name	string	The Test Result Name. It equals to TestResult-{TestResultId} string. Required.
$filter	string	Odata filter. Default value is None.

SELECT examples

get_console_log_download_url

Gets the download URL of the test execution console log file.

SELECT
downloadUrl,
expirationTime
FROM azure_extras.testbase.test_results
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND test_base_account_name = '{{ test_base_account_name }}' -- required
AND package_name = '{{ package_name }}' -- required
AND test_result_name = '{{ test_result_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

get

Get the Test Result by Id with specified OS Update type for a Test Base Package.

SELECT
id,
name,
analysisSummaries,
applicationName,
applicationVersion,
baselineTestResultId,
buildRevision,
buildVersion,
executionStatus,
flightingRing,
grade,
interopMediaType,
interopMediaVersion,
isDownloadDataAvailable,
isVideoAvailable,
kbNumber,
osName,
packageId,
packageVersion,
releaseName,
releaseVersionDate,
systemData,
testRunTime,
testStatus,
testType,
type
FROM azure_extras.testbase.test_results
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND test_base_account_name = '{{ test_base_account_name }}' -- required
AND package_name = '{{ package_name }}' -- required
AND test_result_name = '{{ test_result_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list

Lists all the Test Results with specified OS Update type for a Test Base Package. Can be filtered by osName, releaseName, flightingRing, buildVersion, buildRevision.

SELECT
id,
name,
analysisSummaries,
applicationName,
applicationVersion,
baselineTestResultId,
buildRevision,
buildVersion,
executionStatus,
flightingRing,
grade,
interopMediaType,
interopMediaVersion,
isDownloadDataAvailable,
isVideoAvailable,
kbNumber,
osName,
packageId,
packageVersion,
releaseName,
releaseVersionDate,
systemData,
testRunTime,
testStatus,
testType,
type
FROM azure_extras.testbase.test_results
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND test_base_account_name = '{{ test_base_account_name }}' -- required
AND package_name = '{{ package_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND osUpdateType = '{{ osUpdateType }}' -- required
AND $filter = '{{ $filter }}'
;

Lifecycle Methods

get_download_url

Gets the download URL of the test result.

EXEC azure_extras.testbase.test_results.get_download_url 
@resource_group_name='{{ resource_group_name }}' --required, 
@test_base_account_name='{{ test_base_account_name }}' --required, 
@package_name='{{ package_name }}' --required, 
@test_result_name='{{ test_result_name }}' --required, 
@subscription_id='{{ subscription_id }}' --required
;

get_video_download_url

Gets the download URL of the test execution screen recording.

EXEC azure_extras.testbase.test_results.get_video_download_url 
@resource_group_name='{{ resource_group_name }}' --required, 
@test_base_account_name='{{ test_base_account_name }}' --required, 
@package_name='{{ package_name }}' --required, 
@test_result_name='{{ test_result_name }}' --required, 
@subscription_id='{{ subscription_id }}' --required
;