document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. ubuntu@FAKELES-7310:~$ steampipe query
  2. Welcome to Steampipe v0.20.12
  3. For more information, type .help
  4. > select u.name as user_name, u.lifecycle_state,
  5. g.name as group_name,
  6. ug ->> \'groupId\' as group_id
  7. from  oci_identity_user u,
  8.       jsonb_array_elements(user_groups) as ug
  9. inner join oci_identity_group g ON (g.id = ug ->> \'groupId\')
  10. where g.name = \'Administrators\';
  11.  
  12. +-----------------------------+-----------------+------------------------+
  13. | user_name  | lifecycle_state | group_name     | group_id               |
  14. +-----------------------------+-----------------+------------------------+
  15. | User 1     | ACTIVE          | Administrators | ocid1.group.oc1....... |
  16. | User 2     | ACTIVE          | Administrators | ocid1.group.oc1....... |
  17. | User 3     | ACTIVE          | Administrators | ocid1.group.oc1....... |
  18. | User 4     | ACTIVE          | Administrators | ocid1.group.oc1....... |
  19. | User 5     | ACTIVE          | Administrators | ocid1.group.oc1....... |
  20. | User 6     | ACTIVE          | Administrators | ocid1.group.oc1....... |
  21. +-----------------------------+-----------------+------------------------+
  22.  
');