Table: azure_security_settings

This table shows data for Azure Security Settings.

https://learn.microsoft.com/en-us/rest/api/defenderforcloud/settings/list?tabs=HTTP#settingslist (opens in a new tab)

The primary key for this table is id.

Columns

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

Example Queries

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

Ensure that Microsoft Cloud App Security (MCAS) integration with Security Center is selected (Automatic)

SELECT
  'Ensure that Microsoft Cloud App Security (MCAS) integration with Security Center is selected (Automatic)'
    AS title,
  subscription_id,
  id,
  CASE
  WHEN enabled = true THEN 'pass'
  ELSE 'fail'
  END
FROM
  azure_security_settings AS ass
WHERE
  name = 'MCAS';