turbot / steampipe-plugin-okta

Use SQL to instantly query users, groups, applications and more from Okta. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/okta
Apache License 2.0
8 stars 4 forks source link

Update steampipe plugin sdk version. Closes #54 #55

Closed c0d3r-arnab closed 2 years ago

c0d3r-arnab commented 2 years ago

Example query results

Results ``` > select grp.name as name, grp.description as description, jsonb_pretty(grp.group_members) as group_members from okta_group grp full outer join okta_app_assigned_group ag on grp.id = ag.id where grp.id is null or ag.id is null; +---------------+--------------------------------+----------------------------------------+ | name | description | group_members | +---------------+--------------------------------+----------------------------------------+ | Everyone | All users in your organization | [ | | | | { | | | | "id": "00u1kcigdvWtR96HY5d7", | | | | "email": "arnab@turbot.com", | | | | "login": "arnab@turbot.com" | | | | }, | | | | { | | | | "id": "00u33m8oarePFyaTm5d7", | | | | "email": "arnabg57@gmail.com", | | | | "login": "arnabg57@gmail.com" | | | | }, | | | | { | | | | "id": "00u3e9oo5e7hR6X815d7", | | | | "email": "testUser@gmail.com", | | | | "login": "testUser@gmail.com" | | | | } | | | | ] | | Another Group | This is another group | [ | | | | { | | | | "id": "00u33m8oarePFyaTm5d7", | | | | "email": "arnabg57@gmail.com", | | | | "login": "arnabg57@gmail.com" | | | | } | | | | ] | +---------------+--------------------------------+----------------------------------------+ ```