Control: SQL servers should use the latest TLS version 1.2

powerpipe control run terraform_azure_compliance.control.sql_server_uses_latest_tls_version

powerpipe login
powerpipe control run terraform_azure_compliance.control.sql_server_uses_latest_tls_version --share

select
  address as resource,
  case
    when (attributes_std ->> 'minimum_tls_version') is null then 'ok'
    when (attributes_std ->> 'minimum_tls_version')::text = '1.2' then 'ok'
    else 'alarm'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'minimum_tls_version') is null then ' TLS version not defined by default uses 1.2'
    when (attributes_std ->> 'minimum_tls_version')::text = '1.2' then ' TLS version 1.2'
    else ' TLS version not 1.2'
  end || '.' reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'azurerm_mssql_server';