OCI Block Storage Block Volume Age ReportOCI Block Storage Block Volume DashboardOCI Block Storage Block Volume DetailOCI Block Storage Block Volume Encryption ReportOCI Block Storage Block Volume Unattached ReportOCI Block Storage Boot Volume Age ReportOCI Block Storage Boot Volume DashboardOCI Block Storage Boot Volume DetailOCI Block Storage Boot Volume Encryption ReportOCI Block Storage Boot Volume Unattached ReportOCI Compartment ReportOCI Compute Instance Age ReportOCI Compute Instance DashboardOCI Compute Instance DetailOCI Database Autonomous DB Age ReportOCI Database Autonomous DB DashboardOCI Database Autonomous DB DetailOCI File Storage File System Age ReportOCI File Storage File System DashboardOCI File Storage File System DetailOCI Identity API Key Age ReportOCI Identity Customer Secret Key Age ReportOCI Identity Group DashboardOCI Identity Group DetailOCI Identity User DashboardOCI Identity User DetailOCI Identity User MFA ReportOCI KMS Key Age ReportOCI KMS Key DashboardOCI KMS Key DetailOCI KMS Vault Age ReportOCI KMS Vault DashboardOCI KMS Vault DetailOCI MySQL Backup Age ReportOCI MySQL Backup DashboardOCI MySQL DB System Age ReportOCI MySQL DB System DashboardOCI MySQL DB System DetailOCI NoSQL Table Age ReportOCI NoSQL Table DashboardOCI NoSQL Table DetailOCI Object Storage Bucket Age ReportOCI Object Storage Bucket DashboardOCI Object Storage Bucket DetailOCI Object Storage Bucket Encryption ReportOCI Object Storage Bucket Lifecycle ReportOCI Object Storage Bucket Logging ReportOCI Object Storage Bucket Public Access ReportOCI ONS Notification Topic Age ReportOCI ONS Notification Topic DashboardOCI ONS Notification Topic DetailOCI ONS Subscription Age ReportOCI ONS Subscription DashboardOCI Tenancy ReportOCI VCN DashboardOCI VCN DetailOCI VCN Network Security Group DashboardOCI VCN Network Security Group DetailOCI VCN Network Security List DashboardOCI VCN Security List DetailOCI VCN Subnet DashboardOCI VCN Subnet DetailOCI VCN Subnet Flow Logs Report
Dashboard: OCI Identity User Dashboard
This dashboard answers the following questions:
- How many users are in each tenancy and group?
- How many users are not attached to a group?
- How many users have MFA disabled?
- How many users have pending email address verification?
This dashboard contains 3 cards.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-oci-insightsStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select OCI Identity User Dashboard dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run oci_insights.dashboard.identity_user_dashboard --shareQueries
This dashboard uses the the following queries:
with users_and_grp as ( select oci_identity_user.name as user_name, oci_identity_group.name as group_name, user_group ->> 'groupId' as group_id from oci_identity_user, jsonb_array_elements(user_groups) as user_group inner join oci_identity_group ON (oci_identity_group.id = user_group ->> 'groupId' ))select group_name as "Group Name", count(user_name) as "Users"from users_and_grpgroup by group_nameorder by group_name;