Skip to main content

vw_devices_update_summaries

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

Overview​

Namevw_devices_update_summaries
TypeView
Idazure_extras.storsimple_1200_series.vw_devices_update_summaries

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.deviceVersion') as "device_version",
JSON_EXTRACT(properties, '$.deviceLastScannedTime') as "device_last_scanned_time",
JSON_EXTRACT(properties, '$.regularUpdatesAvailable') as "regular_updates_available",
JSON_EXTRACT(properties, '$.rebootRequiredForInstall') as "reboot_required_for_install",
JSON_EXTRACT(properties, '$.totalItemsPendingForDownload') as "total_items_pending_for_download",
JSON_EXTRACT(properties, '$.totalItemsPendingForInstall') as "total_items_pending_for_install",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.lastCompletedScanTime') as "last_completed_scan_time",
JSON_EXTRACT(properties, '$.lastCompletedDownloadJobTime') as "last_completed_download_job_time",
JSON_EXTRACT(properties, '$.lastCompletedInstallJobTime') as "last_completed_install_job_time",
JSON_EXTRACT(properties, '$.inProgressDownloadJobId') as "in_progress_download_job_id",
JSON_EXTRACT(properties, '$.inProgressInstallJobId') as "in_progress_install_job_id",
JSON_EXTRACT(properties, '$.inProgressScanStartedTime') as "in_progress_scan_started_time",
JSON_EXTRACT(properties, '$.inProgressDownloadJobStartedTime') as "in_progress_download_job_started_time",
JSON_EXTRACT(properties, '$.inProgressInstallJobStartedTime') as "in_progress_install_job_started_time",
subscriptionId,
resourceGroupName,
managerName,
deviceName
FROM azure_extras.storsimple_1200_series.devices_update_summaries
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managerName = 'replace-me' AND deviceName = 'replace-me';