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
11 stars 1 forks source link

Add table googledirectory_domain_alias. Closes #8 #11

Closed bigdatasourav closed 2 years ago

bigdatasourav commented 2 years ago

Example query results

Results ``` > select * from googledirectory_domain_alias where domain_alias_name = 'turbot-dev.com.test-google-a.com' +----------------------------------+---------------------+----------+-------------+---------------------------------------------------------------------------+-----------------------------+--------------- | domain_alias_name | creation_time | verified | customer_id | etag | kind | parent_domain_ +----------------------------------+---------------------+----------+-------------+---------------------------------------------------------------------------+-----------------------------+--------------- | turbot-dev.com.test-google-a.com | 2021-07-06 21:15:36 | true | | "xleqcsVBDtt63aQahfMIqXdQqgrChHYB52dVIG_3_14/cMhgpt9sMgIdptf7osVqVEa3nD0" | admin#directory#domainAlias | turbot-dev.com +----------------------------------+---------------------+----------+-------------+---------------------------------------------------------------------------+-----------------------------+--------------- > select domain_alias_name, creation_time, verified from googledirectory_domain_alias; +----------------------------------+---------------------+----------+ | domain_alias_name | creation_time | verified | +----------------------------------+---------------------+----------+ | turbot-dev.com.test-google-a.com | 2021-07-06 21:15:36 | true | +----------------------------------+---------------------+----------+ > select domain_alias_name, creation_time, verified from googledirectory_domain_alias where not verified; +-------------------+---------------+----------+ | domain_alias_name | creation_time | verified | +-------------------+---------------+----------+ +-------------------+---------------+----------+ ```