Skip to main content

vw_tables

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

Overview​

Namevw_tables
TypeView
Idazure.log_analytics.vw_tables

Fields​

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

SQL Definition​

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.retentionInDays') as "retention_in_days",
JSON_EXTRACT(properties, '$.totalRetentionInDays') as "total_retention_in_days",
JSON_EXTRACT(properties, '$.archiveRetentionInDays') as "archive_retention_in_days",
JSON_EXTRACT(properties, '$.searchResults') as "search_results",
JSON_EXTRACT(properties, '$.restoredLogs') as "restored_logs",
JSON_EXTRACT(properties, '$.resultStatistics') as "result_statistics",
JSON_EXTRACT(properties, '$.plan') as "plan",
JSON_EXTRACT(properties, '$.lastPlanModifiedDate') as "last_plan_modified_date",
JSON_EXTRACT(properties, '$.schema') as "schema",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.retentionInDaysAsDefault') as "retention_in_days_as_default",
JSON_EXTRACT(properties, '$.totalRetentionInDaysAsDefault') as "total_retention_in_days_as_default",
subscriptionId,
resourceGroupName,
workspaceName,
tableName
FROM azure.log_analytics.tables
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';