Query

Display different information about backup, snapshot, instance and/or volumes by running the /opt/bacula/bin/openstack-vm-query with relevant parameters.

Parameters

-b Lists backups
-c <admin_openrc> Path to admin-openrc.sh
-f <format> Format the output in one of the following format: json, table, value, yaml
-l Lists instances
-L Lists projects
-p Check if Cinder-backup is running
-P <project-id> To target query to a specific project
-q Check if Cinder module is installed
-s List snapshots
-v Lists volumes
-V Verbose output for -p and -q options
-h Display help

Example

The query procedure is used to list different resources in a defined format.

/opt/bacula/bin/openstack-vm-query is the base command.

To list the instances available in the OpenStack server:

root@stackdev:/opt/bacula# bin/openstack-vm-query -l
+--------------------------------------+----------------+--------+--------------------------------------------------------------------------------+--------------------------+----------+
| ID                                   | Name           | Status | Networks                                                                       | Image                    | Flavor   |
+--------------------------------------+----------------+--------+--------------------------------------------------------------------------------+--------------------------+----------+
| instance_ID                          | instance_name  | ACTIVE | private=00.0.0.0, 1111:1111:1111:0:1111:1111:1111:1111; shared=111.111.111.111 | N/A (booted from volume) | m1.micro |
+--------------------------------------+-------+--------+--------+--------------------------------------------------------------------------------+--------------------------+----------+

To list the backups performed:

root@host:/opt/bacula# /opt/bacula/bin/openstack-vm-query -b
+---------------+----------------------+------------------------------------------+-----------+------+-------------+
| ID            | Name                 | Description                              | Status    | Size | Incremental |
+---------------+----------------------+------------------------------------------+-----------+------+-------------+
| <backup1_ID>> | <backup1_name>       | Backup done by Bacula Enterprise         | available |   10 | False       |
|                                      | INSTANCE=<instance_name> DATE=<datetime> |           |      |             |
|                                      |                                          |           |      |             |
| <backup2_ID>> | <backup2_name>       | Backup done by Bacula Enterprise         | available |    5 | False       |
|                                      | INSTANCE=<instance_name> DATE=<datetime> |           |      |             |
+---------------+----------------------+------------------------------------------+-----------+------+-------------+

Listing volumes and backups in a json format would result in:

root@openstack-bck:~# /opt/bacula/bin/openstack-vm-query -b -v -f json
[
  {
    "ID": "021b0a50-2729-4c2a-b8ae-252d76aecf42",
    "Name": "5b5bc409-ec90-4a12-b659-d2b4d04eb419_1711446820",
    "Description": "Backup done by Bacula Enterprise INSTANCE=testAna2 DATE=Tue Mar 26 09:53:40 UTC 2024",
    "Status": "available",
    "Size": 10,
    "Incremental": false
  },
  {
    "ID": "784b88d7-8262-4efe-9512-9ec483b8cb73",
    "Name": "5b5bc409-ec90-4a12-b659-d2b4d04eb419_1711446820",
    "Description": "Backup done by Bacula Enterprise INSTANCE=testAna2 DATE=Tue Mar 26 09:53:40 UTC 2024",
    "Status": "available",
    "Size": 5,
    "Incremental": false
  }
]
[
  {
    "ID": "6db88c97-1ddb-4f46-bcf4-06699f3f59f5",
    "Name": "testAna2-vol2",
    "Status": "available",
    "Size": 5,
    "Attached to": []
  },
  {
    "ID": "13a9d708-01c7-4320-9f04-534c8c380a64",
    "Name": "restore_backup_021b0a50-2729-4c2a-b8ae-252d76aecf42_at_1711448194",
    "Status": "available",
    "Size": 10,
    "Attached to": []
  },
  {
    "ID": "c645558e-cdf3-4334-968b-3482bf9a6c18",
    "Name": "testAna2-vol2",
    "Status": "available",
    "Size": 5,
    "Attached to": []
  },
  {
    "ID": "39161ee6-ec34-4f1a-87d0-d08ce71fac80",
    "Name": "restore_backup_f90ad4ec-882f-4071-9ec0-367dd7cc73b5_at_1710855568",
    "Status": "available",
    "Size": 10,
    "Attached to": []
  },
  {
    "ID": "5c257c96-c0be-4eb6-a751-462b56729e50",
    "Name": "testAna2-vol2",
    "Status": "in-use",
    "Size": 5,
    "Attached to": [
      {
        "id": "5c257c96-c0be-4eb6-a751-462b56729e50",
        "attachment_id": "00765039-5dc2-4bb3-bb95-fa1611b8ba81",
        "volume_id": "5c257c96-c0be-4eb6-a751-462b56729e50",
        "server_id": "5b5bc409-ec90-4a12-b659-d2b4d04eb419",
        "host_name": "openstack-bck",
        "device": "/dev/vdb",
        "attached_at": "2024-03-14T13:17:49.000000"
      }
    ]
  },
  {
    "ID": "b0412c13-2124-44ac-a11d-058c6146c104",
    "Name": "RestoreTestVolume",
    "Status": "in-use",
    "Size": 1,
    "Attached to": [
      {
        "id": "b0412c13-2124-44ac-a11d-058c6146c104",
        "attachment_id": "ac6c3444-180b-4535-abfc-467057dcad5d",
        "volume_id": "b0412c13-2124-44ac-a11d-058c6146c104",
        "server_id": "1952a2d3-6b0b-417d-a90d-cde7964074d1",
        "host_name": "openstack-bck",
        "device": "/dev/vda",
        "attached_at": "2024-03-08T13:52:40.000000"
      }
    ]
  },
  {
    "ID": "218b321c-7b7f-4f5b-af4b-9025f9ff4408",
    "Name": "",
    "Status": "in-use",
    "Size": 10,
    "Attached to": [
      {
        "id": "218b321c-7b7f-4f5b-af4b-9025f9ff4408",
        "attachment_id": "6347cad1-5d52-4698-b3f1-b0a746a2920d",
        "volume_id": "218b321c-7b7f-4f5b-af4b-9025f9ff4408",
        "server_id": "5b5bc409-ec90-4a12-b659-d2b4d04eb419",
        "host_name": "openstack-bck",
        "device": "/dev/vda",
        "attached_at": "2024-02-28T21:23:06.000000"
      }
    ]
  },
  {
    "ID": "c231ae83-ef6f-488f-b479-5ab328ea3b52",
    "Name": "c231ae83-ef6f-488f-b479-5ab328ea3b52",
    "Status": "in-use",
    "Size": 1,
    "Attached to": [
      {
        "id": "c231ae83-ef6f-488f-b479-5ab328ea3b52",
        "attachment_id": "289c3223-3a23-4a48-975f-6d2a2600a7e9",
        "volume_id": "c231ae83-ef6f-488f-b479-5ab328ea3b52",
        "server_id": "74364187-d6e7-431d-a80a-6275f88a69ce",
        "host_name": "openstack-bck",
        "device": "/dev/vda",
        "attached_at": "2024-02-23T10:18:19.000000"
      }
    ]
  }
]