vw_hcrp_reports
Creates, updates, deletes, gets or lists a vw_hcrp_reports resource.
Overview
| Name | vw_hcrp_reports |
| Type | View |
| Id | azure.automanage.vw_hcrp_reports |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.endTime') as "end_time",
JSON_EXTRACT(properties, '$.lastModifiedTime') as "last_modified_time",
JSON_EXTRACT(properties, '$.duration') as "duration",
JSON_EXTRACT(properties, '$.type') as "type",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.configurationProfile') as "configuration_profile",
JSON_EXTRACT(properties, '$.resources') as "resources",
JSON_EXTRACT(properties, '$.error') as "error",
JSON_EXTRACT(properties, '$.reportFormatVersion') as "report_format_version",
subscriptionId,
resourceGroupName,
machineName,
configurationProfileAssignmentName,
reportName
FROM azure.automanage.hcrp_reports
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND machineName = 'replace-me' AND configurationProfileAssignmentName = 'replace-me';
SELECT
systemData as system_data,
json_extract_path_text(properties, '$.startTime') as "start_time",
json_extract_path_text(properties, '$.endTime') as "end_time",
json_extract_path_text(properties, '$.lastModifiedTime') as "last_modified_time",
json_extract_path_text(properties, '$.duration') as "duration",
json_extract_path_text(properties, '$.type') as "type",
json_extract_path_text(properties, '$.status') as "status",
json_extract_path_text(properties, '$.configurationProfile') as "configuration_profile",
json_extract_path_text(properties, '$.resources') as "resources",
json_extract_path_text(properties, '$.error') as "error",
json_extract_path_text(properties, '$.reportFormatVersion') as "report_format_version",
subscriptionId,
resourceGroupName,
machineName,
configurationProfileAssignmentName,
reportName
FROM azure.automanage.hcrp_reports
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND machineName = 'replace-me' AND configurationProfileAssignmentName = 'replace-me';