Add table gcp_compute_machine_images

[roboticpuppies]

Hello. Currently, there is no table that contains Machine Images in GCP. Machine Images is similar to AMI (Amazon Machine Images) in AWS.

References

• Compute Docs - Machine Images
• REST Resource: machineImages

[ParthaI]

Thank you, @roboticpuppies, for bringing this issue to our attention. Your involvement with Steampipe is greatly valued.

I've submitted a PR addressing this issue. If you would like to test it on the PR branch (issue-517). Here are the steps to do so:

1. Clone the repository: git clone https://github.com/turbot/steampipe-plugin-gcp.git
2. Navigate to the directory: cd steampipe-plugin-gcp
3. Switch to the issue-517 branch: git checkout issue-517
4. Build the project: make
5. Execute the query: select * from gcp_compute_machine_image

Additionally, There is another table, gcp_compute_machine_type, which might be useful for you. It allows you to find available machine types per zone in a project.

FYI, here is the query to get the Machine Type details for Machine Images:

> select
  i.name as image_name,
  i.id image_id,
  i.instance_properties ->> 'machineType' as machine_type,
  t.creation_timestamp as machine_type_creation_timestamp,
  t.memory_mb as machine_type_memory_mb,
  t.maximum_persistent_disks as machine_type_maximum_persistent_disks,
  t.is_shared_cpu as machine_type_is_shared_cpu,
  t.zone as machine_type_zone,
  t.deprecated as machine_type_deprecated
from
  gcp_compute_machine_image as i,
  gcp_compute_machine_type as t
where
  t.name = (i.instance_properties ->> 'machineType') and t.zone = split_part(i.source_instance, '/', 9);
+-----------------+---------------------+--------------+---------------------------------+------------------------+---------------------------------------+----------------------------+-------------------+-------------------------+
| image_name      | image_id            | machine_type | machine_type_creation_timestamp | machine_type_memory_mb | machine_type_maximum_persistent_disks | machine_type_is_shared_cpu | machine_type_zone | machine_type_deprecated |
+-----------------+---------------------+--------------+---------------------------------+------------------------+---------------------------------------+----------------------------+-------------------+-------------------------+
| turbottest38122 | 3376754139384885550 | f1-micro     | 1970-01-01T05:30:00+05:30       | 614                    | 16                                    | true                       | us-east1-b        | <null>                  |
+-----------------+---------------------+--------------+---------------------------------+------------------------+---------------------------------------+----------------------------+-------------------+-------------------------+

Time: 5.5s. Rows fetched: 15,014. Hydrate calls: 0.

Please feel free to reach out if there's anything else you need.

Thanks again!