Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-03 UTC."],[[["\u003cp\u003ePrebuilt Mounted Image reports are available in BigQuery through the Backup and DR Service, offering insights into mounted image details.\u003c/p\u003e\n"],["\u003cp\u003eAccess to these reports is granted after executing a prebuilt script in the designated dataset where logs are routed.\u003c/p\u003e\n"],["\u003cp\u003eThe reports contain data including appliance information, mount timestamps, host details, image specifics, and resource attributes.\u003c/p\u003e\n"],["\u003cp\u003eThe information includes source and resource information, storage information, and even the username who initated the action.\u003c/p\u003e\n"],["\u003cp\u003eThe prebuilt reports also provide insight into storage consumption, recovery points, and different image types.\u003c/p\u003e\n"]]],[],null,["# Mounted Image reports\n\nThis page explains how to view prebuilt Mounted Image reports in BigQuery.\n\nThe Backup and DR Service provides prebuilt Mounted Image reports that are\naccessible in BigQuery. You can access these reports after you\n[execute the prebuilt script](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#sink) in the same [dataset](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#sink) where the logs are\nbeing routed through the log sink.\n\nThese reports provide information about the details of the mounted images\npresent on the backup/recovery appliance.\n\n- **Appliance ID**: The ID of the appliance associated with the host where the image is mounted.\n- **Appliance name**: The name of the appliance associated with the host where the image is mounted.\n- **Last mount date**: The timestamp when the image was last successfully mounted.\n- **Mounted host ID**: The ID of the host where the image is mounted.\n- **Mounted hostname**: The name of the host where the image is mounted.\n- **Mounted image age in days**: The number of days from when the image was last mounted.\n- **Mounted image name**: The name of the mounted image.\n- **Mounted resource label**: The label associated with the mounted resource.\n- **Mounted resource name**: The name of the resource on which the image is mounted.\n- **Read mode**: The mode in which data gets read from OnVault pool.\n- **Recovery point date**: The timestamp of when the last successful backup was taken.\n- **Resource type**: The type of resource, for example, Compute Engine instance, Google Cloud VMware Engine, file system, or database.\n- **Resource virtual size (GiB)**: The size of the resource in GiB.\n- **Resource size (GiB)**: The size of the protected resource in GiB.\n- **Restorable object**: The object of the application which is restored as part of mount.\n- **Storage consumed (GiB)**: The size of the storage consumed in GiB.\n- **Source image expiration date**: The mounted image expiration date. It is in YYYY-MM-DDTHH:MM:SS.SSSZ format.\n- **Source image name**: The name of the source image.\n- **Source image type**: The type of source image. It can be a snapshot or OnVault image.\n- **Source hostname**: The name of the source host.\n- **Source host ID**: The ID of the source host where the image is mounted.\n- **Source resource name**: The name of the source resource.\n- **Source resource ID**: The ID of the source resource.\n- **Username**: The name of the user who initiated the mount operation.\n\nWhat's next\n-----------\n\n- Learn how to [Execute prebuilt reports script](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#sink)\n- Learn how to [Write custom queries in BigQuery](/backup-disaster-recovery/docs/monitor-reports/custom-query)\n- Learn how to [View prebuilt reports in Connected Sheets](/backup-disaster-recovery/docs/monitor-reports/view-reports-sheets)\n- Learn how to [View prebuilt reports in Looker Studio](/backup-disaster-recovery/docs/monitor-reports/view-reports-lookerstudio)\n- Learn how to [Download prebuilt reports](/backup-disaster-recovery/docs/monitor-reports/view-reports-sheets#download)"]]
