devices

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

Overview

Name	devices
Type	Resource
Id	azure_extras.storsimple_1200_series.devices

Fields

vw_devices

Name	Datatype	Description
id	text	The identifier.
name	text	The name.
activation_time	text	field from the properties object
allowed_device_operations	text	field from the properties object
culture	text	field from the properties object
details	text	field from the properties object
deviceName	text	field from the properties object
device_capabilities	text	field from the properties object
device_configuration_status	text	field from the properties object
device_description	text	field from the properties object
device_software_version	text	field from the properties object
domain_name	text	field from the properties object
friendly_software_name	text	field from the properties object
managerName	text	field from the properties object
model_description	text	field from the properties object
resourceGroupName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The type.

devices

Name	Datatype	Description
id	string	The identifier.
name	string	The name.
properties	object	Encases all the properties of the Device
type	string	The type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	deviceName, managerName, resourceGroupName, subscriptionId	Returns the properties of the specified device name.
list_by_manager	SELECT	managerName, resourceGroupName, subscriptionId	Retrieves all the devices in a manager.
delete	DELETE	deviceName, managerName, resourceGroupName, subscriptionId	Deletes the device.
patch	UPDATE	deviceName, managerName, resourceGroupName, subscriptionId	Patches the device.
deactivate	EXEC	deviceName, managerName, resourceGroupName, subscriptionId	Deactivates the device.
download_updates	EXEC	deviceName, managerName, resourceGroupName, subscriptionId	Downloads updates on the device.
failover	EXEC	deviceName, managerName, resourceGroupName, subscriptionId	Fails over the device to another device.
install_updates	EXEC	deviceName, managerName, resourceGroupName, subscriptionId	Installs the updates on the device.
scan_for_updates	EXEC	deviceName, managerName, resourceGroupName, subscriptionId	Scans for updates on the device.

SELECT examples

Retrieves all the devices in a manager.

vw_devices

SELECT
id,
name,
activation_time,
allowed_device_operations,
culture,
details,
deviceName,
device_capabilities,
device_configuration_status,
device_description,
device_software_version,
domain_name,
friendly_software_name,
managerName,
model_description,
resourceGroupName,
status,
subscriptionId,
type
FROM azure_extras.storsimple_1200_series.vw_devices
WHERE managerName = '{{ managerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

devices

SELECT
id,
name,
properties,
type
FROM azure_extras.storsimple_1200_series.devices
WHERE managerName = '{{ managerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a devices resource.

/*+ update */
UPDATE azure_extras.storsimple_1200_series.devices
SET 
deviceDescription = '{{ deviceDescription }}'
WHERE 
deviceName = '{{ deviceName }}'
AND managerName = '{{ managerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified devices resource.

/*+ delete */
DELETE FROM azure_extras.storsimple_1200_series.devices
WHERE deviceName = '{{ deviceName }}'
AND managerName = '{{ managerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';