AWS, Azure, GCP 및 각종 SaaS, Identity, DevOps, 네트워크(CDN, IMAP, WHOIS,..), IaC, Log, Social,..
SQL 방식으로 다양한 데이터 소스를 조인하여 이용 가능
슬랙 사용자 중 MFA가 활성화 된 사용자는? select id, display_name, real_name, has_2fa from slack_user;
사용하지 않는 EBS 볼륨은 ? select volume_id, volume_type from aws_ebs_volume where attachments is null;
select aws.name aws_user_name, slack.id as slack_user_id, slack.display_name as slack_name from aws_iam_user as aws, slack_user as slack where aws.name = slack.email;