I need to create a custom client report. Could you please provide a SQL query for the Commvault CommServe database that retrieves the following information for all clients:
• Client Name
. Workload
. App Type
. Instance
. Backupset
• Subclient Name
• Plan Name
• Storage Policy Name
• Backup Start Time
• Backup End Time
• Latest available Backup Date for each subclient
. Job Status
. Retention Until
Question
Need SQL Query for Client Backup Metadata in CommServe Database”
+2- Vaulter
Hello
The requirement here is to get details of backup for a specific client with the below details,
- Client Name
- Workload
- App Type
- Instance
- Backupset
- Subclient Name
- Plan Name
- Storage Policy Name
- Backup Start Time
- Backup End Time
- Latest available Backup Date for each subclient
- Job Status
- Retention Until
This can be achieved using Backup summary report, please check the below documentation and test the reports feature to see all the required information is available. This report also has options to customize and export in excel formation.
Data Views for the Backup Job Summary Report (Web)
https://documentation.commvault.com/v11/essential/data_views_for_backup_job_summary_report_web.html
Customizable options for job details
Kindly review this report and let me know if you have any further questions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.