Skip to main content

vw_product_templates

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

Overview​

Namevw_product_templates
TypeView
Idazure.sentinel.vw_product_templates

Fields​

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

SQL Definition​

SELECT
etag as etag,
JSON_EXTRACT(properties, '$.contentId') as "content_id",
JSON_EXTRACT(properties, '$.contentProductId') as "content_product_id",
JSON_EXTRACT(properties, '$.packageVersion') as "package_version",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.contentKind') as "content_kind",
JSON_EXTRACT(properties, '$.source') as "source",
JSON_EXTRACT(properties, '$.author') as "author",
JSON_EXTRACT(properties, '$.support') as "support",
JSON_EXTRACT(properties, '$.dependencies') as "dependencies",
JSON_EXTRACT(properties, '$.categories') as "categories",
JSON_EXTRACT(properties, '$.providers') as "providers",
JSON_EXTRACT(properties, '$.firstPublishDate') as "first_publish_date",
JSON_EXTRACT(properties, '$.lastPublishDate') as "last_publish_date",
JSON_EXTRACT(properties, '$.customVersion') as "custom_version",
JSON_EXTRACT(properties, '$.contentSchemaVersion') as "content_schema_version",
JSON_EXTRACT(properties, '$.icon') as "icon",
JSON_EXTRACT(properties, '$.threatAnalysisTactics') as "threat_analysis_tactics",
JSON_EXTRACT(properties, '$.threatAnalysisTechniques') as "threat_analysis_techniques",
JSON_EXTRACT(properties, '$.previewImages') as "preview_images",
JSON_EXTRACT(properties, '$.previewImagesDark') as "preview_images_dark",
JSON_EXTRACT(properties, '$.packageId') as "package_id",
JSON_EXTRACT(properties, '$.packageKind') as "package_kind",
JSON_EXTRACT(properties, '$.packageName') as "package_name",
JSON_EXTRACT(properties, '$.isDeprecated') as "is_deprecated",
JSON_EXTRACT(properties, '$.packagedContent') as "packaged_content",
subscriptionId,
resourceGroupName,
workspaceName,
templateId
FROM azure.sentinel.product_templates
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';