INFO-安全中心常用sql汇总

适用模块

安全中心

具体说明

安全中心常用统计类sql

使用示例

1、敏感类型数量（不包括内置敏感类型）
select count(*) from access_sensitive_type where product != 'all';
2、识别任务
select count(*) from access_identify_task;
3、识别出的字段
select count(*) from access_identify_result;
4、脱敏规则数
 select sum(1) as cnt from access_mask_configuration;
5、配置了脱敏的传输任务数量
SELECT COUNT(DISTINCT task_id) FROM easytransfer.datamask_task;
6、脱敏字段数
 select count(*) from (select * from access_resource_masking where object <> "public" group by resource) t1

 select object,sum(1) as cnt from 
 (select * from access_resource_masking group by resource) t1
 group by object
 order by cnt desc;
7、白名单数
select count(*) from access_resource_masking where object = "public";

作者：林帅