Table: azure_appservice_web_app_auth_settings

This table shows data for Azure App Service Web App Auth Settings.

https://learn.microsoft.com/en-us/rest/api/appservice/web-apps/get-auth-settings#siteauthsettings (opens in a new tab)

The primary key for this table is id.

Relations

This table depends on azure_appservice_web_apps.

Columns

NameType
_cq_iduuid
_cq_parent_iduuid
subscription_idutf8
kindutf8
propertiesjson
id (PK)utf8
nameutf8
typeutf8

Example Queries

These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.

Ensure App Service Authentication is set on Azure App Service (Automated)

SELECT
  'Ensure App Service Authentication is set on Azure App Service (Automated)'
    AS title,
  awa.subscription_id AS subscription_id,
  awa.id AS resource_id,
  CASE
  WHEN (awaas.properties->>'enabled')::BOOL IS NOT true THEN 'fail'
  ELSE 'pass'
  END
    AS status
FROM
  azure_appservice_web_apps AS awa
  LEFT JOIN azure_appservice_web_app_auth_settings AS awaas ON
      awa._cq_id = awaas._cq_parent_id;