Skip to main content

workspaces

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

Overview

Nameworkspaces
TypeResource
Idazure_extras.iot_firmware_defense.workspaces

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringProvisioning state of the resource. Known values are: "Succeeded", "Failed", "Canceled", "Pending", "Extracting", and "Analyzing". (Succeeded, Failed, Canceled, Pending, Extracting, Analyzing)
skuobjectThe SKU (Stock Keeping Unit) assigned to this resource.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, workspace_name, subscription_idGet firmware analysis workspace.
list_by_resource_groupselectresource_group_name, subscription_idLists all of the firmware analysis workspaces in the specified resource group.
list_by_subscriptionselectsubscription_idLists all of the firmware analysis workspaces in the specified subscription.
createinsertresource_group_name, workspace_name, subscription_id, locationThe operation to create or update a firmware analysis workspace.
updateupdateresource_group_name, workspace_name, subscription_idThe operation to update a firmware analysis workspaces.
deletedeleteresource_group_name, workspace_name, subscription_idThe operation to delete a firmware analysis workspace.
generate_upload_urlexecresource_group_name, workspace_name, subscription_idGenerate a URL for uploading a firmware image.

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.

NameDatatypeDescription
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
workspace_namestringThe name of the firmware analysis workspace. Required.

SELECT examples

Get firmware analysis workspace.

SELECT
id,
name,
location,
provisioningState,
sku,
systemData,
tags,
type
FROM azure_extras.iot_firmware_defense.workspaces
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

The operation to create or update a firmware analysis workspace.

INSERT INTO azure_extras.iot_firmware_defense.workspaces (
tags,
location,
properties,
sku,
resource_group_name,
workspace_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ sku }}',
'{{ resource_group_name }}',
'{{ workspace_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type
;

UPDATE examples

The operation to update a firmware analysis workspaces.

UPDATE azure_extras.iot_firmware_defense.workspaces
SET
sku = '{{ sku }}',
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
sku,
systemData,
tags,
type;

DELETE examples

The operation to delete a firmware analysis workspace.

DELETE FROM azure_extras.iot_firmware_defense.workspaces
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Generate a URL for uploading a firmware image.

EXEC azure_extras.iot_firmware_defense.workspaces.generate_upload_url 
@resource_group_name='{{ resource_group_name }}' --required,
@workspace_name='{{ workspace_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
@@json=
'{
"firmwareId": "{{ firmwareId }}"
}'
;