vw_power_shell72_modules
Creates, updates, deletes, gets or lists a vw_power_shell72_modules
resource.
Overview
Name | vw_power_shell72_modules |
Type | View |
Id | azure.automation.vw_power_shell72_modules |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
location as location,
etag as etag,
tags as tags,
JSON_EXTRACT(properties, '$.isGlobal') as "is_global",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.sizeInBytes') as "size_in_bytes",
JSON_EXTRACT(properties, '$.activityCount') as "activity_count",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.contentLink') as "content_link",
JSON_EXTRACT(properties, '$.error') as "error",
JSON_EXTRACT(properties, '$.creationTime') as "creation_time",
JSON_EXTRACT(properties, '$.lastModifiedTime') as "last_modified_time",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.isComposite') as "is_composite",
subscriptionId,
resourceGroupName,
automationAccountName,
moduleName
FROM azure.automation.power_shell72_modules
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND automationAccountName = 'replace-me';
SELECT
location as location,
etag as etag,
tags as tags,
json_extract_path_text(properties, '$.isGlobal') as "is_global",
json_extract_path_text(properties, '$.version') as "version",
json_extract_path_text(properties, '$.sizeInBytes') as "size_in_bytes",
json_extract_path_text(properties, '$.activityCount') as "activity_count",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.contentLink') as "content_link",
json_extract_path_text(properties, '$.error') as "error",
json_extract_path_text(properties, '$.creationTime') as "creation_time",
json_extract_path_text(properties, '$.lastModifiedTime') as "last_modified_time",
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.isComposite') as "is_composite",
subscriptionId,
resourceGroupName,
automationAccountName,
moduleName
FROM azure.automation.power_shell72_modules
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND automationAccountName = 'replace-me';