This page explains how to view prebuilt Mounted Image reports in BigQuery.
The Backup and DR Service provides prebuilt Mounted Image reports that are accessible in BigQuery. You can access these reports after you execute the prebuilt script in the same dataset where the logs are being routed through the log sink.
These reports provide information about the details of the mounted images present on the backup/recovery appliance.
- Appliance ID: The ID of the appliance associated with the host where the image is mounted.
- Appliance name: The name of the appliance associated with the host where the image is mounted.
- Last mount date: The timestamp when the image was last successfully mounted.
- Mounted host ID: The ID of the host where the image is mounted.
- Mounted hostname: The name of the host where the image is mounted.
- Mounted image age in days: The number of days from when the image was last mounted.
- Mounted image name: The name of the mounted image.
- Mounted resource label: The label associated with the mounted resource.
- Mounted resource name: The name of the resource on which the image is mounted.
- Read mode: The mode in which data gets read from OnVault pool.
- Recovery point date: The timestamp of when the last successful backup was taken.
- Resource type: The type of resource, for example, Compute Engine instance, Google Cloud VMware Engine, file system, or database.
- Resource virtual size (GiB): The size of the resource in GiB.
- Resource size (GiB): The size of the protected resource in GiB.
- Restorable object: The object of the application which is restored as part of mount.
- Storage consumed (GiB): The size of the storage consumed in GiB.
- Source image expiration date: The mounted image expiration date. It is in YYYY-MM-DDTHH:MM:SS.SSSZ format.
- Source image name: The name of the source image.
- Source image type: The type of source image. It can be a snapshot or OnVault image.
- Source hostname: The name of the source host.
- Source host ID: The ID of the source host where the image is mounted.
- Source resource name: The name of the source resource.
- Source resource ID: The ID of the source resource.
- Username: The name of the user who initiated the mount operation.
What's next
- Learn how to Execute prebuilt reports script
- Learn how to Write custom queries in BigQuery
- Learn how to View prebuilt reports in Connected Sheets
- Learn how to View prebuilt reports in Looker Studio
- Learn how to Download prebuilt reports