Hi all,
In the job history or the job details there is a field “Data Written”.
Is there a view or stored procedure in SQL that gives me this field? Or in which table I should look for this value?
Thx and best regards
Hi all,
In the job history or the job details there is a field “Data Written”.
Is there a view or stored procedure in SQL that gives me this field? Or in which table I should look for this value?
Thx and best regards
Best answer by Sheri Balzarano
Hello
For the CommCellBackupInfo view, the totalBackupSize is defined as Total Backup Size after Compression, but before deduplication (Archive File Size). This is not a value that is displayed anywhere in the Commcell Console for a job.
Unfortunately, the Data Written value is not explicitly outlined in this Commcell View and I do not believe it is available in other Commcell views.
Other options for obtaining the Data Written value from a query directly include:
a) If your Commcell is configured for and uploading metrics reporting data, the Data Written value for jobs can be found in the cf_SurveyJobStats table of the CVCloudDB.
Or
b) You may leverage the back end queries from available metrics reports that provide these details such as the 'Jobs in Storage Policy Copies' report or other Web Console/ Metrics reports that already have queries to calculate the Data Written value for Jobs:
https://cloud.commvault.com/webconsole/softwarestore/store.do#!/135/660/12184
The queries could be taken out of the report (by editing the dataSet of the report directly from within Web Console).
If you are hesitant to pull together a query from these reports or you would prefer someone within our organization make such a query, you can reach our account team to discuss options for this at any time.
Regards,
Sheri
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.