Query: security_center_all_assets_installed_with_agent

select
  'acs:securitycenter:' || region || ':' || account_id || ':asset/' || coalesce(instance_id, uuid) as resource,
  case
    when client_status = 'online' then 'ok'
    else 'alarm'
  end as status,
  case
    when client_status = 'online' then 'Asset ' || uuid || ' has security center agent installed and online.'
    when client_status = 'offline' then 'Asset ' || uuid || ' has security center agent installed but is offline.'
    when client_status = 'uninstall' then 'Asset '|| uuid || ' does not have security center agent installed.'
    when client_status is null then 'Asset ' || uuid || ' security center agent status unknown.'
    else 'Asset ' ||  uuid || ' security center agent status: ' || client_status || '.'
  end as reason
  , account_id as account_id, region as region
from
  alicloud_security_center_asset;