Skip to main content

Hi all,

we need to extract some useful information from our commserve: we would like to know the total number of files (or jobs if number of files is not available) that have a retention greater or equal to 6 months and are stored in our libraries.

Is there an SQL query or a report that can give us this information ? I don’t want to perform several queries on all the different storage policies that we have, I just need the numbers (if available).

Any suggestion is appreciated,

Regards

Gianluca

Hello @Gianluca Rossi 

Can you help me understand what your end goal is? 

Can you confirm if these library's are Deduped? Cloud/Disk/Tape? 

Kind regards

Albert Williams

Hi Albert,

we are trying to make an estimation of our long term storage: how many files do we have ? How big are they (total size) ?

Our library is a disk library (Hitachi NAS with CIFS protocoll ). Library is deduplicated.

Thank you for your interest

Regards

Gianluca

Maybe the File Storage Optimization feature could be of help here?

 

https://documentation.commvault.com/2023e/essential/file_storage_optimization.html

Hello @Gianluca Rossi 

You are also able to use the forecast report and set it up to only look at jobs for specific storage targets. 
From there it will be a full list of all jobs in order of retention. Not to hard to scroll down and find your list of jobs +6 Months. 

 

https://documentation.commvault.com/2023e/expert/data_retention_forecast_and_compliance_report_overview.html

 

Kind regards

Albert Williams

Thank you for the information. I just wonder if the system will be able to report useful data, as there are so many jobs that every time I tried to generate those kind of report I got almost nothing or not usable.

There is no other way to inquire the system...something like an SQL query ?

Regards

Gianluca

 Hello @Gianluca Rossi 


There is but for it to be useful it would require customisation and a number of inner joins to collect your required information.

The entire purpose of these tools is to make it so you can view the data you need.

For example the forecast report you can choose a storage target but you can also remove select clients that are causing you issues. 

 

If your goal is to get the exact SQL query for your very specific request, that wont happen on community. 

 

Kind regards

Albert Williams

Hi @Gianluca Rossi 

You can also try this command line documented below

https://documentation.commvault.com/2023e/expert/jobs_in_storage_policy_copies.html

You can export the output in excel and apply filters based on the retention.

 

Reply


Terms & ConditionsCookie settings