Search and Run Reports
Delphix Reporting / Search and Run Reports

Reports are the heart of Delphix Reporting. Reports gather data that spans all connected Delphix Engines and presents the data in a single location.

Activity Six: Search and View a Report

  1. Click View Report.   

  2. Click the report drop-down menu to reveal a selection of report options, as seen below.

Five new category sections appear to help you quickly locate the report of your choice. They are: Engine Activity, Health, Source, Storage, and VDB.

Reports of interest may include the Storage Summary report found under Storage, allowing you to view, compare, and analyze storage usage across Delphix Engines. Other useful reports include Active Faults, SnapSync, and Replication Summary. Below is a summary list of all reporting categories found under View Reports and a description of the reports found under each category.

Running a Report

Engine Activity Reports

Audit Log: Provides a view of all actions that have been performed on all Delphix Engines. This includes both user- and system-executed actions.

Audit Log Report

Bookmarks: Tracks Jet Stream (Delphix Self-Service) bookmark usage across a Delphix Self-Service deployment, particularly in relation to storage/capacity, as bookmarks pin storage on the Delphix Engine.

Recent Jobs: Covers all jobs across all Delphix Engines, such as provisioning or refreshing a VDB.

Replication Status: Allows you to validate that replication is running successfully across all Delphix Engines where it has been configured. If replication is not running successfully, it allows you to determine the cause.

Health Reports

Active Faults: Presents a consolidated view of faults across all Delphix Engines, along with suggested actions (in the “Action” column) to resolve the fault. When you have identified and fixed a fault, an administrator can go to the affected engine and mark the fault as resolved through the GUI or CLI.

 

 Active Faults Report

Engine Summary: A high-level overview report of all Delphix Engines. It contains version and engine information, the number of faults and recent jobs, and critical alerts for each engine.

Recent Alerts: Alerts are events that have occurred, their severity, and the point in time at which they occurred. The Recent Alerts report combines the alerts and their associated information across engines.

Replication Status: If you work with multiple Delphix Engines, it can be difficult to keep track of the various replication jobs. This report helps you determine quickly whether everything is running smoothly or whether a certain replication job is failing.

Replication Status Report

Source Reports

dSource Usage: Shows a list of dSources with the following information for each:

  • Actual disk capacity the dSource uses

  • Unvirtualized capacity – that is, the disk space that would be required if not using Delphix Engines

  • Percentage storage saved

  • Number of VDBs that are currently provisioned from the dSource

SnapSync Summary: Allows you to validate that SnapSync is occurring as expected and to compare the current and average duration of SnapSync operations. The duration of SnapSync operations may vary based on the size of the database, available network bandwidth, and database configuration – for example, whether change block tracking (CBT) is enabled. You can use this report to easily find the dSources for which SnapSyncs take the longest.

 

 SnapSync Summary Report

Storage Reports

Storage Breakdown

Using the information displayed with the Total button, you can:

  • Determine which engines have the most free space and identify good candidates for new dSources/VDBs

  • Determine which engines have the least free space, identify which engines need additional storage or require storage to be freed, and identify which engines may require different retention policies

  • Determine which engines have the most space used by VDBs and take actions such as refreshing VDBs or removing unneeded VDBs and/or VDB snapshots

  • Determine which engines have the most space used by dSources and identify source breakdown to see how capacity is used for dSource data. If needed, you can make appropriate changes to free up space.

Using the information displayed with the Source button, you can determine which engines have the most space used for logs and snapshots and modify retention policies or refresh VDBs to release old snapshots.

Storage Breakdown Report 

Storage History: Clicking the Historical tab summarizes total storage usage of all monitored engines for the past 30 days.

Storage Summary: Shows the total, used, and available storage for each engine, which allows you to identify when you are approaching a low-storage availability state.

Storage Summary Report

VDB Reports

VDB Inventory: Shows a consolidated list of all virtual datasets (VDBs and vFiles) that have been provisioned from a data source using the Delphix Engine. This report contains the same data as the top-level Containers tab. You can use this report to easily identify where each virtual database is located.

VDB Inventory Report

VDB Refresh Summary: Allows you to verify that refreshes are happening as expected and to compare the current and average duration of refresh operations.

VDB Usage: Shows a list of VDBs with the following information for each:

  • Actual disk capacity the VDB uses

  • Unvirtualized capacity

  • Percentage of storage saved

  • Date of most recent refresh operation or, if never refreshed, date when VDB was provisioned

VDB Usage Report