gcp_bigquery_dataset ==================== > select * from gcp_bigquery_dataset limit 1 +------+------------+----------------------+------------------+---------------------------+-------------+--------------------------+---------------------------------+-----------------------------+-------- | name | dataset_id | id | kind | creation_time | description | etag | default_partition_expiration_ms | default_table_expiration_ms | kms_key +------+------------+----------------------+------------------+---------------------------+-------------+--------------------------+---------------------------------+-----------------------------+-------- | | dataset_1 | parker-aaa:dataset_1 | bigquery#dataset | 2021-05-07T12:06:47+05:30 | | wFQUTl2M48jSsO2QkOz6UQ== | 0 | 0 | +------+------------+----------------------+------------------+---------------------------+-------------+--------------------------+---------------------------------+-----------------------------+-------- > select * from gcp_bigquery_dataset +------+-----------------------------------+----------------------------------------------+------------------+---------------------------+-------------+--------------------------+------------------------- | name | dataset_id | id | kind | creation_time | description | etag | default_partition_expira +------+-----------------------------------+----------------------------------------------+------------------+---------------------------+-------------+--------------------------+------------------------- | | dataset_with_all_user | parker-aaa:dataset_with_all_user | bigquery#dataset | 2021-05-07T12:06:21+05:30 | | uK8erGPHdGzSKqtZbQXRtw== | 0 | | dataset_1 | parker-aaa:dataset_1 | bigquery#dataset | 2021-05-07T12:06:47+05:30 | | wFQUTl2M48jSsO2QkOz6UQ== | 0 | | dataset_with_allAuthenticatedUser | parker-aaa:dataset_with_allAuthenticatedUser | bigquery#dataset | 2021-05-07T12:06:07+05:30 | | 4Q7mLcF2PjwO+UQFID2qLg== | 0 +------+-----------------------------------+----------------------------------------------+------------------+---------------------------+-------------+--------------------------+------------------------- ================================================================================ gcp_bigquery_job ==================== > select * from gcp_bigquery_job +--------------------------------------------+------------------------------+-------+---------------------------------------------------------------------------------------------------------------+------- | id | job_id | state | self_link | comple +--------------------------------------------+------------------------------+-------+---------------------------------------------------------------------------------------------------------------+------- | parker-aaa:US.turbottest43006 | turbottest43006 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest43006?location=US | 0 | parker-aaa:US.turbottest49130 | turbottest49130 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest49130?location=US | 0 | parker-aaa:US.turbottest65442 | turbottest65442 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest65442?location=US | 0 | parker-aaa:US.turbottest16363 | turbottest16363 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest16363?location=US | 0 | parker-aaa:US.turbottest72720 | turbottest72720 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest72720?location=US | 0 | parker-aaa:US.turbottest21495 | turbottest21495 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest21495?location=US | 0 | parker-aaa:US.turbottest74680 | turbottest74680 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest74680?location=US | 0 | parker-aaa:US.turbottest3032 | turbottest3032 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest3032?location=US | 0 | parker-aaa:US.turbottest67577 | turbottest67577 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest67577?location=US | 0 | parker-aaa:US.turbottest3114 | turbottest3114 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest3114?location=US | 0 | parker-aaa:US.turbottest880 | turbottest880 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest880?location=US | 0 | parker-aaa:US.turbottest54230 | turbottest54230 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest54230?location=US | 0 | parker-aaa:US.turbottest19581 | turbottest19581 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest19581?location=US | 0 | parker-aaa:US.turbottest18081 | turbottest18081 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest18081?location=US | 0 | parker-aaa:US.turbottest19941 | turbottest19941 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest19941?location=US | 0 | parker-aaa:US.turbottest33737 | turbottest33737 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest33737?location=US | 0 | parker-aaa:US.bquxjob_5f50acbc_17e2b41e52f | bquxjob_5f50acbc_17e2b41e52f | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/bquxjob_5f50acbc_17e2b41e52f?location=US | 0 +--------------------------------------------+------------------------------+-------+---------------------------------------------------------------------------------------------------------------+------- > select * from gcp_bigquery_job limit 1 +-------------------------------+-----------------+-------+--------------------------------------------------------------------------------------------------+------------------+--------------------------- | id | job_id | state | self_link | completion_ratio | creation_time +-------------------------------+-----------------+-------+--------------------------------------------------------------------------------------------------+------------------+--------------------------- | parker-aaa:US.turbottest65442 | turbottest65442 | DONE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-aaa/jobs/turbottest65442?location=US | 0 | 2022-01-11T15:28:49+05:30 +-------------------------------+-----------------+-------+--------------------------------------------------------------------------------------------------+------------------+--------------------------- ================================================================================ gcp_bigquery_table ==================== > select * from gcp_bigquery_table +------+----------------------------------------------------------------+------------+-------------------------------------------------------------------------------------+-------+------------------------ | name | table_id | dataset_id | id | type | self_link +------+----------------------------------------------------------------+------------+-------------------------------------------------------------------------------------+-------+------------------------ | | logging_googleapis_com_sink_error_20210508 | dataset_1 | parker-aaa:dataset_1.logging_googleapis_com_sink_error_20210508 | TABLE | https://bigquery.google | | | | | | | | | | | | | | cloudaudit_googleapis_com_data_access_20210507 | dataset_1 | parker-aaa:dataset_1.cloudaudit_googleapis_com_data_access_20210507 | TABLE | https://bigquery.google | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | cloudaudit_googleapis_com_data_access_20210510 | dataset_1 | parker-aaa:dataset_1.cloudaudit_googleapis_com_data_access_20210510 | TABLE | https://bigquery.google | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | compute_googleapis_com_shielded_vm_integrity_20210507 | dataset_1 | parker-aaa:dataset_1.compute_googleapis_com_shielded_vm_integrity_20210507 | TABLE | https://bigquery.google | | | | | | | | | | | | | | monitoring_googleapis_com_ViolationOpenEventv1_20210507 | dataset_1 | parker-aaa:dataset_1.monitoring_googleapis_com_ViolationOpenEventv1_20210507 | TABLE | https://bigquery.google | | | | | | | | | | | | | | logging_googleapis_com_sink_error_20210507 | dataset_1 | parker-aaa:dataset_1.logging_googleapis_com_sink_error_20210507 | TABLE | https://bigquery.google | | | | | | | | | | | | | | cloudaudit_googleapis_com_data_access_20210508 | dataset_1 | parker-aaa:dataset_1.cloudaudit_googleapis_com_data_access_20210508 | TABLE | https://bigquery.google | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | cloudaudit_googleapis_com_activity_20210508 | dataset_1 | parker-aaa:dataset_1.cloudaudit_googleapis_com_activity_20210508 | TABLE | https://bigquery.google | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > select * from gcp_bigquery_table limit 1 +------+---------------------------------------------+------------+------------------------------------------------------------------+-------+-------------------------------------------------------------- | name | table_id | dataset_id | id | type | self_link +------+---------------------------------------------+------------+------------------------------------------------------------------+-------+-------------------------------------------------------------- | | cloudaudit_googleapis_com_activity_20210507 | dataset_1 | parker-aaa:dataset_1.cloudaudit_googleapis_com_activity_20210507 | TABLE | https://bigquery.googleapis.com/bigquery/v2/projects/parker-a | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | +------+---------------------------------------------+------------+------------------------------------------------------------------+-------+-------------------------------------------------------------- ================================================================================ gcp_cloudfunctions_function ==================== > select * from gcp_cloudfunctions_function +-----------+--------------------+--------------------------------------------------------------------------------------------------------+-------------+----------+---------------------+------------------ | name | status | self_link | description | runtime | available_memory_mb | build_environment +-----------+--------------------+--------------------------------------------------------------------------------------------------------+-------------+----------+---------------------+------------------ | test-func | DEPLOY_IN_PROGRESS | https://cloudfunctions.googleapis.com/v1/projects/parker-aaa/locations/us-central1/functions/test-func | | nodejs16 | 256 | +-----------+--------------------+--------------------------------------------------------------------------------------------------------+-------------+----------+---------------------+------------------ > select * from gcp_cloudfunctions_function limit 1 +-----------+--------------------+--------------------------------------------------------------------------------------------------------+-------------+----------+---------------------+------------------ | name | status | self_link | description | runtime | available_memory_mb | build_environment +-----------+--------------------+--------------------------------------------------------------------------------------------------------+-------------+----------+---------------------+------------------ | test-func | DEPLOY_IN_PROGRESS | https://cloudfunctions.googleapis.com/v1/projects/parker-aaa/locations/us-central1/functions/test-func | | nodejs16 | 256 | +-----------+--------------------+--------------------------------------------------------------------------------------------------------+-------------+----------+---------------------+------------------ ================================================================================ gcp_compute_address ==================== > select * from gcp_compute_address +---------------------------------+---------------------+-------------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------- | name | id | address | address_type | ip_version | description | creation_timestamp | kind | network +---------------------------------+---------------------+-------------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------- | test | 5374255085610970082 | 10.1.0.0 | INTERNAL | | | 2021-04-21T17:35:33+05:30 | compute#address | https://www.googleapis.com/compute/v1/projec | dns-forwarding-2f19e4fe7761c5e6 | 6081729468769760411 | 10.182.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-c56850daaaf028ed | 9137169319108277403 | 10.178.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-53ce0f632c557968 | 8155781962125800604 | 10.166.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | dns-forwarding-662bbc587c38835e | 766414437300827292 | 10.152.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | dns-forwarding-73d546f6f6cddc3c | 2282904747420415131 | 10.162.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-6b56e3a93dd6be33 | 1363052971730662555 | 10.148.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-6623ad8fdf51a8de | 625153989432571035 | 10.132.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-1a2205eaa5041dba | 6706343861092611227 | 10.158.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-ef957976ad8e393b | 2822582927354492059 | 10.180.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-1bdea4af8e14e56d | 4220950040422380700 | 10.128.0.56 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-88c8fa50e3a9b8b6 | 4742784825969865883 | 10.138.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | arnab-ip-add | 4486819618559128755 | 34.66.84.84 | EXTERNAL | | | 2022-01-05T22:12:04+05:30 | compute#address | | dns-forwarding-a38a74aeeb98939c | 1012533380669764763 | 10.184.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-fe8b365c775a6bb9 | 50766933240146041 | 10.192.0.2 | INTERNAL | | | 2021-05-28T17:10:06+05:30 | compute#address | | dns-forwarding-7682e04ab290ef98 | 4121613494179853467 | 10.142.0.4 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-d1ad3b7746d10908 | 2574189794507355292 | 10.172.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | dns-forwarding-edfb39a7f8775092 | 7690500058936767643 | 10.156.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-5b0e2bf970f153f8 | 6649513528141804699 | 10.164.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-83a5ed40d7131102 | 1565355955833054967 | 10.188.0.2 | INTERNAL | | | 2021-06-25T05:11:12+05:30 | compute#address | | dns-forwarding-76c0edf38c0c1e9a | 4432722065900696731 | 10.186.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-aff149e9a55b1082 | 6928537336951351468 | 10.190.0.2 | INTERNAL | | | 2021-05-23T05:09:47+05:30 | compute#address | | dns-forwarding-fe2d052b768e3c39 | 2730274463731676315 | 10.140.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-b8c0aafad1e50a91 | 4843834432803304604 | 10.160.0.6 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | dns-forwarding-31ab0bb325afc123 | 499014884462949531 | 10.150.0.4 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-eb519b11aa2b4601 | 2350582776221175395 | 10.194.0.2 | INTERNAL | | | 2021-10-30T17:16:20+05:30 | compute#address | | dns-forwarding-8996c6467b346520 | 6914869977921877147 | 10.174.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-70f23323379c93f7 | 499259061943661724 | 10.170.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | dns-forwarding-69f48034baf40684 | 4778075313815680155 | 10.168.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | dns-forwarding-caa497179bd84573 | 7649209712231838876 | 10.146.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | dns-forwarding-4a4ab7a1a09be15e | 3767703125223011483 | 10.154.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | +---------------------------------+---------------------+-------------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------- > select * from gcp_compute_address limit 1 +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | name | id | address | address_type | ip_version | description | creation_timestamp | kind | network +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | test | 5374255085610970082 | 10.1.0.0 | INTERNAL | | | 2021-04-21T17:35:33+05:30 | compute#address | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/networks/ +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- > select * from gcp_compute_address where address_type = 'INTERNAL' and network_tier = 'PREMIUM' and status = 'RESERVED' and purpose = 'DNS_RESOLVER' +---------------------------------+---------------------+-------------+--------------+------------+-------------+---------------------------+-----------------+---------+--------------+---------------+---- | name | id | address | address_type | ip_version | description | creation_timestamp | kind | network | network_tier | prefix_length | pur +---------------------------------+---------------------+-------------+--------------+------------+-------------+---------------------------+-----------------+---------+--------------+---------------+---- | dns-forwarding-662bbc587c38835e | 766414437300827292 | 10.152.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-31ab0bb325afc123 | 499014884462949531 | 10.150.0.4 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-6b56e3a93dd6be33 | 1363052971730662555 | 10.148.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-fe8b365c775a6bb9 | 50766933240146041 | 10.192.0.2 | INTERNAL | | | 2021-05-28T17:10:06+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-73d546f6f6cddc3c | 2282904747420415131 | 10.162.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-fe2d052b768e3c39 | 2730274463731676315 | 10.140.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-76c0edf38c0c1e9a | 4432722065900696731 | 10.186.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-69f48034baf40684 | 4778075313815680155 | 10.168.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-1bdea4af8e14e56d | 4220950040422380700 | 10.128.0.56 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-eb519b11aa2b4601 | 2350582776221175395 | 10.194.0.2 | INTERNAL | | | 2021-10-30T17:16:20+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-4a4ab7a1a09be15e | 3767703125223011483 | 10.154.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-1a2205eaa5041dba | 6706343861092611227 | 10.158.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-5b0e2bf970f153f8 | 6649513528141804699 | 10.164.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-6623ad8fdf51a8de | 625153989432571035 | 10.132.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-7682e04ab290ef98 | 4121613494179853467 | 10.142.0.4 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-aff149e9a55b1082 | 6928537336951351468 | 10.190.0.2 | INTERNAL | | | 2021-05-23T05:09:47+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-c56850daaaf028ed | 9137169319108277403 | 10.178.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-d1ad3b7746d10908 | 2574189794507355292 | 10.172.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-ef957976ad8e393b | 2822582927354492059 | 10.180.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-caa497179bd84573 | 7649209712231838876 | 10.146.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-2f19e4fe7761c5e6 | 6081729468769760411 | 10.182.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-b8c0aafad1e50a91 | 4843834432803304604 | 10.160.0.6 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-53ce0f632c557968 | 8155781962125800604 | 10.166.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-70f23323379c93f7 | 499259061943661724 | 10.170.0.3 | INTERNAL | | | 2021-05-20T17:09:31+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-a38a74aeeb98939c | 1012533380669764763 | 10.184.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-8996c6467b346520 | 6914869977921877147 | 10.174.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-88c8fa50e3a9b8b6 | 4742784825969865883 | 10.138.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-83a5ed40d7131102 | 1565355955833054967 | 10.188.0.2 | INTERNAL | | | 2021-06-25T05:11:12+05:30 | compute#address | | PREMIUM | 0 | DNS | dns-forwarding-edfb39a7f8775092 | 7690500058936767643 | 10.156.0.3 | INTERNAL | | | 2021-05-20T17:09:32+05:30 | compute#address | | PREMIUM | 0 | DNS +---------------------------------+---------------------+-------------+--------------+------------+-------------+---------------------------+-----------------+---------+--------------+---------------+---- ================================================================================ gcp_compute_backend_bucket ========================== > select * from gcp_compute_backend_bucket +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- | name | id | description | kind | enable_cdn | bucket_name | creation_timestamp | signed_url_cache_max_age_se +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- | turbottest58114 | 2934636227538773909 | Test backend bucket to validate integration test. | compute#backendBucket | true | turbottest58114 | 2022-01-11T15:48:34+05:30 | 0 +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- > select * from gcp_compute_backend_bucket limit 1 +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- | name | id | description | kind | enable_cdn | bucket_name | creation_timestamp | signed_url_cache_max_age_se +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- | turbottest58114 | 2934636227538773909 | Test backend bucket to validate integration test. | compute#backendBucket | true | turbottest58114 | 2022-01-11T15:48:34+05:30 | 0 +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- > select * from gcp_compute_backend_bucket where bucket_name = 'turbottest58114' and enable_cdn +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- | name | id | description | kind | enable_cdn | bucket_name | creation_timestamp | signed_url_cache_max_age_se +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- | turbottest58114 | 2934636227538773909 | Test backend bucket to validate integration test. | compute#backendBucket | true | turbottest58114 | 2022-01-11T15:48:34+05:30 | 0 +-----------------+---------------------+---------------------------------------------------+-----------------------+------------+-----------------+---------------------------+---------------------------- ================================================================================ gcp_compute_backend_service =========================== > select * from gcp_compute_backend_service where load_balancing_scheme = 'EXTERNAL' and port_name = 'http' and session_affinity = 'NONE' and enable_cdn +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- | name | id | enable_cdn | load_balancing_scheme | description | kind | creation_timestamp | affinity_cookie_ttl_sec | co +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- | turbottest27543 | 2473873248420422815 | true | EXTERNAL | Test Backend Service to verify the table. | compute#backendService | 2022-01-11T15:52:40+05:30 | 0 | 30 +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- > select * from gcp_compute_backend_service limit 1 +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- | name | id | enable_cdn | load_balancing_scheme | description | kind | creation_timestamp | affinity_cookie_ttl_sec | co +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- | turbottest27543 | 2473873248420422815 | true | EXTERNAL | Test Backend Service to verify the table. | compute#backendService | 2022-01-11T15:52:40+05:30 | 0 | 30 +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- > select * from gcp_compute_backend_service +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- | name | id | enable_cdn | load_balancing_scheme | description | kind | creation_timestamp | affinity_cookie_ttl_sec | co +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- | turbottest27543 | 2473873248420422815 | true | EXTERNAL | Test Backend Service to verify the table. | compute#backendService | 2022-01-11T15:52:40+05:30 | 0 | 30 +-----------------+---------------------+------------+-----------------------+-------------------------------------------+------------------------+---------------------------+-------------------------+--- ================================================================================ gcp_compute_disk ==================== > select * from gcp_compute_disk +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- | name | id | creation_timestamp | size_gb | status | description | disk_encryption_key | disk_encryption_key_type | kind | last_attach_ +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- | gke-cluster-1-default-pool-c13bbd6f-hkqn | 9167173067308382592 | 2022-01-10T15:46:16+05:30 | 100 | READY | | | Google managed | compute#disk | 2022-01-10T1 +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- > select * from gcp_compute_disk limit 1 +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- | name | id | creation_timestamp | size_gb | status | description | disk_encryption_key | disk_encryption_key_type | kind | last_attach_ +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- | gke-cluster-1-default-pool-c13bbd6f-hkqn | 9167173067308382592 | 2022-01-10T15:46:16+05:30 | 100 | READY | | | Google managed | compute#disk | 2022-01-10T1 +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- > select * from gcp_compute_disk where status = 'READY' +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- | name | id | creation_timestamp | size_gb | status | description | disk_encryption_key | disk_encryption_key_type | kind | last_attach_ +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- | gke-cluster-1-default-pool-c13bbd6f-hkqn | 9167173067308382592 | 2022-01-10T15:46:16+05:30 | 100 | READY | | | Google managed | compute#disk | 2022-01-10T1 +------------------------------------------+---------------------+---------------------------+---------+--------+-------------+---------------------+--------------------------+--------------+------------- ================================================================================ gcp_compute_firewall ==================== > select * from gcp_compute_firewall +----------------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+------------- | name | id | direction | kind | disabled | description | creation_timestamp | action | log_config_e +----------------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+------------- | gke-cluster-1-301c3f75-all | 5657049772648937911 | INGRESS | compute#firewall | false | | 2022-01-10T15:45:52+05:30 | Allow | false | firewall-rule-cis-test | 3959331741200902777 | INGRESS | compute#firewall | false | Used for testing cis 36 onwards | 2021-05-10T12:07:10+05:30 | Allow | false | gke-cluster-1-301c3f75-vms | 5104577529385171382 | INGRESS | compute#firewall | false | | 2022-01-10T15:45:53+05:30 | Allow | false | turbottest4251-allow-http | 1815898569483573954 | INGRESS | compute#firewall | false | | 2021-05-10T13:13:41+05:30 | Allow | false | allow-iap-traffic | 8165390637190852387 | INGRESS | compute#firewall | false | This is a test firewall rule to validate CIS Section 3.10 | 2021-05-17T12:18:44+05:30 | Allow | false | gke-cluster-1-301c3f75-ssh | 4647282366991153590 | INGRESS | compute#firewall | false | | 2022-01-10T15:45:53+05:30 | Allow | false | turbottest4251-allow-https | 1390251844272741058 | INGRESS | compute#firewall | false | | 2021-05-10T13:13:41+05:30 | Allow | false +----------------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+------------- > select * from gcp_compute_firewall limit 1 +-------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+-------------------+-- | name | id | direction | kind | disabled | description | creation_timestamp | action | log_config_enable | l +-------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+-------------------+-- | allow-iap-traffic | 8165390637190852387 | INGRESS | compute#firewall | false | This is a test firewall rule to validate CIS Section 3.10 | 2021-05-17T12:18:44+05:30 | Allow | false | +-------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+-------------------+-- > select * from gcp_compute_firewall where direction = 'INGRESS' and disabled +------+----+-----------+------+----------+-------------+--------------------+--------+-------------------+---------------------+---------+----------+-----------+---------+--------+--------------------+-- | name | id | direction | kind | disabled | description | creation_timestamp | action | log_config_enable | log_config_metadata | network | priority | self_link | allowed | denied | destination_ranges | s +------+----+-----------+------+----------+-------------+--------------------+--------+-------------------+---------------------+---------+----------+-----------+---------+--------+--------------------+-- +------+----+-----------+------+----------+-------------+--------------------+--------+-------------------+---------------------+---------+----------+-----------+---------+--------+--------------------+-- > select * from gcp_compute_firewall where direction = 'INGRESS' and not disabled +----------------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+------------- | name | id | direction | kind | disabled | description | creation_timestamp | action | log_config_e +----------------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+------------- | gke-cluster-1-301c3f75-vms | 5104577529385171382 | INGRESS | compute#firewall | false | | 2022-01-10T15:45:53+05:30 | Allow | false | gke-cluster-1-301c3f75-all | 5657049772648937911 | INGRESS | compute#firewall | false | | 2022-01-10T15:45:52+05:30 | Allow | false | firewall-rule-cis-test | 3959331741200902777 | INGRESS | compute#firewall | false | Used for testing cis 36 onwards | 2021-05-10T12:07:10+05:30 | Allow | false | gke-cluster-1-301c3f75-ssh | 4647282366991153590 | INGRESS | compute#firewall | false | | 2022-01-10T15:45:53+05:30 | Allow | false | allow-iap-traffic | 8165390637190852387 | INGRESS | compute#firewall | false | This is a test firewall rule to validate CIS Section 3.10 | 2021-05-17T12:18:44+05:30 | Allow | false | turbottest4251-allow-https | 1390251844272741058 | INGRESS | compute#firewall | false | | 2021-05-10T13:13:41+05:30 | Allow | false | turbottest4251-allow-http | 1815898569483573954 | INGRESS | compute#firewall | false | | 2021-05-10T13:13:41+05:30 | Allow | false +----------------------------+---------------------+-----------+------------------+----------+-----------------------------------------------------------+---------------------------+--------+------------- ================================================================================ gcp_compute_forwarding_rule =========================== > select * from gcp_compute_forwarding_rule +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- | name | id | description | ip_address | allow_global_access | kind | region +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- | turbottest17041 | 1072843822564695425 | Test forwarding rule to verify the table. | 35.211.126.197 | false | compute#forwardingRule | https://www.googleapis.com/compute/beta/projects/parke +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- > select * from gcp_compute_forwarding_rule limit 1 +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- | name | id | description | ip_address | allow_global_access | kind | region +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- | turbottest17041 | 1072843822564695425 | Test forwarding rule to verify the table. | 35.211.126.197 | false | compute#forwardingRule | https://www.googleapis.com/compute/beta/projects/parke +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- > select * from gcp_compute_forwarding_rule where ip_protocol = 'TCP' and load_balancing_scheme = 'EXTERNAL' and network_tier = 'STANDARD' and not allow_global_access and not all_ports and not is_mirroring_collector +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- | name | id | description | ip_address | allow_global_access | kind | region +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- | turbottest17041 | 1072843822564695425 | Test forwarding rule to verify the table. | 35.211.126.197 | false | compute#forwardingRule | https://www.googleapis.com/compute/beta/projects/parke +-----------------+---------------------+-------------------------------------------+----------------+---------------------+------------------------+------------------------------------------------------- ================================================================================ gcp_compute_global_address ========================== > select * from gcp_compute_global_address where address_type = 'INTERNAL' and network_tier = 'PREMIUM' and purpose = 'VPC_PEERING' and status = 'RESERVED' +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | name | id | address | address_type | ip_version | description | creation_timestamp | kind | network +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | test | 5374255085610970082 | 10.1.0.0 | INTERNAL | | | 2021-04-21T17:35:33+05:30 | compute#address | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/networks/ +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- > select * from gcp_compute_global_address +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | name | id | address | address_type | ip_version | description | creation_timestamp | kind | network +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | test | 5374255085610970082 | 10.1.0.0 | INTERNAL | | | 2021-04-21T17:35:33+05:30 | compute#address | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/networks/ +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- > select * from gcp_compute_global_address limit 1 +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | name | id | address | address_type | ip_version | description | creation_timestamp | kind | network +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- | test | 5374255085610970082 | 10.1.0.0 | INTERNAL | | | 2021-04-21T17:35:33+05:30 | compute#address | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/networks/ +------+---------------------+----------+--------------+------------+-------------+---------------------------+-----------------+--------------------------------------------------------------------------- ================================================================================ gcp_compute_instance_template ================================== > select * from gcp_compute_instance_template +-------------------------------------+---------------------+---------------------------+------------------------------------------------------------------------------------------------------------------- | name | id | creation_timestamp | self_link +-------------------------------------+---------------------+---------------------------+------------------------------------------------------------------------------------------------------------------- | gke-cluster-1-default-pool-c13bbd6f | 6095700786953697000 | 2022-01-10T15:45:54+05:30 | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/instanceTemplates/gke-cluster-1-default-pool-c13b | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | +-------------------------------------+---------------------+---------------------------+------------------------------------------------------------------------------------------------------------------- > select * from gcp_compute_instance_template limit 1 +-------------------------------------+---------------------+---------------------------+------------------------------------------------------------------------------------------------------------------- | name | id | creation_timestamp | self_link +-------------------------------------+---------------------+---------------------------+------------------------------------------------------------------------------------------------------------------- | gke-cluster-1-default-pool-c13bbd6f | 6095700786953697000 | 2022-01-10T15:45:54+05:30 | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/instanceTemplates/gke-cluster-1-default-pool-c13b | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | +-------------------------------------+---------------------+---------------------------+---------------------------------------------------------------------------------------------------------------- ================================================================================ gcp_compute_machine_type ======================== > select * from gcp_compute_machine_type +------------------+---------+-------------------------------------------------------------------------------------------------------------+---------------------------+------------------------------------ | name | id | self_link | creation_timestamp | description +------------------+---------+-------------------------------------------------------------------------------------------------------------+---------------------------+------------------------------------ | c2d-highmem-32 | 1120032 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highmem-32 | 1970-01-01T05:30:00+05:30 | 32 vCPUs, 256 GB RAM | a2-megagpu-16g | 1001096 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/a2-megagpu-16g | 1970-01-01T05:30:00+05:30 | Accelerator Optimized: 16 NVIDIA Te | a2-highgpu-1g | 1000012 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/a2-highgpu-1g | 1970-01-01T05:30:00+05:30 | Accelerator Optimized: 1 NVIDIA Tes | c2d-highcpu-32 | 1110032 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highcpu-32 | 1970-01-01T05:30:00+05:30 | 32 vCPUs, 64 GB RAM | c2d-highcpu-8 | 1110008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highcpu-8 | 1970-01-01T05:30:00+05:30 | 8 vCPUs, 16 GB RAM | a2-highgpu-8g | 1000096 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/a2-highgpu-8g | 1970-01-01T05:30:00+05:30 | Accelerator Optimized: 8 NVIDIA Tes | a2-highgpu-4g | 1000048 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/a2-highgpu-4g | 1970-01-01T05:30:00+05:30 | Accelerator Optimized: 4 NVIDIA Tes | c2d-highmem-112 | 1120112 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highmem-112 | 1970-01-01T05:30:00+05:30 | 112 vCPUs, 896 GB RAM | e2-standard-8 | 335008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/e2-standard-8 | 1970-01-01T05:30:00+05:30 | Efficient Instance, 8 vCPUs, 32 GB | c2d-highcpu-16 | 1110016 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highcpu-16 | 1970-01-01T05:30:00+05:30 | 16 vCPUs, 32 GB RAM | c2d-highcpu-4 | 1110004 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highcpu-4 | 1970-01-01T05:30:00+05:30 | 4 vCPUs, 8 GB RAM | a2-highgpu-2g | 1000024 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/a2-highgpu-2g | 1970-01-01T05:30:00+05:30 | Accelerator Optimized: 2 NVIDIA Tes | c2d-highcpu-112 | 1110112 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highcpu-112 | 1970-01-01T05:30:00+05:30 | 112 vCPUs, 224 GB RAM | c2d-highcpu-56 | 1110056 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highcpu-56 | 1970-01-01T05:30:00+05:30 | 56 vCPUs, 112 GB RAM | c2d-highcpu-2 | 1110002 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highcpu-2 | 1970-01-01T05:30:00+05:30 | 2 vCPUs, 4 GB RAM | c2d-highmem-4 | 1120004 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highmem-4 | 1970-01-01T05:30:00+05:30 | 4 vCPUs, 32 GB RAM | n2d-standard-8 | 911008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-standard-8 | 1970-01-01T05:30:00+05:30 | 8 vCPUs 32 GB RAM | c2d-highmem-16 | 1120016 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highmem-16 | 1970-01-01T05:30:00+05:30 | 16 vCPUs, 128 GB RAM | n2-highmem-32 | 902032 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2-highmem-32 | 1970-01-01T05:30:00+05:30 | 32 vCPUs 256 GB RAM | n2d-highcpu-4 | 910004 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highcpu-4 | 1970-01-01T05:30:00+05:30 | 4 vCPUs 4 GB RAM | c2-standard-16 | 801016 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2-standard-16 | 1970-01-01T05:30:00+05:30 | Compute Optimized: 16 vCPUs, 64 GB | e2-highcpu-8 | 337008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/e2-highcpu-8 | 1970-01-01T05:30:00+05:30 | Efficient Instance, 8 vCPUs, 8 GB R | c2d-highmem-56 | 1120056 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highmem-56 | 1970-01-01T05:30:00+05:30 | 56 vCPUs, 448 GB RAM | c2d-highmem-2 | 1120002 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highmem-2 | 1970-01-01T05:30:00+05:30 | 2 vCPUs, 16 GB RAM | n2d-highcpu-48 | 910048 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highcpu-48 | 1970-01-01T05:30:00+05:30 | 48 vCPUs 48 GB RAM | n2d-highmem-8 | 912008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highmem-8 | 1970-01-01T05:30:00+05:30 | 8 vCPUs 64 GB RAM | f1-micro | 1000 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/f1-micro | 1970-01-01T05:30:00+05:30 | 1 vCPU (shared physical core) and 0 | n2-highmem-4 | 902004 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2-highmem-4 | 1970-01-01T05:30:00+05:30 | 4 vCPUs 32 GB RAM | c2-standard-30 | 801030 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2-standard-30 | 1970-01-01T05:30:00+05:30 | Compute Optimized: 30 vCPUs, 120 GB | e2-highmem-16 | 336016 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/e2-highmem-16 | 1970-01-01T05:30:00+05:30 | Efficient Instance, 16 vCPUs, 128 G | n2d-highmem-80 | 912080 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highmem-80 | 1970-01-01T05:30:00+05:30 | 80 vCPUs 640 GB RAM | n1-standard-16 | 3016 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n1-standard-16 | 1970-01-01T05:30:00+05:30 | 16 vCPUs, 60 GB RAM | c2d-highmem-8 | 1120008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-highmem-8 | 1970-01-01T05:30:00+05:30 | 8 vCPUs, 64 GB RAM | n1-standard-2 | 3002 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n1-standard-2 | 1970-01-01T05:30:00+05:30 | 2 vCPUs, 7.5 GB RAM | n2d-highcpu-64 | 910064 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highcpu-64 | 1970-01-01T05:30:00+05:30 | 64 vCPUs 64 GB RAM | n2-highmem-48 | 902048 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2-highmem-48 | 1970-01-01T05:30:00+05:30 | 48 vCPUs 384 GB RAM | n2d-highmem-96 | 912096 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highmem-96 | 1970-01-01T05:30:00+05:30 | 96 vCPUs 768 GB RAM | g1-small | 2000 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/g1-small | 1970-01-01T05:30:00+05:30 | 1 vCPU (shared physical core) and 1 | e2-highmem-2 | 336002 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/e2-highmem-2 | 1970-01-01T05:30:00+05:30 | Efficient Instance, 2 vCPUs, 16 GB | c2-standard-4 | 801004 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2-standard-4 | 1970-01-01T05:30:00+05:30 | Compute Optimized: 4 vCPUs, 16 GB R | c2d-standard-112 | 1100112 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-standard-112 | 1970-01-01T05:30:00+05:30 | 112 vCPUs, 448 GB RAM | n1-standard-32 | 3032 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n1-standard-32 | 1970-01-01T05:30:00+05:30 | 32 vCPUs, 120 GB RAM | n2-highmem-64 | 902064 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2-highmem-64 | 1970-01-01T05:30:00+05:30 | 64 vCPUs 512 GB RAM | n2d-highcpu-8 | 910008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highcpu-8 | 1970-01-01T05:30:00+05:30 | 8 vCPUs 8 GB RAM | m1-megamem-96 | 9196 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/m1-megamem-96 | 1970-01-01T05:30:00+05:30 | 96 vCPUs, 1.4 TB RAM | e2-highmem-4 | 336004 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/e2-highmem-4 | 1970-01-01T05:30:00+05:30 | Efficient Instance, 4 vCPUs, 32 GB | c2-standard-60 | 801060 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2-standard-60 | 1970-01-01T05:30:00+05:30 | Compute Optimized: 60 vCPUs, 240 GB | n2d-standard-128 | 911128 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-standard-128 | 1970-01-01T05:30:00+05:30 | 128 vCPUs 512 GB RAM | n1-standard-4 | 3004 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n1-standard-4 | 1970-01-01T05:30:00+05:30 | 4 vCPUs, 15 GB RAM | c2d-standard-16 | 1100016 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-standard-16 | 1970-01-01T05:30:00+05:30 | 16 vCPUs, 64 GB RAM | n2d-highcpu-80 | 910080 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highcpu-80 | 1970-01-01T05:30:00+05:30 | 80 vCPUs 80 GB RAM | n2-highmem-8 | 902008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2-highmem-8 | 1970-01-01T05:30:00+05:30 | 8 vCPUs 64 GB RAM | c2-standard-8 | 801008 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2-standard-8 | 1970-01-01T05:30:00+05:30 | Compute Optimized: 8 vCPUs, 32 GB R | m1-ultramem-160 | 11160 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/m1-ultramem-160 | 1970-01-01T05:30:00+05:30 | 160 vCPUs, 3844 GB RAM | n2d-standard-16 | 911016 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-standard-16 | 1970-01-01T05:30:00+05:30 | 16 vCPUs 64 GB RAM | n2d-highcpu-96 | 910096 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/n2d-highcpu-96 | 1970-01-01T05:30:00+05:30 | 96 vCPUs 96 GB RAM | c2d-standard-2 | 1100002 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/c2d-standard-2 | 1970-01-01T05:30:00+05:30 | 2 vCPUs, 8 GB RAM > select * from gcp_compute_machine_type limit 1 +---------------+---------+----------------------------------------------------------------------------------------------------------+---------------------------+------------------------------------------ | name | id | self_link | creation_timestamp | description +---------------+---------+----------------------------------------------------------------------------------------------------------+---------------------------+------------------------------------------ | a2-highgpu-1g | 1000012 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-c/machineTypes/a2-highgpu-1g | 1970-01-01T05:30:00+05:30 | Accelerator Optimized: 1 NVIDIA Tesla A10 +---------------+---------+----------------------------------------------------------------------------------------------------------+---------------------------+------------------------------------------ ================================================================================ gcp_compute_network ==================== > select * from gcp_compute_network +-----------------+---------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+-------------------------------------- | name | id | creation_timestamp | auto_create_subnetworks | description | gateway_ipv4 | ipv4_range | kind | mtu | self_link +-----------------+---------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+-------------------------------------- | raj-cis-test-nw | 529512961903467200 | 2021-05-07T16:58:10+05:30 | false | raj-cis-test-nw | | | compute#network | 1460 | https://www.googleapis.com/compute/v1 | turbottest4251 | 2297009420028172300 | 2021-02-17T15:19:36+05:30 | true | | | | compute#network | 1460 | https://www.googleapis.com/compute/v1 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | +-----------------+---------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+-------------------------------------- > select * from gcp_compute_network limit 1 +-----------------+--------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+--------------------------------------- | name | id | creation_timestamp | auto_create_subnetworks | description | gateway_ipv4 | ipv4_range | kind | mtu | self_link +-----------------+--------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+--------------------------------------- | raj-cis-test-nw | 529512961903467200 | 2021-05-07T16:58:10+05:30 | false | raj-cis-test-nw | | | compute#network | 1460 | https://www.googleapis.com/compute/v1/ +-----------------+--------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+--------------------------------------- > select * from gcp_compute_network where not auto_create_subnetworks +-----------------+--------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+--------------------------------------- | name | id | creation_timestamp | auto_create_subnetworks | description | gateway_ipv4 | ipv4_range | kind | mtu | self_link +-----------------+--------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+--------------------------------------- | raj-cis-test-nw | 529512961903467200 | 2021-05-07T16:58:10+05:30 | false | raj-cis-test-nw | | | compute#network | 1460 | https://www.googleapis.com/compute/v1/ +-----------------+--------------------+---------------------------+-------------------------+-----------------+--------------+------------+-----------------+------+--------------------------------------- ================================================================================ gcp_compute_node_group ====================== > select * from gcp_compute_node_group where maintenance_policy = 'RESTART_IN_PLACE' and status = 'READY' +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- | name | id | status | size | description | kind | autoscaling_policy_mode | autoscaling_policy_max_nodes | aut +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- | turbottest85372 | 6936409724266010033 | READY | 1 | example google_compute_node_group for Terraform Google Provider | compute#nodeGroup | ONLY_SCALE_OUT | 10 | 1 +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- > select * from gcp_compute_node_group limit 1 +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- | name | id | status | size | description | kind | autoscaling_policy_mode | autoscaling_policy_max_nodes | aut +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- | turbottest85372 | 6936409724266010033 | READY | 1 | example google_compute_node_group for Terraform Google Provider | compute#nodeGroup | ONLY_SCALE_OUT | 10 | 1 +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- > select * from gcp_compute_node_group +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- | name | id | status | size | description | kind | autoscaling_policy_mode | autoscaling_policy_max_nodes | aut +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- | turbottest85372 | 6936409724266010033 | READY | 1 | example google_compute_node_group for Terraform Google Provider | compute#nodeGroup | ONLY_SCALE_OUT | 10 | 1 +-----------------+---------------------+--------+------+-----------------------------------------------------------------+-------------------+-------------------------+------------------------------+---- ================================================================================ gcp_compute_node_template ========================= > select * from gcp_compute_node_template +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- | name | id | status | description | kind | creation_timestamp | cpu_overcommit_type | node_type | node_type_fl +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- | turbottest90853 | 5343566994546414219 | READY | Test Node Template resource to verify the table. | compute#nodeTemplate | 2022-01-11T17:09:16+05:30 | NONE | c2-node-60-240 | +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- > select * from gcp_compute_node_template limit 1 +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- | name | id | status | description | kind | creation_timestamp | cpu_overcommit_type | node_type | node_type_fl +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- | turbottest90853 | 5343566994546414219 | READY | Test Node Template resource to verify the table. | compute#nodeTemplate | 2022-01-11T17:09:16+05:30 | NONE | c2-node-60-240 | +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- > select * from gcp_compute_node_template where cpu_overcommit_type = 'NONE' and node_type = 'c2-node-60-240' and status = 'READY' +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- | name | id | status | description | kind | creation_timestamp | cpu_overcommit_type | node_type | node_type_fl +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- | turbottest90853 | 5343566994546414219 | READY | Test Node Template resource to verify the table. | compute#nodeTemplate | 2022-01-11T17:09:16+05:30 | NONE | c2-node-60-240 | +-----------------+---------------------+--------+--------------------------------------------------+----------------------+---------------------------+---------------------+----------------+------------- ================================================================================ gcp_compute_region ==================== > select * from gcp_compute_region +-------------------------+------+--------+-------------------------+----------------+-------------------------------------------------------------------------------------------+-------------------------- | name | id | status | description | kind | self_link | quotas +-------------------------+------+--------+-------------------------+----------------+-------------------------------------------------------------------------------------------+-------------------------- | asia-east1 | 1220 | UP | asia-east1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-east1 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | europe-west4 | 1340 | UP | europe-west4 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west4 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | southamerica-east1 | 1310 | UP | southamerica-east1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/southamerica-east1 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | us-east1 | 1230 | UP | us-east1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east1 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | D_NVIDIA_P100_GPUS"},{"li | | | | | | | ":"EXTERNAL_NETWORK_LB_FO | us-east4 | 1270 | UP | us-east4 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east4 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | australia-southeast1 | 1280 | UP | australia-southeast1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/australia-southeast1 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | us-west4 | 1430 | UP | us-west4 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west4 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | us-west3 | 1420 | UP | us-west3 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west3 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | australia-southeast2 | 1480 | UP | australia-southeast2 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/australia-southeast2 | [{"limit":300,"metric":"C | | | | | | | S"},{"limit":1,"metric":" | | | | | | | "},{"metric":"COMMITTED_N | | | | | | | _TOTAL_PROVISIONED_IOPS"} | northamerica-northeast1 | 1330 | UP | northamerica-northeast1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/northamerica-northeast1 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | southamerica-west1 | 1490 | UP | southamerica-west1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/southamerica-west1 | [{"limit":300,"metric":"C | | | | | | | S"},{"limit":1,"metric":" | | | | | | | "},{"metric":"COMMITTED_N | | | | | | | _TOTAL_PROVISIONED_IOPS"} | us-west1 | 1210 | UP | us-west1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west1 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | asia-south2 | 1470 | UP | asia-south2 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-south2 | [{"limit":300,"metric":"C | | | | | | | S"},{"limit":1,"metric":" | | | | | | | "},{"metric":"COMMITTED_N | | | | | | | _TOTAL_PROVISIONED_IOPS"} | asia-northeast3 | 1410 | UP | asia-northeast3 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-northeast3 | [{"limit":600,"metric":"C | | | | | | | :"NVIDIA_P100_VWS_GPUS"}, | | | | | | | 100_GPUS"},{"limit":1,"me | | | | | | | L_NETWORK_LB_FORWARDING_R | asia-northeast2 | 1390 | UP | asia-northeast2 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-northeast2 | [{"limit":600,"metric":"C > select * from gcp_compute_region where name = 'asia-east1' and status = 'UP' +------------+------+--------+-------------+----------------+------------------------------------------------------------------------------+---------------------------------------------------------------- | name | id | status | description | kind | self_link | quotas +------------+------+--------+-------------+----------------+------------------------------------------------------------------------------+---------------------------------------------------------------- | asia-east1 | 1220 | UP | asia-east1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-east1 | [{"limit":600,"metric":"CPUS"},{"limit":102400,"metric":"DISKS_ | | | | | | | :"NVIDIA_P100_VWS_GPUS"},{"limit":8,"metric":"NVIDIA_V100_GPUS" | | | | | | | 100_GPUS"},{"limit":1,"metric":"COMMITTED_NVIDIA_P4_GPUS"},{"li | | | | | | | L_NETWORK_LB_FORWARDING_RULES"},{"limit":150,"metric":"EXTERNAL +------------+------+--------+-------------+----------------+------------------------------------------------------------------------------+---------------------------------------------------------------- > select * from gcp_compute_region limit 1 +------------+------+--------+-------------+----------------+------------------------------------------------------------------------------+---------------------------------------------------------------- | name | id | status | description | kind | self_link | quotas +------------+------+--------+-------------+----------------+------------------------------------------------------------------------------+---------------------------------------------------------------- | asia-east1 | 1220 | UP | asia-east1 | compute#region | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-east1 | [{"limit":600,"metric":"CPUS"},{"limit":102400,"metric":"DISKS_ | | | | | | | :"NVIDIA_P100_VWS_GPUS"},{"limit":8,"metric":"NVIDIA_V100_GPUS" | | | | | | | 100_GPUS"},{"limit":1,"metric":"COMMITTED_NVIDIA_P4_GPUS"},{"li | | | | | | | L_NETWORK_LB_FORWARDING_RULES"},{"limit":150,"metric":"EXTERNAL +------------+------+--------+-------------+----------------+------------------------------------------------------------------------------+---------------------------------------------------------------- ================================================================================ gcp_compute_resource_policy =========================== > select * from gcp_compute_resource_policy +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- | name | id | status | self_link | creation_timestamp | descri +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- | turbottest96258 | 287921180357122860 | READY | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east1/resourcePolicies/turbottest96258 | 2021-06-23T13:11:55+05:30 | Start | default-schedule-1 | 6914437448963200575 | READY | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-central1/resourcePolicies/default-schedule-1 | 2021-12-09T12:27:20+05:30 | +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- > select * from gcp_compute_resource_policy where status = 'READY' +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- | name | id | status | self_link | creation_timestamp | descri +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- | turbottest96258 | 287921180357122860 | READY | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east1/resourcePolicies/turbottest96258 | 2021-06-23T13:11:55+05:30 | Start | turbottest34903 | 8799198832235696898 | READY | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east1/resourcePolicies/turbottest34903 | 2022-01-11T17:15:49+05:30 | Start | default-schedule-1 | 6914437448963200575 | READY | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-central1/resourcePolicies/default-schedule-1 | 2021-12-09T12:27:20+05:30 | +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- > select * from gcp_compute_resource_policy limit 1 +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- | name | id | status | self_link | creation_timestamp | descri +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- | default-schedule-1 | 6914437448963200575 | READY | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-central1/resourcePolicies/default-schedule-1 | 2021-12-09T12:27:20+05:30 | +--------------------+---------------------+--------+-------------------------------------------------------------------------------------------------------------------+---------------------------+------- ================================================================================ gcp_compute_router ==================== > select * from gcp_compute_router +-----------------+---------------------+----------------------------------+----------------+---------------------------+----------------------------------------------------------------------------------- | name | id | description | kind | creation_timestamp | network +-----------------+---------------------+----------------------------------+----------------+---------------------------+----------------------------------------------------------------------------------- | turbottest38835 | 6192484898556661829 | Test router to verify the table. | compute#router | 2022-01-11T17:18:58+05:30 | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/networks/turbotte +-----------------+---------------------+----------------------------------+----------------+---------------------------+----------------------------------------------------------------------------------- > select * from gcp_compute_router limit 1 +-----------------+---------------------+----------------------------------+----------------+---------------------------+----------------------------------------------------------------------------------- | name | id | description | kind | creation_timestamp | network +-----------------+---------------------+----------------------------------+----------------+---------------------------+----------------------------------------------------------------------------------- | turbottest38835 | 6192484898556661829 | Test router to verify the table. | compute#router | 2022-01-11T17:18:58+05:30 | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/networks/turbotte +-----------------+---------------------+----------------------------------+----------------+---------------------------+----------------------------------------------------------------------------------- ================================================================================ gcp_compute_snapshot ==================== > select * from gcp_compute_snapshot where not auto_created and status = 'READY' and storage_bytes_status = 'UP_TO_DATE' +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- | name | source_disk | source_disk_name | description | auto_created | creatio +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- | turbottest14209 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-a/disks/turbottest14209 | turbottest14209 | Test compute snapshot to verify table. | false | 2022-01 +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- > select * from gcp_compute_snapshot limit 1 +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- | name | source_disk | source_disk_name | description | auto_created | creatio +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- | turbottest14209 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-a/disks/turbottest14209 | turbottest14209 | Test compute snapshot to verify table. | false | 2022-01 +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- > select * from gcp_compute_snapshot +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- | name | source_disk | source_disk_name | description | auto_created | creatio +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- | turbottest14209 | https://www.googleapis.com/compute/v1/projects/parker-aaa/zones/us-central1-a/disks/turbottest14209 | turbottest14209 | Test compute snapshot to verify table. | false | 2022-01 +-----------------+-----------------------------------------------------------------------------------------------------+------------------+----------------------------------------+--------------+-------- ================================================================================ gcp_compute_ssl_policy ==================== > select * from gcp_compute_ssl_policy +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- | name | id | kind | description | creation_timestamp | fingerprint | min_tls_version | profile | self_link +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- | raj-test-cis | 2384610273069340053 | compute#sslPolicy | | 2021-05-20T14:57:22+05:30 | u9v_Oi9pzNo= | TLS_1_0 | MODERN | https://www.googleapis.com/compute/v1/projects/parker-aaa/gl +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- > select * from gcp_compute_ssl_policy limit 1 +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- | name | id | kind | description | creation_timestamp | fingerprint | min_tls_version | profile | self_link +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- | raj-test-cis | 2384610273069340053 | compute#sslPolicy | | 2021-05-20T14:57:22+05:30 | u9v_Oi9pzNo= | TLS_1_0 | MODERN | https://www.googleapis.com/compute/v1/projects/parker-aaa/gl +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- > select * from gcp_compute_ssl_policy where min_tls_version = 'TLS_1_0' and profile = 'MODERN' +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- | name | id | kind | description | creation_timestamp | fingerprint | min_tls_version | profile | self_link +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- | raj-test-cis | 2384610273069340053 | compute#sslPolicy | | 2021-05-20T14:57:22+05:30 | u9v_Oi9pzNo= | TLS_1_0 | MODERN | https://www.googleapis.com/compute/v1/projects/parker-aaa/gl +--------------+---------------------+-------------------+-------------+---------------------------+--------------+-----------------+---------+------------------------------------------------------------- ================================================================================ gcp_compute_subnetwork ====================== > select * from gcp_compute_subnetwork where private_ipv6_google_access = 'DISABLE_GOOGLE_ACCESS' and purpose = 'PRIVATE' and not enable_flow_logs and not private_ip_google_access +-------------------+---------------------+-----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+---- | name | id | network_name | state | kind | description | creation_timestamp | enable_flow_logs | fingerprint | log_config_aggregation_interval | log +-------------------+---------------------+-----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+---- | public-ip-testing | 3862899408894466743 | raj-cis-test-nw | | compute#subnetwork | | 2021-05-07T16:58:24+05:30 | false | ByGUTw06IWQ= | INTERVAL_5_SEC | fal +-------------------+---------------------+-----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+---- > select * from gcp_compute_subnetwork +-------------------+---------------------+-----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+---- | name | id | network_name | state | kind | description | creation_timestamp | enable_flow_logs | fingerprint | log_config_aggregation_interval | log +-------------------+---------------------+-----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+---- | turbottest4251 | 1880579883613116506 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | 4cy7FVkDeeI= | | fal | turbottest4251 | 417828599438071897 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | 8k3SB84J0Ns= | | fal | turbottest4251 | 3237417635046053978 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | hyNjWYyl2VA= | | fal | turbottest4251 | 5281939694211389530 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | Vvw64dnhAss= | | fal | turbottest4251 | 7233263802026907737 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | jlMDpHxQgE0= | | fal | turbottest4251 | 3481811122548463705 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | 8tKFFEEnBOc= | | fal | turbottest4251 | 5516235756557823524 | turbottest4251 | | compute#subnetwork | | 2021-03-05T21:09:55+05:30 | false | dE3XEGGMDgk= | | fal | turbottest4251 | 7503569905262876761 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | Gd6CkRKFZdE= | | fal | turbottest4251 | 5038746448228729124 | turbottest4251 | | compute#subnetwork | | 2021-09-16T13:56:51+05:30 | false | -l8hYCvZOdw= | | fal | turbottest4251 | 8691824658409936985 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | 1v0pwPKTEWw= | | fal | public-ip-testing | 3862899408894466743 | raj-cis-test-nw | | compute#subnetwork | | 2021-05-07T16:58:24+05:30 | false | ByGUTw06IWQ= | INTERVAL_5_SEC | fal | turbottest4251 | 8817045636810627162 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | fTxS8aYnuLM= | | fal | turbottest4251 | 7475806712675522650 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | wOr-o78MYzQ= | | fal | turbottest4251 | 9123412414312831066 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | LnkyUrADw3k= | | fal | turbottest4251 | 2135411975595841626 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | ASLDtROsY9c= | | fal | turbottest4251 | 3618384296512936026 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | 0_6uQbfM2to= | | fal | turbottest4251 | 6093017596314081369 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | YKNGONtU8Wc= | | fal | turbottest4251 | 4940769778802448473 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | _lv-l1vWxW0= | | fal | turbottest4251 | 5934439762998941785 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | 5EGGsseWwYI= | | fal | turbottest4251 | 6041922118439864451 | turbottest4251 | | compute#subnetwork | | 2021-04-23T17:28:36+05:30 | false | pPFNSatfmws= | | fal | turbottest4251 | 8701278680292350042 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | -MnsLKhMyOI= | | fal | turbottest4251 | 7878926815455172698 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | gTHXidwEGo0= | | fal | turbottest4251 | 8992086676771788889 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | jxLoeza8rJQ= | | fal | turbottest4251 | 99033367697250394 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | 1RgY93rYyFw= | | fal | turbottest4251 | 7113064563807358615 | turbottest4251 | | compute#subnetwork | | 2021-04-25T23:40:01+05:30 | false | l_HzyGdrRMc= | | fal | turbottest4251 | 3710393233411496026 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | 4ENaIU8Equ8= | | fal | turbottest4251 | 6552885177830430810 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | Vkkd_sye-I4= | | fal | turbottest4251 | 7965006292301807770 | turbottest4251 | | compute#subnetwork | | 2021-06-17T17:52:13+05:30 | false | xV1UvUmCi_4= | | fal | turbottest4251 | 1473773187065010266 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | qUAz4C7K5cc= | | fal | turbottest4251 | 4467832414235875418 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:41+05:30 | false | VzIOlNViksU= | | fal +-------------------+---------------------+-----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+---- > select * from gcp_compute_subnetwork limit 1 +----------------+--------------------+----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+--------- | name | id | network_name | state | kind | description | creation_timestamp | enable_flow_logs | fingerprint | log_config_aggregation_interval | log_conf +----------------+--------------------+----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+--------- | turbottest4251 | 417828599438071897 | turbottest4251 | | compute#subnetwork | | 2021-02-17T15:19:42+05:30 | false | 8k3SB84J0Ns= | | false +----------------+--------------------+----------------+-------+--------------------+-------------+---------------------------+------------------+--------------+---------------------------------+--------- ================================================================================ gcp_compute_target_https_proxy ============================== > select * from gcp_compute_target_https_proxy +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- | name | id | creation_timestamp | description | authorization_policy | kind | proxy_bind | quic_override +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- | turbottest47322 | 2990500892927642000 | 2022-01-11T17:41:53+05:30 | Test target https proxy to validate the table outcome. | | compute#targetHttpsProxy | false | NONE +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- > select * from gcp_compute_target_https_proxy limit 1 +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- | name | id | creation_timestamp | description | authorization_policy | kind | proxy_bind | quic_override +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- | turbottest47322 | 2990500892927642000 | 2022-01-11T17:41:53+05:30 | Test target https proxy to validate the table outcome. | | compute#targetHttpsProxy | false | NONE +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- > select * from gcp_compute_target_https_proxy where not proxy_bind +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- | name | id | creation_timestamp | description | authorization_policy | kind | proxy_bind | quic_override +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- | turbottest47322 | 2990500892927642000 | 2022-01-11T17:41:53+05:30 | Test target https proxy to validate the table outcome. | | compute#targetHttpsProxy | false | NONE +-----------------+---------------------+---------------------------+--------------------------------------------------------+----------------------+--------------------------+------------+--------------- ================================================================================ gcp_compute_target_pool ======================== > select * from gcp_compute_target_pool where session_affinity = 'NONE' +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- | name | id | description | creation_timestamp | kind | self_link +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- | turbottest62374 | 6311843534361120000 | Test compute target pool to validate integration test | 2022-01-11T17:47:34+05:30 | compute#targetPool | https://www.googleapis.com/compute/v1/projects/parker-aaa +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- > select * from gcp_compute_target_pool +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- | name | id | description | creation_timestamp | kind | self_link +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- | turbottest62374 | 6311843534361120000 | Test compute target pool to validate integration test | 2022-01-11T17:47:34+05:30 | compute#targetPool | https://www.googleapis.com/compute/v1/projects/parker-aaa +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- > select * from gcp_compute_target_pool limit 1 +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- | name | id | description | creation_timestamp | kind | self_link +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- | turbottest62374 | 6311843534361120000 | Test compute target pool to validate integration test | 2022-01-11T17:47:34+05:30 | compute#targetPool | https://www.googleapis.com/compute/v1/projects/parker-aaa +-----------------+---------------------+-------------------------------------------------------+---------------------------+--------------------+---------------------------------------------------------- ================================================================================ gcp_compute_target_ssl_proxy ============================ > select * from gcp_compute_target_ssl_proxy +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- | name | id | kind | description | creation_timestamp | proxy_header | self_link +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- | turbottest17646 | 3898934476586141812 | compute#targetSslProxy | Test target ssl proxy to validate the table outcome. | 2022-01-11T17:52:51+05:30 | NONE | https://www.googleapis.com/compute/v1/p +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- > select * from gcp_compute_target_ssl_proxy limit 1 +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- | name | id | kind | description | creation_timestamp | proxy_header | self_link +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- | turbottest17646 | 3898934476586141812 | compute#targetSslProxy | Test target ssl proxy to validate the table outcome. | 2022-01-11T17:52:51+05:30 | NONE | https://www.googleapis.com/compute/v1/p +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- > select * from gcp_compute_target_ssl_proxy where proxy_header = 'NONE' +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- | name | id | kind | description | creation_timestamp | proxy_header | self_link +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- | turbottest17646 | 3898934476586141812 | compute#targetSslProxy | Test target ssl proxy to validate the table outcome. | 2022-01-11T17:52:51+05:30 | NONE | https://www.googleapis.com/compute/v1/p +-----------------+---------------------+------------------------+------------------------------------------------------+---------------------------+--------------+---------------------------------------- ================================================================================ gcp_compute_url_map =================== > select * from gcp_compute_url_map +-----------------+---------------------+--------------------------------------------+----------------+---------------------------+------------------------------------------------------------------------- | name | id | description | kind | creation_timestamp | default_service +-----------------+---------------------+--------------------------------------------+----------------+---------------------------+------------------------------------------------------------------------- | turbottest35315 | 1344488765891069547 | Test URL Map to validate integration test. | compute#urlMap | 2022-01-11T18:01:00+05:30 | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/backend +-----------------+---------------------+--------------------------------------------+----------------+---------------------------+------------------------------------------------------------------------- > select * from gcp_compute_url_map limit 1 +-----------------+---------------------+--------------------------------------------+----------------+---------------------------+------------------------------------------------------------------------- | name | id | description | kind | creation_timestamp | default_service +-----------------+---------------------+--------------------------------------------+----------------+---------------------------+------------------------------------------------------------------------- | turbottest35315 | 1344488765891069547 | Test URL Map to validate integration test. | compute#urlMap | 2022-01-11T18:01:00+05:30 | https://www.googleapis.com/compute/v1/projects/parker-aaa/global/backend +-----------------+---------------------+--------------------------------------------+----------------+---------------------------+------------------------------------------------------------------------- ================================================================================ gcp_compute_vpn_tunnel ======================= > select * from gcp_compute_vpn_tunnel where vpn_gateway = '' and status = 'WAITING_FOR_FULL_CONFIG' +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ | name | id | kind | description | status | creation_timestamp | detailed_status | ike_v +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ | turbottest90795 | 3569876334592181256 | compute#vpnTunnel | Test VPN Tunnel to validate integration test. | WAITING_FOR_FULL_CONFIG | 2022-01-11T18:11:11+05:30 | Waiting for route configuration. | 2 +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ > select * from gcp_compute_vpn_tunnel +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ | name | id | kind | description | status | creation_timestamp | detailed_status | ike_v +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ | turbottest90795 | 3569876334592181256 | compute#vpnTunnel | Test VPN Tunnel to validate integration test. | WAITING_FOR_FULL_CONFIG | 2022-01-11T18:11:11+05:30 | Waiting for route configuration. | 2 +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ > select * from gcp_compute_vpn_tunnel limit 1 +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ | name | id | kind | description | status | creation_timestamp | detailed_status | ike_v +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ | turbottest90795 | 3569876334592181256 | compute#vpnTunnel | Test VPN Tunnel to validate integration test. | WAITING_FOR_FULL_CONFIG | 2022-01-11T18:11:11+05:30 | Waiting for route configuration. | 2 +-----------------+---------------------+-------------------+-----------------------------------------------+-------------------------+---------------------------+----------------------------------+------ ================================================================================ gcp_compute_target_vpn_gateway ============================== > select * from gcp_compute_target_vpn_gateway +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- | name | id | kind | description | status | creation_timestamp | network +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- | turbottest43626 | 9139475536180986172 | compute#targetVpnGateway | Test VPN target gateway to validate integration test. | READY | 2022-01-11T18:32:11+05:30 | https://www.googleapis.com/compute/v1/proj +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- > select * from gcp_compute_target_vpn_gateway limit 1 +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- | name | id | kind | description | status | creation_timestamp | network +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- | turbottest43626 | 9139475536180986172 | compute#targetVpnGateway | Test VPN target gateway to validate integration test. | READY | 2022-01-11T18:32:11+05:30 | https://www.googleapis.com/compute/v1/proj +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- > select * from gcp_compute_target_vpn_gateway where status = 'READY' +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- | name | id | kind | description | status | creation_timestamp | network +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- | turbottest43626 | 9139475536180986172 | compute#targetVpnGateway | Test VPN target gateway to validate integration test. | READY | 2022-01-11T18:32:11+05:30 | https://www.googleapis.com/compute/v1/proj +-----------------+---------------------+--------------------------+-------------------------------------------------------+--------+---------------------------+------------------------------------------- ================================================================================ gcp_compute_zone ==================== > select * from gcp_compute_zone +---------------------------+------+-------------------------+--------+-------------------------------------------------------------------------------------------+---------------------------+------------- | name | id | region_name | status | region | description | kind +---------------------------+------+-------------------------+--------+-------------------------------------------------------------------------------------------+---------------------------+------------- | europe-west1-b | 2101 | europe-west1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west1 | europe-west1-b | compute#zone | us-central1-a | 2000 | us-central1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-central1 | us-central1-a | compute#zone | us-west1-a | 2210 | us-west1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west1 | us-west1-a | compute#zone | us-west1-c | 2212 | us-west1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west1 | us-west1-c | compute#zone | us-east4-a | 2270 | us-east4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east4 | us-east4-a | compute#zone | asia-southeast2-b | 2442 | asia-southeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-southeast2 | asia-southeast2-b | compute#zone | us-central1-c | 2002 | us-central1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-central1 | us-central1-c | compute#zone | europe-west4-a | 2342 | europe-west4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west4 | europe-west4-a | compute#zone | us-central1-f | 2004 | us-central1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-central1 | us-central1-f | compute#zone | us-east4-b | 2271 | us-east4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east4 | us-east4-b | compute#zone | asia-southeast2-c | 2441 | asia-southeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-southeast2 | asia-southeast2-c | compute#zone | europe-west4-b | 2341 | europe-west4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west4 | europe-west4-b | compute#zone | us-east1-c | 2233 | us-east1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east1 | us-east1-c | compute#zone | us-central1-b | 2001 | us-central1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-central1 | us-central1-b | compute#zone | europe-west1-d | 2104 | europe-west1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west1 | europe-west1-d | compute#zone | europe-west4-c | 2340 | europe-west4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west4 | europe-west4-c | compute#zone | us-east4-c | 2272 | us-east4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east4 | us-east4-c | compute#zone | northamerica-northeast1-c | 2332 | northamerica-northeast1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/northamerica-northeast1 | northamerica-northeast1-c | compute#zone | northamerica-northeast2-a | 2461 | northamerica-northeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/northamerica-northeast2 | northamerica-northeast2-a | compute#zone | us-east1-b | 2231 | us-east1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east1 | us-east1-b | compute#zone | us-west1-b | 2211 | us-west1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west1 | us-west1-b | compute#zone | asia-southeast2-a | 2440 | asia-southeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-southeast2 | asia-southeast2-a | compute#zone | europe-west1-c | 2103 | europe-west1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west1 | europe-west1-c | compute#zone | us-west2-b | 2361 | us-west2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west2 | us-west2-b | compute#zone | australia-southeast2-a | 2480 | australia-southeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/australia-southeast2 | australia-southeast2-a | compute#zone | us-west2-c | 2360 | us-west2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west2 | us-west2-c | compute#zone | us-east1-d | 2234 | us-east1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-east1 | us-east1-d | compute#zone | europe-west6-b | 2380 | europe-west6 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west6 | europe-west6-b | compute#zone | europe-north1-b | 2350 | europe-north1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-north1 | europe-north1-b | compute#zone | europe-west3-c | 2300 | europe-west3 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west3 | europe-west3-c | compute#zone | northamerica-northeast2-b | 2460 | northamerica-northeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/northamerica-northeast2 | northamerica-northeast2-b | compute#zone | europe-west6-c | 2381 | europe-west6 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west6 | europe-west6-c | compute#zone | us-west3-a | 2420 | us-west3 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west3 | us-west3-a | compute#zone | europe-central2-b | 2450 | europe-central2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-central2 | europe-central2-b | compute#zone | europe-west3-a | 2301 | europe-west3 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west3 | europe-west3-a | compute#zone | europe-north1-c | 2351 | europe-north1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-north1 | europe-north1-c | compute#zone | europe-central2-a | 2452 | europe-central2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-central2 | europe-central2-a | compute#zone | europe-west6-a | 2382 | europe-west6 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west6 | europe-west6-a | compute#zone | northamerica-northeast1-a | 2330 | northamerica-northeast1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/northamerica-northeast1 | northamerica-northeast1-a | compute#zone | us-west3-b | 2421 | us-west3 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west3 | us-west3-b | compute#zone | northamerica-northeast2-c | 2462 | northamerica-northeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/northamerica-northeast2 | northamerica-northeast2-c | compute#zone | europe-west3-b | 2302 | europe-west3 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west3 | europe-west3-b | compute#zone | europe-central2-c | 2451 | europe-central2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-central2 | europe-central2-c | compute#zone | us-west4-a | 2431 | us-west4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west4 | us-west4-a | compute#zone | northamerica-northeast1-b | 2331 | northamerica-northeast1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/northamerica-northeast1 | northamerica-northeast1-b | compute#zone | us-west3-c | 2422 | us-west3 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west3 | us-west3-c | compute#zone | southamerica-west1-a | 2490 | southamerica-west1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/southamerica-west1 | southamerica-west1-a | compute#zone | australia-southeast2-b | 2482 | australia-southeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/australia-southeast2 | australia-southeast2-b | compute#zone | us-west4-b | 2432 | us-west4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west4 | us-west4-b | compute#zone | europe-north1-a | 2352 | europe-north1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-north1 | europe-north1-a | compute#zone | australia-southeast2-c | 2481 | australia-southeast2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/australia-southeast2 | australia-southeast2-c | compute#zone | europe-west2-c | 2292 | europe-west2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west2 | europe-west2-c | compute#zone | australia-southeast1-c | 2280 | australia-southeast1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/australia-southeast1 | australia-southeast1-c | compute#zone | asia-southeast1-c | 2262 | asia-southeast1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-southeast1 | asia-southeast1-c | compute#zone | us-west4-c | 2430 | us-west4 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/us-west4 | us-west4-c | compute#zone | europe-west2-a | 2290 | europe-west2 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/europe-west2 | europe-west2-a | compute#zone | asia-east1-b | 2221 | asia-east1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-east1 | asia-east1-b | compute#zone > select * from gcp_compute_zone limit 1 +--------------+------+-------------+--------+------------------------------------------------------------------------------+--------------+--------------+------------------------------------------------- | name | id | region_name | status | region | description | kind | self_link +--------------+------+-------------+--------+------------------------------------------------------------------------------+--------------+--------------+------------------------------------------------- | asia-east1-c | 2222 | asia-east1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-east1 | asia-east1-c | compute#zone | https://www.googleapis.com/compute/v1/projects/p +--------------+------+-------------+--------+------------------------------------------------------------------------------+--------------+--------------+------------------------------------------------- > select * from gcp_compute_zone where name = 'asia-east1-b' and status = 'UP' +--------------+------+-------------+--------+------------------------------------------------------------------------------+--------------+--------------+------------------------------------------------- | name | id | region_name | status | region | description | kind | self_link +--------------+------+-------------+--------+------------------------------------------------------------------------------+--------------+--------------+------------------------------------------------- | asia-east1-b | 2221 | asia-east1 | UP | https://www.googleapis.com/compute/v1/projects/parker-aaa/regions/asia-east1 | asia-east1-b | compute#zone | https://www.googleapis.com/compute/v1/projects/p +--------------+------+-------------+--------+------------------------------------------------------------------------------+--------------+--------------+------------------------------------------------ ================================================================================ gcp_dns_managed_zone ==================== > select * from gcp_dns_managed_zone +-----------------+---------------------+-----------------+-------------+------------+---------------------------+--------------------------------------------------+-----------------------------+--------- | name | id | kind | dns_name | visibility | creation_time | description | dnssec_config_non_existence | dnssec_c +-----------------+---------------------+-----------------+-------------+------------+---------------------------+--------------------------------------------------+-----------------------------+--------- | turbottest28271 | 7958081256959948185 | dns#managedZone | turbot.com. | private | 2022-01-11T18:39:45+05:30 | Test managed zone to validate the table outcome. | | +-----------------+---------------------+-----------------+-------------+------------+---------------------------+--------------------------------------------------+-----------------------------+--------- > select * from gcp_dns_managed_zone limit 1 +-----------------+---------------------+-----------------+-------------+------------+---------------------------+--------------------------------------------------+-----------------------------+--------- | name | id | kind | dns_name | visibility | creation_time | description | dnssec_config_non_existence | dnssec_c +-----------------+---------------------+-----------------+-------------+------------+---------------------------+--------------------------------------------------+-----------------------------+--------- | turbottest28271 | 7958081256959948185 | dns#managedZone | turbot.com. | private | 2022-01-11T18:39:45+05:30 | Test managed zone to validate the table outcome. | | +-----------------+---------------------+-----------------+-------------+------------+---------------------------+--------------------------------------------------+-----------------------------+--------- ================================================================================ gcp_dns_policy ==================== > select * from gcp_dns_policy +-----------------+---------------------+----------------+--------------------------------------------------------+---------------------------+------------+------------------------------------------------ | name | id | enable_logging | description | enable_inbound_forwarding | kind | networks +-----------------+---------------------+----------------+--------------------------------------------------------+---------------------------+------------+------------------------------------------------ | test-cis-2-12 | 5509768554764542647 | true | This is a test DNS policy to validate CIS Section 2.12 | false | dns#policy | [{"kind":"dns#policyNetwork","networkUrl":"http | test-cis-2-12-1 | 2440771815057052008 | false | | true | dns#policy | [{"kind":"dns#policyNetwork","networkUrl":"http +-----------------+---------------------+----------------+--------------------------------------------------------+---------------------------+------------+------------------------------------------------ > select * from gcp_dns_policy limit 1 +---------------+---------------------+----------------+--------------------------------------------------------+---------------------------+------------+-------------------------------------------------- | name | id | enable_logging | description | enable_inbound_forwarding | kind | networks +---------------+---------------------+----------------+--------------------------------------------------------+---------------------------+------------+-------------------------------------------------- | test-cis-2-12 | 5509768554764542647 | true | This is a test DNS policy to validate CIS Section 2.12 | false | dns#policy | [{"kind":"dns#policyNetwork","networkUrl":"https: +---------------+---------------------+----------------+--------------------------------------------------------+---------------------------+------------+-------------------------------------------------- ================================================================================ gcp_dns_record_set ==================== > select * from gcp_dns_record_set +-----------------------------+-------------------+------+-----------------------+----------------+------------------------------------------------------------------------------------------------+-------- | name | managed_zone_name | type | kind | routing_policy | rrdatas | signatu +-----------------------------+-------------------+------+-----------------------+----------------+------------------------------------------------------------------------------------------------+-------- | turbottest43995.turbot.com. | turbottest43995 | A | dns#resourceRecordSet | | ["10.0.0.1","10.1.0.1"] | [] | turbot.com. | turbottest43995 | SOA | dns#resourceRecordSet | | ["ns-gcp-private.googledomains.com. cloud-dns-hostmaster.google.com. 1 21600 3600 259200 300"] | [] | turbot.com. | turbottest43995 | NS | dns#resourceRecordSet | | ["ns-gcp-private.googledomains.com."] | [] +-----------------------------+-------------------+------+-----------------------+----------------+------------------------------------------------------------------------------------------------+-------- > select * from gcp_dns_record_set limit 1 +-------------+-------------------+------+-----------------------+----------------+---------------------------------------+-------------------+-------+-------------+--------------------------------------- | name | managed_zone_name | type | kind | routing_policy | rrdatas | signature_rrdatas | ttl | title | akas +-------------+-------------------+------+-----------------------+----------------+---------------------------------------+-------------------+-------+-------------+--------------------------------------- | turbot.com. | turbottest43995 | NS | dns#resourceRecordSet | | ["ns-gcp-private.googledomains.com."] | [] | 21600 | turbot.com. | ["gcp://dns.googleapis.com/projects/pa +-------------+-------------------+------+-----------------------+----------------+---------------------------------------+-------------------+-------+-------------+--------------------------------------- ================================================================================ gcp_kms_key ==================== > select * from gcp_kms_key limit 1 +----------------+---------------+----------------------------------------------------------------------------------------------------------------------------+---------------------------+----------------- | name | key_ring_name | self_link | create_time | purpose +----------------+---------------+----------------------------------------------------------------------------------------------------------------------------+---------------------------+----------------- | rupkey-test-01 | rup-test-01 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/asia-east1/keyRings/rup-test-01/cryptoKeys/rupkey-test-01 | 2019-06-13T13:11:37+05:30 | ENCRYPT_DECRYPT +----------------+---------------+----------------------------------------------------------------------------------------------------------------------------+---------------------------+----------------- > select * from gcp_kms_key where purpose = 'ENCRYPT_DECRYPT' and rotation_period = '7776000s' +-----------------+-------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------------+------------ | name | key_ring_name | self_link | create_time | purpose +-----------------+-------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------------+------------ | terraform-key | rup-test-01 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/asia-east1/keyRings/rup-test-01/cryptoKeys/terraform-key | 2019-10-23T15:43:40+05:30 | ENCRYPT_DEC | rupkey-test-01 | rup-test-01 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/asia-east1/keyRings/rup-test-01/cryptoKeys/rupkey-test-01 | 2019-06-13T13:11:37+05:30 | ENCRYPT_DEC | test-global-key | global-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/global-keyring/cryptoKeys/test-global-key | 2020-07-21T18:33:11+05:30 | ENCRYPT_DEC | gggg | test-vis-key-ring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/test-vis-key-ring/cryptoKeys/gggg | 2020-06-04T13:52:45+05:30 | ENCRYPT_DEC +-----------------+-------------------+----------------------------------------------------------------------------------------------------------------------------+---------------------------+------------ > select * from gcp_kms_key +------------------------------------+-----------------------------+---------------------------------------------------------------------------------------------------------------------------------------- | name | key_ring_name | self_link +------------------------------------+-----------------------------+---------------------------------------------------------------------------------------------------------------------------------------- | terraform-key | rup-test-01 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/asia-east1/keyRings/rup-test-01/cryptoKeys/terraform-key | rupkey-test-01 | rup-test-01 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/asia-east1/keyRings/rup-test-01/cryptoKeys/rupkey-test-01 | turbottest2239 | turbottest2239-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest2239-keyring/cryptoKeys/turbottest2239 | turbottest7744 | turbottest7744-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest7744-keyring/cryptoKeys/turbottest7744 | test1231234 | test1231234-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/test1231234-keyring/cryptoKeys/test1231234 | turbottest9231 | turbottest9231-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest9231-keyring/cryptoKeys/turbottest9231 | crypto-key-example-tf | keyring-example-tf | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/keyring-example-tf/cryptoKeys/crypto-key-example-tf | turbottest10417 | turbottest10417-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest10417-keyring/cryptoKeys/turbottest10417 | turbottest9650 | turbottest9650-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest9650-keyring/cryptoKeys/turbottest9650 | turbottest9864 | turbottest9864-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest9864-keyring/cryptoKeys/turbottest9864 | gggg | test-vis-key-ring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/test-vis-key-ring/cryptoKeys/gggg | crypto-key-example | keyring-example | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/keyring-example/cryptoKeys/crypto-key-example | turbottest73755 | turbottest73755 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest73755/cryptoKeys/turbottest73755 | turbottest15878 | turbottest15878 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest15878/cryptoKeys/turbottest15878 | user-supplied-key | keyring-example | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/keyring-example/cryptoKeys/user-supplied-key | turbottest84267 | turbottest84267 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest84267/cryptoKeys/turbottest84267 | test | test-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/test-keyring/cryptoKeys/test | turbottest31351 | turbottest31351-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/turbottest31351-keyring/cryptoKeys/turbottest31351 | test-global-key | global-keyring | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/global/keyRings/global-keyring/cryptoKeys/test-global-key | turbottest2118 | turbottest2118 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest2118/cryptoKeys/turbottest2118 | turbottest9589 | turbottest699 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest699/cryptoKeys/turbottest9589 | turbottest4047 | turbottest4047 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest4047/cryptoKeys/turbottest4047 | turbottest1143 | turbottest1143 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest1143/cryptoKeys/turbottest1143 | turbottest6659 | turbottest1550 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest1550/cryptoKeys/turbottest6659 | turbottest4863 | turbottest4863 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest4863/cryptoKeys/turbottest4863 | turbottest5479 | turbottest5479 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest5479/cryptoKeys/turbottest5479 | turbottest3885 | turbottest4047 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest4047/cryptoKeys/turbottest3885 | turbottest2542 | turbottest2542 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest2542/cryptoKeys/turbottest2542 | turbottest4477 | turbottest4477 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest4477/cryptoKeys/turbottest4477 | turbottest5795 | turbottest5795 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest5795/cryptoKeys/turbottest5795 | turbottest6460 | turbottest2097 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest2097/cryptoKeys/turbottest6460 | turbottest92625 | turbottest92625 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest92625/cryptoKeys/turbottest92625 | turbottest87245 | turbottest92625 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest92625/cryptoKeys/turbottest87245 | turbottest5651 | turbottest699 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest699/cryptoKeys/turbottest5651 | turbottest9366 | turbottest1550 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest1550/cryptoKeys/turbottest9366 | turbottest699 | turbottest699 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest699/cryptoKeys/turbottest699 | turbottest25817 | turbottest25817 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest25817/cryptoKeys/turbottest25817 | turbottest2097 | turbottest2097 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest2097/cryptoKeys/turbottest2097 | turbottest9740 | turbottest9740 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest9740/cryptoKeys/turbottest9740 | turbottest4331 | turbottest2869 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest2869/cryptoKeys/turbottest4331 | turbottest5005 | turbottest5005 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest5005/cryptoKeys/turbottest5005 | turbottest7719 | turbottest7719 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest7719/cryptoKeys/turbottest7719 | turbottest8223 | turbottest7719 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest7719/cryptoKeys/turbottest8223 | turbottest1666 | turbottest4047 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest4047/cryptoKeys/turbottest1666 | turbottest44586 | turbottest92625 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest92625/cryptoKeys/turbottest44586 | turbottest15480 | turbottest15480 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest15480/cryptoKeys/turbottest15480 | test-key-sayan-cis | test-key-ring-for-cis-sayan | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/test-key-ring-for-cis-sayan/cryptoKeys/test-key-saya | turbottest6138 | turbottest7719 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest7719/cryptoKeys/turbottest6138 | test1 | test1 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/test1/cryptoKeys/test1 | turbottest2869 | turbottest2869 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest2869/cryptoKeys/turbottest2869 | turbottest18166 | turbottest18166 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest18166/cryptoKeys/turbottest18166 | turbottest739 | turbottest739 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest739/cryptoKeys/turbottest739 | turbottest19134 | turbottest19134 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest19134/cryptoKeys/turbottest19134 | turbottest5866 | turbottest5866 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest5866/cryptoKeys/turbottest5866 | turbottest3959 | turbottest3959 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest3959/cryptoKeys/turbottest3959 | turbottest2872 | turbottest3959 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest3959/cryptoKeys/turbottest2872 | turbottest1550 | turbottest1550 | https://cloudkms.googleapis.com/v1/projects/parker-aaa/locations/us-east1/keyRings/turbottest1550/cryptoKeys/turbottest1550 ================================================================================ gcp_kms_key_ring ==================== > select * from gcp_kms_key_ring limit 1 +-------------+---------------------------+-----------------+-------------+-------------------------------------------------------------------------------------------------+------------+------------+ | name | create_time | iam_policy | title | akas | location | project | +-------------+---------------------------+-----------------+-------------+-------------------------------------------------------------------------------------------------+------------+------------+ | rup-test-01 | 2019-06-13T13:11:01+05:30 | {"etag":"ACAB"} | rup-test-01 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/asia-east1/keyRings/rup-test-01"] | asia-east1 | parker-aaa | +-------------+---------------------------+-----------------+-------------+-------------------------------------------------------------------------------------------------+------------+------------+ > select * from gcp_kms_key_ring +------------------------------------+---------------------------+-------------------------------------+------------------------------------+--------------------------------------------------------------- | name | create_time | iam_policy | title | akas +------------------------------------+---------------------------+-------------------------------------+------------------------------------+--------------------------------------------------------------- | rup-test-01 | 2019-06-13T13:11:01+05:30 | {"etag":"ACAB"} | rup-test-01 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | keyring-example-tf | 2020-09-30T19:07:19+05:30 | {"etag":"ACAB"} | keyring-example-tf | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest73755 | 2021-11-17T15:52:28+05:30 | {"etag":"ACAB"} | turbottest73755 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | global-ring-2 | 2020-07-21T19:02:23+05:30 | {"etag":"ACAB"} | global-ring-2 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test-keyring | 2020-03-13T18:58:41+05:30 | {"etag":"ACAB"} | test-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | keyring-example | 2020-03-12T12:22:50+05:30 | {"etag":"ACAB"} | keyring-example | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest9650-keyring | 2020-04-16T20:27:02+05:30 | {"etag":"ACAB"} | turbottest9650-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest16891 | 2022-01-11T19:25:51+05:30 | {"etag":"ACAB"} | turbottest16891 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest2239-keyring | 2020-03-13T18:51:57+05:30 | {"etag":"ACAB"} | turbottest2239-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest31351-keyring | 2020-03-13T18:55:16+05:30 | {"etag":"ACAB"} | turbottest31351-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest82111 | 2021-11-11T18:52:22+05:30 | {"etag":"BwXQgz2T+H4=","version":1} | turbottest82111 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | global-keyring | 2020-07-21T18:31:19+05:30 | {"etag":"ACAB"} | global-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest9231-keyring | 2020-03-13T19:01:22+05:30 | {"etag":"ACAB"} | turbottest9231-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest9864-keyring | 2020-03-20T20:46:39+05:30 | {"etag":"ACAB"} | turbottest9864-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test-sd-keyring | 2021-05-20T18:07:09+05:30 | {"etag":"ACAB"} | test-sd-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest7744-keyring | 2020-03-20T20:51:12+05:30 | {"etag":"ACAB"} | turbottest7744-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test1231234-keyring | 2020-03-13T18:59:28+05:30 | {"etag":"ACAB"} | test1231234-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest15878 | 2021-11-11T18:50:58+05:30 | {"etag":"ACAB"} | turbottest15878 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test-key-2 | 2020-07-27T12:29:29+05:30 | {"etag":"ACAB"} | test-key-2 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest84267 | 2021-11-18T14:01:38+05:30 | {"etag":"ACAB"} | turbottest84267 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest6361 | 2021-11-17T15:53:52+05:30 | {"etag":"BwXQ+XKo8So=","version":1} | turbottest6361 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest10417-keyring | 2020-03-13T18:57:24+05:30 | {"etag":"ACAB"} | turbottest10417-keyring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbot-test-20200125-create-update | 2020-02-13T17:52:20+05:30 | {"etag":"ACAB"} | turbot-test-20200125-create-update | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest15480 | 2020-02-17T15:29:13+05:30 | {"etag":"ACAB"} | turbottest15480 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | vishal | 2020-08-17T23:12:15+05:30 | {"etag":"ACAB"} | vishal | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest2869 | 2020-04-13T18:18:48+05:30 | {"etag":"ACAB"} | turbottest2869 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest2103 | 2020-04-13T15:53:33+05:30 | {"etag":"ACAB"} | turbottest2103 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test-key-ring-for-cis-sayan | 2019-06-17T13:21:52+05:30 | {"etag":"ACAB"} | test-key-ring-for-cis-sayan | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest19134 | 2020-02-17T15:35:09+05:30 | {"etag":"ACAB"} | turbottest19134 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest18166 | 2020-02-17T15:20:00+05:30 | {"etag":"ACAB"} | turbottest18166 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest7719 | 2020-04-13T16:48:34+05:30 | {"etag":"ACAB"} | turbottest7719 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test-ring | 2020-01-14T17:15:08+05:30 | {"etag":"ACAB"} | test-ring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest2542 | 2020-06-08T18:38:04+05:30 | {"etag":"ACAB"} | turbottest2542 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | testing1 | 2020-02-13T19:35:19+05:30 | {"etag":"ACAB"} | testing1 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest92625 | 2020-12-03T16:21:37+05:30 | {"etag":"ACAB"} | turbottest92625 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest8101 | 2021-02-02T17:58:18+05:30 | {"etag":"ACAB"} | turbottest8101 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest1701 | 2020-06-04T13:47:12+05:30 | {"etag":"ACAB"} | turbottest1701 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest9588 | 2020-06-04T15:22:09+05:30 | {"etag":"ACAB"} | turbottest9588 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest3642 | 2020-06-08T18:11:02+05:30 | {"etag":"ACAB"} | turbottest3642 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test1 | 2020-02-13T18:28:03+05:30 | {"etag":"ACAB"} | test1 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest6336 | 2021-02-02T18:25:57+05:30 | {"etag":"ACAB"} | turbottest6336 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest1550 | 2020-04-13T18:05:59+05:30 | {"etag":"ACAB"} | turbottest1550 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | test-vis-key-ring | 2020-06-04T13:52:11+05:30 | {"etag":"ACAB"} | test-vis-key-ring | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest25817 | 2020-08-10T16:26:45+05:30 | {"etag":"ACAB"} | turbottest25817 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest4047 | 2020-04-13T17:04:21+05:30 | {"etag":"ACAB"} | turbottest4047 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest4714 | 2020-04-13T15:53:33+05:30 | {"etag":"ACAB"} | turbottest4714 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest739 | 2021-02-02T17:58:14+05:30 | {"etag":"ACAB"} | turbottest739 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest5866 | 2021-02-02T17:58:01+05:30 | {"etag":"ACAB"} | turbottest5866 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest7 | 2020-02-13T18:44:30+05:30 | {"etag":"ACAB"} | turbottest7 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest5763 | 2020-04-13T15:53:33+05:30 | {"etag":"ACAB"} | turbottest5763 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest9180 | 2020-06-08T17:59:07+05:30 | {"etag":"ACAB"} | turbottest9180 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest4448 | 2020-06-04T14:08:32+05:30 | {"etag":"ACAB"} | turbottest4448 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest2118 | 2020-04-23T13:05:43+05:30 | {"etag":"ACAB"} | turbottest2118 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest688 | 2020-06-04T13:22:24+05:30 | {"etag":"ACAB"} | turbottest688 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest9740 | 2020-06-08T18:40:59+05:30 | {"etag":"ACAB"} | turbottest9740 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest699 | 2020-05-27T20:58:30+05:30 | {"etag":"ACAB"} | turbottest699 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ | turbottest2097 | 2020-04-13T18:12:03+05:30 | {"etag":"ACAB"} | turbottest2097 | ["gcp://cloudkms.googleapis.com/projects/parker-aaa/locations/ ================================================================================ gcp_logging_bucket ==================== > select * from gcp_logging_bucket limit 1 +----------+-----------------------------------------------------------------------------------------+-------------+----------------+-----------------+--------+----------------+-------------+----------+-- | name | self_link | create_time | description | lifecycle_state | locked | retention_days | update_time | title | a +----------+-----------------------------------------------------------------------------------------+-------------+----------------+-----------------+--------+----------------+-------------+----------+-- | _Default | https://logging.googleapis.com/v2/projects/parker-aaa/locations/global/buckets/_Default | | Default bucket | ACTIVE | false | 30 | | _Default | [ +----------+-----------------------------------------------------------------------------------------+-------------+----------------+-----------------+--------+----------------+-------------+----------+-- > select * from gcp_logging_bucket +-----------------+-----------------------------------------------------------------------------------------------------+---------------------------+----------------+-----------------+--------+----------- | name | self_link | create_time | description | lifecycle_state | locked | retention_ +-----------------+-----------------------------------------------------------------------------------------------------+---------------------------+----------------+-----------------+--------+----------- | _Default | https://logging.googleapis.com/v2/projects/parker-aaa/locations/global/buckets/_Default | | Default bucket | ACTIVE | false | 30 | _Required | https://logging.googleapis.com/v2/projects/parker-aaa/locations/global/buckets/_Required | | Audit bucket | ACTIVE | true | 400 | turbottest54066 | https://logging.googleapis.com/v2/projects/parker-aaa/locations/us-east1/buckets/turbottest54066 | 2021-11-11T19:15:46+05:30 | | ACTIVE | false | 1 | test-bucket | https://logging.googleapis.com/v2/projects/parker-aaa/locations/asia-southeast1/buckets/test-bucket | 2021-05-13T06:54:07+05:30 | | ACTIVE | false | 1 | turbottest99619 | https://logging.googleapis.com/v2/projects/parker-aaa/locations/us-east1/buckets/turbottest99619 | 2021-11-17T16:19:49+05:30 | | ACTIVE | false | 1 +-----------------+-----------------------------------------------------------------------------------------------------+---------------------------+----------------+-----------------+--------+----------- ================================================================================ gcp_logging_exclusion ==================== > select * from gcp_logging_exclusion +------------------------------------+----------+----------------------------------------------------+---------------------------------+---------------------------+---------------------------+------------ | name | disabled | filter | description | create_time | update_time | title +------------------------------------+----------+----------------------------------------------------+---------------------------------+---------------------------+---------------------------+------------ | turbot-test-20191203-create-update | false | resource.type = gce_instance AND severity <= DEBUG | Exclude GCE instance debug logs | 2020-01-06T11:52:55+05:30 | 2020-01-06T11:52:55+05:30 | turbot-test +------------------------------------+----------+----------------------------------------------------+---------------------------------+---------------------------+---------------------------+------------ > select * from gcp_logging_exclusion limit 1 +------------------------------------+----------+----------------------------------------------------+---------------------------------+---------------------------+---------------------------+------------ | name | disabled | filter | description | create_time | update_time | title +------------------------------------+----------+----------------------------------------------------+---------------------------------+---------------------------+---------------------------+------------ | turbot-test-20191203-create-update | false | resource.type = gce_instance AND severity <= DEBUG | Exclude GCE instance debug logs | 2020-01-06T11:52:55+05:30 | 2020-01-06T11:52:55+05:30 | turbot-test +------------------------------------+----------+----------------------------------------------------+---------------------------------+---------------------------+---------------------------+------------ ================================================================================ gcp_logging_metric ==================== > select * from gcp_logging_metric +---------------+----------------------------------------------------------------------------------------------------+---------+---------------------------------------------------------------------------- | name | description | version | filter +---------------+----------------------------------------------------------------------------------------------------+---------+---------------------------------------------------------------------------- | gcp-cis-2.4 | gcp-cis-2.4 | | (protoPayload.serviceName="cloudresourcemanager.googleapis.com") | | | | AND (ProjectOwnership OR projectOwnerInvitee) | | | | OR (protoPayload.serviceData.policyDelta.bindingDeltas.action="REMOVE" | | | | AND protoPayload.serviceData.policyDelta.bindingDeltas.role="roles/owner") | | | | OR (protoPayload.serviceData.policyDelta.bindingDeltas.action="ADD" | | | | AND protoPayload.serviceData.policyDelta.bindingDeltas.role="roles/owner") | cis2.8 | 2.8 Ensure that the log metric filter and alerts exist for VPC network route changes (Automated) | | resource.type="gce_route" | | | | AND protoPayload.methodName="beta.compute.routes.patch" | | | | OR protoPayload.methodName="beta.compute.routes.insert" | cis2.9 | | | resource.type=gce_network | | | | AND protoPayload.methodName="beta.compute.networks.insert" | | | | OR protoPayload.methodName="beta.compute.networks.patch" | | | | OR protoPayload.methodName="v1.compute.networks.delete" | | | | OR protoPayload.methodName="v1.compute.networks.removePeering" | | | | OR protoPayload.methodName="v1.compute.networks.addPeering" | cis-2.5 | 2.5 Ensure that the log metric filter and alerts exist for Audit Configuration changes (Automated) | | protoPayload.methodName="SetIamPolicy" AND protoPayload.serviceData.policyD | cis2.7-metric | | | resource.type="gce_firewall_rule" | | | | AND protoPayload.methodName="v1.compute.firewalls.patch" | | | | OR protoPayload.methodName="v1.compute.firewalls.insert" | cis2.6 | 2.6 Ensure that the log metric filter and alerts exist for Custom Role changes (Automated) | | resource.type="iam_role" | | | | AND protoPayload.methodName = "google.iam.admin.v1.CreateRole" | | | | OR protoPayload.methodName="google.iam.admin.v1.DeleteRole" | | | | OR protoPayload.methodName="google.iam.admin.v1.UpdateRole" +---------------+----------------------------------------------------------------------------------------------------+---------+---------------------------------------------------------------------------- > select * from gcp_logging_metric limit 1 +---------+----------------------------------------------------------------------------------------------------+---------+---------------------------------------------------------------------------------- | name | description | version | filter +---------+----------------------------------------------------------------------------------------------------+---------+---------------------------------------------------------------------------------- | cis-2.5 | 2.5 Ensure that the log metric filter and alerts exist for Audit Configuration changes (Automated) | | protoPayload.methodName="SetIamPolicy" AND protoPayload.serviceData.policyDelta.a +---------+----------------------------------------------------------------------------------------------------+---------+---------------------------------------------------------------------------------- ================================================================================ gcp_logging_sink ==================== > select * from gcp_logging_sink +-----------+-------------------------------------------------------------------------------+----------+---------------------------------------------------------------------------------------------------- | name | destination | disabled | filter +-----------+-------------------------------------------------------------------------------+----------+---------------------------------------------------------------------------------------------------- | _Required | logging.googleapis.com/projects/parker-aaa/locations/global/buckets/_Required | false | LOG_ID("cloudaudit.googleapis.com/activity") OR LOG_ID("externalaudit.googleapis.com/activity") OR | _Default | logging.googleapis.com/projects/parker-aaa/locations/global/buckets/_Default | false | NOT LOG_ID(cloudaudit.googleapis.com/activity) AND NOT LOG_ID(externalaudit.googleapis.com/activity +-----------+-------------------------------------------------------------------------------+----------+---------------------------------------------------------------------------------------------------- > select * from gcp_logging_sink limit 1 +----------+------------------------------------------------------------------------------+----------+------------------------------------------------------------------------------------------------------ | name | destination | disabled | filter +----------+------------------------------------------------------------------------------+----------+------------------------------------------------------------------------------------------------------ | _Default | logging.googleapis.com/projects/parker-aaa/locations/global/buckets/_Default | false | NOT LOG_ID(cloudaudit.googleapis.com/activity) AND NOT LOG_ID(externalaudit.googleapis.com/activity) +----------+------------------------------------------------------------------------------+----------+------------------------------------------------------------------------------------------------------ ================================================================================ gcp_monitoring_alert_policy =========================== > select * from gcp_monitoring_alert_policy +-----------------+----------------------+---------+----------+------------------------------------------------------------------------------+-------------------------------------------------------------- | display_name | name | enabled | combiner | creation_record | mutation_record +-----------------+----------------------+---------+----------+------------------------------------------------------------------------------+-------------------------------------------------------------- | cis2.7-alert | 1583873099681945207 | true | OR | {"mutateTime":"2021-05-15T15:03:44.186323472Z","mutatedBy":"raj@turbot.com"} | {"mutateTime":"2021-05-15T15:03:44.186323472Z","mutatedBy":"r | cis2.6-filter | 17658769092103684583 | true | OR | {"mutateTime":"2021-05-15T12:39:59.948676263Z","mutatedBy":"raj@turbot.com"} | {"mutateTime":"2021-05-15T12:39:59.948676263Z","mutatedBy":"r | turbottest58144 | 11004853477619364497 | true | OR | {"mutateTime":"2020-11-23T14:09:45.741720012Z"} | {"mutateTime":"2020-11-23T14:09:45.741720012Z"} | cis-2.5-alert | 8765772076175077933 | true | OR | {"mutateTime":"2021-05-15T06:00:32.825022742Z","mutatedBy":"raj@turbot.com"} | {"mutateTime":"2021-05-15T12:53:26.340507372Z","mutatedBy":"r | cis2.8-alert | 15803603717835906324 | true | OR | {"mutateTime":"2021-05-15T15:38:07.196578108Z","mutatedBy":"raj@turbot.com"} | {"mutateTime":"2021-05-15T15:38:07.196578108Z","mutatedBy":"r | cis2.4-alert | 9838409437308076354 | true | OR | {"mutateTime":"2021-05-14T17:01:34.711493574Z","mutatedBy":"raj@turbot.com"} | {"mutateTime":"2021-05-14T17:01:34.711493574Z","mutatedBy":"r +-----------------+----------------------+---------+----------+------------------------------------------------------------------------------+-------------------------------------------------------------- > select * from gcp_monitoring_alert_policy limit 1 +-----------------+----------------------+---------+----------+-------------------------------------------------+-------------------------------------------------+----------------------------------------- | display_name | name | enabled | combiner | creation_record | mutation_record | conditions +-----------------+----------------------+---------+----------+-------------------------------------------------+-------------------------------------------------+----------------------------------------- | turbottest58144 | 11004853477619364497 | true | OR | {"mutateTime":"2020-11-23T14:09:45.741720012Z"} | {"mutateTime":"2020-11-23T14:09:45.741720012Z"} | [{"conditionThreshold":{"aggregations":[ +-----------------+----------------------+---------+----------+-------------------------------------------------+-------------------------------------------------+----------------------------------------- > select * from gcp_monitoring_alert_policy where display_name = 'cis2.7-alert' and enabled +--------------+---------------------+---------+----------+------------------------------------------------------------------------------+------------------------------------------------------------------ | display_name | name | enabled | combiner | creation_record | mutation_record +--------------+---------------------+---------+----------+------------------------------------------------------------------------------+------------------------------------------------------------------ | cis2.7-alert | 1583873099681945207 | true | OR | {"mutateTime":"2021-05-15T15:03:44.186323472Z","mutatedBy":"raj@turbot.com"} | {"mutateTime":"2021-05-15T15:03:44.186323472Z","mutatedBy":"raj@t +--------------+---------------------+---------+----------+------------------------------------------------------------------------------+------------------------------------------------------------------ ================================================================================ gcp_monitoring_group ==================== > select * from gcp_monitoring_group +---------------------+-----------------------+-----------------------------------------+------------+------------------------------------------------+-----------------------+----------------------------- | name | display_name | filter | is_cluster | parent_name | title | akas +---------------------+-----------------------+-----------------------------------------+------------+------------------------------------------------+-----------------------+----------------------------- | 7791011831683544752 | parent-turbottest8265 | resource.metadata.region="europe-west2" | false | | parent-turbottest8265 | ["gcp://monitoring.googleapi | 6276181281705315087 | turbottest8265 | resource.metadata.region="europe-west2" | false | projects/parker-aaa/groups/7791011831683544752 | turbottest8265 | ["gcp://monitoring.googleapi +---------------------+-----------------------+-----------------------------------------+------------+------------------------------------------------+-----------------------+----------------------------- > select * from gcp_monitoring_group limit 1 +---------------------+----------------+-----------------------------------------+------------+------------------------------------------------+----------------+------------------------------------------- | name | display_name | filter | is_cluster | parent_name | title | akas +---------------------+----------------+-----------------------------------------+------------+------------------------------------------------+----------------+------------------------------------------- | 6276181281705315087 | turbottest8265 | resource.metadata.region="europe-west2" | false | projects/parker-aaa/groups/7791011831683544752 | turbottest8265 | ["gcp://monitoring.googleapis.com/projects +---------------------+----------------+-----------------------------------------+------------+------------------------------------------------+----------------+------------------------------------------- ================================================================================ gcp_monitoring_notification_channel =================================== > select * from gcp_monitoring_notification_channel +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ | name | display_name | enabled | self_link | type | description | verification_stat +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ | 16920131774968342739 | cis2.6-filter-notofication | true | https://monitoring.googleapis.com/v3/projects/parker-aaa/notificationChannels/16920131774968342739 | email | | +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ > select * from gcp_monitoring_notification_channel limit 1 +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ | name | display_name | enabled | self_link | type | description | verification_stat +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ | 16920131774968342739 | cis2.6-filter-notofication | true | https://monitoring.googleapis.com/v3/projects/parker-aaa/notificationChannels/16920131774968342739 | email | | +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ > select * from gcp_monitoring_notification_channel where display_name = 'cis2.6-filter-notofication' and type = 'email' +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ | name | display_name | enabled | self_link | type | description | verification_stat +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ | 16920131774968342739 | cis2.6-filter-notofication | true | https://monitoring.googleapis.com/v3/projects/parker-aaa/notificationChannels/16920131774968342739 | email | | +----------------------+----------------------------+---------+----------------------------------------------------------------------------------------------------+-------+-------------+------------------ ================================================================================ gcp_project_organization_policy ================================ > select * from gcp_project_organization_policy +----------------------------+---------------------------+---------+------------------+------------------------------------------------+----------------+-----------------+----------------------------+---- | id | update_time | version | etag | list_policy | boolean_policy | restore_default | title | aka +----------------------------+---------------------------+---------+------------------+------------------------------------------------+----------------+-----------------+----------------------------+---- | compute.vmExternalIpAccess | 2020-09-15T13:55:19+05:30 | 0 | CO/0gfsFEIDq7pIB | {"allValues":"ALLOW","inheritFromParent":true} | | | compute.vmExternalIpAccess | ["g +----------------------------+---------------------------+---------+------------------+------------------------------------------------+----------------+-----------------+----------------------------+---- > select * from gcp_project_organization_policy limit 1 +----------------------------+---------------------------+---------+------------------+------------------------------------------------+----------------+-----------------+----------------------------+---- | id | update_time | version | etag | list_policy | boolean_policy | restore_default | title | aka +----------------------------+---------------------------+---------+------------------+------------------------------------------------+----------------+-----------------+----------------------------+---- | compute.vmExternalIpAccess | 2020-09-15T13:55:19+05:30 | 0 | CO/0gfsFEIDq7pIB | {"allValues":"ALLOW","inheritFromParent":true} | | | compute.vmExternalIpAccess | ["g +----------------------------+---------------------------+---------+------------------+------------------------------------------------+----------------+-----------------+----------------------------+---- ================================================================================ gcp_project_service ==================== > select * from gcp_project_service +-----------------------------------------------------------------------------------------------------+----------+-----------------------+------------------------------------------------------------------ | name | state | parent | akas +-----------------------------------------------------------------------------------------------------+----------+-----------------------+------------------------------------------------------------------ | androidcheck.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | admin.googleapis.com | ENABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexchangeseller.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | aiplatform.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | aiui.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | admob.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | abilitec-api.endpoints.liveramp-identity-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexchangebuyer-json.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | alertcenter.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adsense.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adsensehost.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexchangebuyer.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | abusiveexperiencereport.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | amwell-now.endpoints.amwell-marketplace-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | aelf-enterprise-aelf-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analyticsadmin.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analyticsreporting.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analytics.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexperiencereport.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | actions.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | accessapproval.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analyticsdata.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | accesscontextmanager.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | acceleratedmobilepageurl.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | apigeeconnect.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | actian-avalanche-hybrid-cloud-data-warehouse.endpoints.actian-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | anthosidentityservice.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | apache-kafka-on-confluent-cloud.endpoints.confluent-isaas.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | apigee-drupal-devportal-bap-marketplace.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androiddeviceprovisioning.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | apigateway.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androidpublisher.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | apigee.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | activtrak-public.endpoints.activtrak-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androidenterprise.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | anthosconfigmanagement.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | anthos.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | anthosaudit.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | anthosgke.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androidmanagement.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | authorizedbuyersmarketplace.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androidovertheair.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | arcorecloudanchor.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appspace-byol-appspace-saas.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appengine.googleapis.com | ENABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | area120tables.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | chromewebstore.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | armorblox-email-protection.endpoints.armorblox-partner-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | apikeys.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appengineflex.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | array-networks-vapv-byol-arraynetworks-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | calendar-json.googleapis.com | ENABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | automation-360-bot-agent.endpoints.automationanywhere-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | bookstore.endpoints.endpoints-portal-demo.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | app-int-for-gcp-whiteops-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appgate-sdp-appgate-sdp-marketplace-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | carddav.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service > select * from gcp_project_service limit 1 +------------------------------------------------------------+----------+-----------------------+----------------------------------------------------------------------------------------------------------- | name | state | parent | akas +------------------------------------------------------------+----------+-----------------------+----------------------------------------------------------------------------------------------------------- | abilitec-api.endpoints.liveramp-identity-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/services/abilitec-api.endpoints.liveramp-identit +------------------------------------------------------------+----------+-----------------------+----------------------------------------------------------------------------------------------------------- > select * from gcp_project_service where state = 'DISABLED' +-----------------------------------------------------------------------------------------------------+----------+-----------------------+------------------------------------------------------------------ | name | state | parent | akas +-----------------------------------------------------------------------------------------------------+----------+-----------------------+------------------------------------------------------------------ | abilitec-api.endpoints.liveramp-identity-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | acceleratedmobilepageurl.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexchangebuyer-json.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | actian-avalanche-hybrid-cloud-data-warehouse.endpoints.actian-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | actions.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | accessapproval.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | abusiveexperiencereport.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | activtrak-public.endpoints.activtrak-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | accesscontextmanager.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexchangebuyer.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adsensehost.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexchangeseller.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | admob.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adexperiencereport.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | adsense.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appengineflex.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | amwell-now.endpoints.amwell-marketplace-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | automation-360-bot-agent.endpoints.automationanywhere-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | axi-ai-forecast-ml-axiai-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appgate-sdp-appgate-sdp-marketplace-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | aelf-enterprise-aelf-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appsmarket-component.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appdevelopmentexperience.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | cloudbilling.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | aiplatform.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analytics.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appsmarket.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | ciam.endpoints.reachfive-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | automation-360.endpoints.automationanywhere-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | chromewebstore.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | aiui.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | appspace-byol-appspace-saas.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analyticsadmin.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | autoscaling.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | citrix-virtual-apps-and-desktop-standard-for-gcp.endpoints.citrix-master-project.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | alertcenter.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | arcorecloudanchor.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analyticsdata.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | axi-ai-axiai-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | axi-ai-sap-easyconnect-plus-axiai-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | area120tables.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | analyticsreporting.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | civicinfo.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | baremetalsolution.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | assuredworkloads.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androidcheck.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | asr.endpoints.knowlarity-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | bespoken-automated-testing-for-voice-and-chat.endpoints.bespoken-ivr-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androiddeviceprovisioning.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | audit.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | class4-v6-denovolab-public-260121.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | authorizedbuyersmarketplace.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | androidenterprise.googleapis.com | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | bettercloud1.endpoints.bettercloud-marketplace-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | armorblox-email-protection.endpoints.armorblox-partner-public.cloud.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | class4v5-1-denovolab-public-260121.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service | array-networks-vapv-byol-arraynetworks-public.cloudpartnerservices.goog | DISABLED | projects/979620418102 | ["gcp://serviceusage.googleapis.com/projects/979620418102/service ================================================================================ gcp_pubsub_subscription ======================= > select * from gcp_pubsub_subscription +-----------------+--------------------------------------------+-----------------+------------------------------------------------------------------------------------+--------+----------------------+----- | name | topic | topic_name | self_link | filter | ack_deadline_seconds | mess +-----------------+--------------------------------------------+-----------------+------------------------------------------------------------------------------------+--------+----------------------+----- | turbottest70800 | projects/parker-aaa/topics/turbottest70800 | turbottest70800 | https://pubsub.googleapis.com/v1/projects/parker-aaa/subscriptions/turbottest70800 | | 20 | 6048 +-----------------+--------------------------------------------+-----------------+------------------------------------------------------------------------------------+--------+----------------------+----- > select * from gcp_pubsub_subscription limit 1 +-----------------+--------------------------------------------+-----------------+------------------------------------------------------------------------------------+--------+----------------------+----- | name | topic | topic_name | self_link | filter | ack_deadline_seconds | mess +-----------------+--------------------------------------------+-----------------+------------------------------------------------------------------------------------+--------+----------------------+----- | turbottest70800 | projects/parker-aaa/topics/turbottest70800 | turbottest70800 | https://pubsub.googleapis.com/v1/projects/parker-aaa/subscriptions/turbottest70800 | | 20 | 6048 +-----------------+--------------------------------------------+-----------------+------------------------------------------------------------------------------------+--------+----------------------+----- ================================================================================ gcp_pubsub_topic ==================== > select * from gcp_pubsub_topic +----------------------------------------+--------------+----------------------------------------------------------------------------------------------------+---------------------------------------------- | name | kms_key_name | self_link | message_storage_policy_allowed_persistence_re +----------------------------------------+--------------+----------------------------------------------------------------------------------------------------+---------------------------------------------- | container-analysis-occurrences-v1beta1 | | https://pubsub.googleapis.com/v1/projects/parker-aaa/topics/container-analysis-occurrences-v1beta1 | | container-analysis-notes-v1 | | https://pubsub.googleapis.com/v1/projects/parker-aaa/topics/container-analysis-notes-v1 | | cloud-builds | | https://pubsub.googleapis.com/v1/projects/parker-aaa/topics/cloud-builds | | container-analysis-occurrences-v1 | | https://pubsub.googleapis.com/v1/projects/parker-aaa/topics/container-analysis-occurrences-v1 | | container-analysis-notes-v1beta1 | | https://pubsub.googleapis.com/v1/projects/parker-aaa/topics/container-analysis-notes-v1beta1 | +----------------------------------------+--------------+----------------------------------------------------------------------------------------------------+---------------------------------------------- > select * from gcp_pubsub_topic limit 1 +--------------+--------------+--------------------------------------------------------------------------+----------------------------------------------------+-------------------------------------+------- | name | kms_key_name | self_link | message_storage_policy_allowed_persistence_regions | iam_policy | labels +--------------+--------------+--------------------------------------------------------------------------+----------------------------------------------------+-------------------------------------+------- | cloud-builds | | https://pubsub.googleapis.com/v1/projects/parker-aaa/topics/cloud-builds | | {"etag":"BwWsSVe4Qc4=","version":1} | +--------------+--------------+--------------------------------------------------------------------------+----------------------------------------------------+-------------------------------------+------- ================================================================================ gcp_service_account ==================== > select * from gcp_service_account +-------------------------------------------------------------+-------------------------------------------------------------+-----------------------+----------------------------------------+----------+--- | name | email | unique_id | display_name | disabled | de +-------------------------------------------------------------+-------------------------------------------------------------+-----------------------+----------------------------------------+----------+--- | rahul-testing-account@parker-aaa.iam.gserviceaccount.com | rahul-testing-account@parker-aaa.iam.gserviceaccount.com | 107433534847948452612 | rahul-testing-account | false | Th | dataflow-service-account@parker-aaa.iam.gserviceaccount.com | dataflow-service-account@parker-aaa.iam.gserviceaccount.com | 109363392157647963122 | dataflow-service-account | false | te | 979620418102-compute@developer.gserviceaccount.com | 979620418102-compute@developer.gserviceaccount.com | 109092542338687105798 | Compute Engine default service account | false | | parker-aaa@appspot.gserviceaccount.com | parker-aaa@appspot.gserviceaccount.com | 109440621885192947873 | App Engine default service account | false | | turbottest48562@parker-aaa.iam.gserviceaccount.com | turbottest48562@parker-aaa.iam.gserviceaccount.com | 106885831083860298523 | turbottest48562 | false | Te | abhiclitest@parker-aaa.iam.gserviceaccount.com | abhiclitest@parker-aaa.iam.gserviceaccount.com | 108860096680805583404 | abhiclitest | false | | firebase-adminsdk-4po92@parker-aaa.iam.gserviceaccount.com | firebase-adminsdk-4po92@parker-aaa.iam.gserviceaccount.com | 103530887924012028621 | firebase-adminsdk | false | Fi | test-google-workspace@parker-aaa.iam.gserviceaccount.com | test-google-workspace@parker-aaa.iam.gserviceaccount.com | 105963861981309716942 | test-google-workspace | false | Te | test-speech@parker-aaa.iam.gserviceaccount.com | test-speech@parker-aaa.iam.gserviceaccount.com | 107627247931496820381 | test_speech | false | | turbot-owner@parker-aaa.iam.gserviceaccount.com | turbot-owner@parker-aaa.iam.gserviceaccount.com | 113447564492259563588 | turbot-owner | false | | turbottest53827@parker-aaa.iam.gserviceaccount.com | turbottest53827@parker-aaa.iam.gserviceaccount.com | 113129113180138243267 | turbottest53827 | false | | arnab-parker@parker-aaa.iam.gserviceaccount.com | arnab-parker@parker-aaa.iam.gserviceaccount.com | 101248615784247917931 | arnab@parker | false | Th | gcp-cis-test@parker-aaa.iam.gserviceaccount.com | gcp-cis-test@parker-aaa.iam.gserviceaccount.com | 116305807713533576270 | gcp-cis-test | false | us | abhyudaya@parker-aaa.iam.gserviceaccount.com | abhyudaya@parker-aaa.iam.gserviceaccount.com | 102949823250572324444 | abhyudaya | false | +-------------------------------------------------------------+-------------------------------------------------------------+-----------------------+----------------------------------------+----------+--- > select * from gcp_service_account limit 1 +----------------------------------------------------+----------------------------------------------------+-----------------------+-----------------+----------+------------------------------------------+- | name | email | unique_id | display_name | disabled | description | +----------------------------------------------------+----------------------------------------------------+-----------------------+-----------------+----------+------------------------------------------+- | turbottest48562@parker-aaa.iam.gserviceaccount.com | turbottest48562@parker-aaa.iam.gserviceaccount.com | 106885831083860298523 | turbottest48562 | false | Test service account to verify the table | +----------------------------------------------------+----------------------------------------------------+-----------------------+-----------------+----------+------------------------------------------+ ================================================================================ gcp_sql_backup ==================== > select * from gcp_sql_backup limit 1 +---------------+-----------------+---------------+-------------+------------+---------------------------+---------------------------+---------------------------+---------------------------+-------------- | id | instance_name | kind | description | status | end_time | enqueued_time | start_time | window_start_time | self_link +---------------+-----------------+---------------+-------------+------------+---------------------------+---------------------------+---------------------------+---------------------------+-------------- | 1641915833034 | turbottest90190 | sql#backupRun | | SUCCESSFUL | 2022-01-11T21:14:33+05:30 | 2022-01-11T21:13:53+05:30 | 2022-01-11T21:13:53+05:30 | 2022-01-11T21:13:53+05:30 | https://sqlad +---------------+-----------------+---------------+-------------+------------+---------------------------+---------------------------+---------------------------+---------------------------+-------------- > select * from gcp_sql_backup +---------------+-----------------+---------------+-------------+------------+---------------------------+---------------------------+---------------------------+---------------------------+-------------- | id | instance_name | kind | description | status | end_time | enqueued_time | start_time | window_start_time | self_link +---------------+-----------------+---------------+-------------+------------+---------------------------+---------------------------+---------------------------+---------------------------+-------------- | 1641915833034 | turbottest90190 | sql#backupRun | | SUCCESSFUL | 2022-01-11T21:14:33+05:30 | 2022-01-11T21:13:53+05:30 | 2022-01-11T21:13:53+05:30 | 2022-01-11T21:13:53+05:30 | https://sqlad +---------------+-----------------+---------------+-------------+------------+---------------------------+---------------------------+---------------------------+---------------------------+-------------- ================================================================================ gcp_sql_database_instance ========================== > select * from gcp_sql_database_instance where instance_type = 'CLOUD_SQL_INSTANCE' and state = 'RUNNABLE' and database_version = 'MYSQL_5_6' and backend_type = 'SECOND_GEN' and gce_zone = 'us-east1-d' +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- | name | state | instance_type | database_version | machine_type | data_disk_type | data_disk_size_gb | storage_auto_resize | enable_point_in_time_recovery | binary_log_enabled | kind +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- | turbottest10920 | RUNNABLE | CLOUD_SQL_INSTANCE | MYSQL_5_6 | db-f1-micro | PD_HDD | 10 | true | false | false | sql#in | | | | | | | | | | | +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- > select * from gcp_sql_database_instance +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- | name | state | instance_type | database_version | machine_type | data_disk_type | data_disk_size_gb | storage_auto_resize | enable_point_in_time_recovery | binary_log_enabled | kind +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- | turbottest10920 | RUNNABLE | CLOUD_SQL_INSTANCE | MYSQL_5_6 | db-f1-micro | PD_HDD | 10 | true | false | false | sql#in | | | | | | | | | | | +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- > select * from gcp_sql_database_instance limit 1 +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- | name | state | instance_type | database_version | machine_type | data_disk_type | data_disk_size_gb | storage_auto_resize | enable_point_in_time_recovery | binary_log_enabled | kind +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- | turbottest10920 | RUNNABLE | CLOUD_SQL_INSTANCE | MYSQL_5_6 | db-f1-micro | PD_HDD | 10 | true | false | false | sql#in | | | | | | | | | | | +-----------------+----------+--------------------+------------------+--------------+----------------+-------------------+---------------------+-------------------------------+--------------------+------- ================================================================================