search

turbot / steampipe-plugin-googledirectory

Use SQL to instantly query users, groups, domains and more from Google Directory. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/googledirectory
Apache License 2.0
12 stars 1 forks source link

Add table googledirectory_role_assignment. Closes #7 #12

Closed bigdatasourav closed 3 years ago

bigdatasourav commented 3 years ago

Example query results

Results ``` > select role_assignment_id, role_id, assigned_to, scope_type from googledirectory_role_assignment; +--------------------+-------------------+-----------------------+------------+ | role_assignment_id | role_id | assigned_to | scope_type | +--------------------+-------------------+-----------------------+------------+ | 52236313256001537 | 52236313256001537 | 100347617708023627093 | CUSTOMER | | 52236313256001540 | 52236313256001546 | 116941638922292931139 | CUSTOMER | | 52236313256001538 | 52236313256001537 | 115446550006107555454 | CUSTOMER | | 52236313256001541 | 52236313256001537 | 116941638922292931139 | CUSTOMER | +--------------------+-------------------+-----------------------+------------+ > select role_assignment_id, role_id, assigned_to, scope_type from googledirectory_role_assignment where role_id = '52236313256001537'; +--------------------+-------------------+-----------------------+------------+ | role_assignment_id | role_id | assigned_to | scope_type | +--------------------+-------------------+-----------------------+------------+ | 52236313256001538 | 52236313256001537 | 115446550006107555454 | CUSTOMER | | 52236313256001537 | 52236313256001537 | 100347617708023627093 | CUSTOMER | | 52236313256001541 | 52236313256001537 | 116941638922292931139 | CUSTOMER | +--------------------+-------------------+-----------------------+------------+ > select * from googledirectory_role_assignment where user_key = '115446550006107555454' +--------------------+-------------------+-----------------------+-------------+-----------------------+---------------------------------------------------------------------------+------------------------ | role_assignment_id | role_id | assigned_to | customer_id | user_key | etag | kind +--------------------+-------------------+-----------------------+-------------+-----------------------+---------------------------------------------------------------------------+------------------------ | 52236313256001538 | 52236313256001537 | 115446550006107555454 | | 115446550006107555454 | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/eS-0h_Ik6-qm9poXkeraHJFdP3I" | admin#directory#roleAss +--------------------+-------------------+-----------------------+-------------+-----------------------+---------------------------------------------------------------------------+------------------------ > select * from googledirectory.googledirectory_role_assignment where role_id ='52236313256001537' +--------------------+-------------------+-----------------------+-------------+----------+---------------------------------------------------------------------------+--------------------------------+---- | role_assignment_id | role_id | assigned_to | customer_id | user_key | etag | kind | org +--------------------+-------------------+-----------------------+-------------+----------+---------------------------------------------------------------------------+--------------------------------+---- | 52236313256001537 | 52236313256001537 | 100347617708023627093 | | | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/PMMvoTnRkFzAHRptlDOmEfTqgKA" | admin#directory#roleAssignment | | | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/eS-0h_Ik6-qm9poXkeraHJFdP3I" | admin#directory#roleAssignment | | | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/GTxm1y34UOmGNJGRsQ7nTI8x3TM" | admin#directory#roleAssignment | select * from googledirectory.googledirectory_role_assignment +--------------------+-------------------+-----------------------+-------------+----------+---------------------------------------------------------------------------+--------------------------------+---- | role_assignment_id | role_id | assigned_to | customer_id | user_key | etag | kind | org +--------------------+-------------------+-----------------------+-------------+----------+---------------------------------------------------------------------------+--------------------------------+---- | 52236313256001540 | 52236313256001546 | 116941638922292931139 | | | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/dSi_tD8Wk6kNlnL4LoAdQR_OVrg" | admin#directory#roleAssignment | | | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/GTxm1y34UOmGNJGRsQ7nTI8x3TM" | admin#directory#roleAssignment | | | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/PMMvoTnRkFzAHRptlDOmEfTqgKA" | admin#directory#roleAssignment | | | "jU41SRtWIAfoLzcTxu8ldh8oAWnTyj8bXpPMVPE5dps/eS-0h_Ik6-qm9poXkeraHJFdP3I" | admin#directory#roleAssignment |