Overview

QueryPie supports GCP integration for server registration and management. You can synchronize resources within GCP, register them as servers managed by QueryPie, and grant access permissions and set policies for users and groups on the synchronized servers.

Registering GCP Integration Information in QueryPie

1. Navigate to Administrator > Servers > Connection Management > Cloud Providers menu.
2. Click the + Create Provider button in the top right.
3. Enter a name that can distinguish this provider in the Name field.
4. Select Google **** Cloud **** Platform from the Cloud Provider field.
5. Enter the Project ID of the resources you want to synchronize.
6. If you want to synchronize resources from a specific Region and Zone, check the Use Region and Zone item and select Region and Zone respectively.
7. Select the Credential required to synchronize resources. Currently, only Service Account method is supported.
   1. Provides manual synchronization method by entering GCP’s Service Account JSON when clicking Synchronize button by default.
      Starting from QueryPie 10.2.2, the “Save Credential for Synchronization” option is provided to enable synchronization through schedules even when using Service Account as Credential type.
8. You can use Search Filter to retrieve a list of some types of resources you want to synchronize.
   1. Search Filter works the same way as AWS search. You can use values such as names, hosts, OS, tags as filters, and you can conveniently enter search conditions and filters using the Enter key in the following order.
      1. Enter Key value and press Enter → Select search condition and press Enter → Enter Value value and press Enter
   2. For more detailed usage, please refer to User Guide for Linux Instances (AWS) .
9. Select the synchronization method from the Replication Frequency field.
   1. Manual : A method that synchronizes manually only when you want to synchronize.
   2. Scheduling : A method that synchronizes resources through periodic scheduling. Cron Expressions are provided.
10. Auto Configuration Upon Initial Synchronization You can specify some values for servers that are initially synchronized from Cloud Provider. Initial value settings cannot be modified after saving the Cloud Provider. If changes to this setting are needed, you must delete the Cloud Provider and register again.

• port : You can specify the connection port of synchronized servers. Currently, only SSH/SFTP ports can be specified.
• Tag : You can automatically add tags to synchronized servers.
  • If you enter {vpcid} in the tag value, the VPC ID of the Cloud where the server belongs is automatically filled.
  • Example: If you set the tag Key to “Network” and enter the Value as {vpcid}, when the server is in “vpc-1a2b3c4d” VPC, the “Network: vpc-1a2b3c4d” tag is automatically created.

11. Click the Save button to save the Cloud Provider.

Synchronizing and Managing Registered GCP Cloud Provider

1. Navigate to Administrator > Servers > Connection Management > Cloud Providers menu.
2. Click on the registered Cloud Provider to enter the detailed information screen.
3. Click the Dry run button in the top right to check in advance which servers will be synchronized from GCP. Dry run results are not saved.
4. Click the Sychronize button in the top right to synchronize resources from GCP.
5. You can check the synchronization progress in the displayed Synchronization Log, and you can also check the synchronization history in General > Systems > Jobs menu.
6. Once a Cloud Provider is registered, basic information and authentication information of the Provider cannot be changed.
   1. Name : Can be changed
   2. Cloud Provider : Cannot be changed
   3. Project ID : Cannot be changed
   4. Region and Zone : Cannot be changed
   5. Credential : Cannot be changed
      1. “Save Credential for Synchronization” : Can be changed from disabled to enabled, but cannot be changed from enabled to disabled
   6. Search Filter : Can be changed
   7. Replication Frequency : Cannot be changed