Skip to main content
Solved

How to interpret the BackendStorage-QScript/stored procedure or is there a better way to get the used space per client


Forum|alt.badge.img+1

Hi community,

we are migrating from another solution to Commvault’s backup solution.

Currently we are billing our customers per client and per used backup disk space. It would be great if we could handle the billing the same way as before.

We are now looking for the best way the get the used disk space per client. Ideally directly with a SQL query. In another thread someone recommended the QS_BackendStorage stored procedure. While this looks like a good solution, we are not sure how to interpret the values.

 

In our understanding the column ‘Backend Size (GB)’ contains the actual used disk space on the media agents per client. So adding up all those values should be equal to the used disk space on the volume.

In our testing system currently 14.3TB of the disk space is used (by just checking the disk usage on the media agent - we currently only have one), while the sum of all values in the column ‘Backend Size (GB)’ of the stored procedure is about 100TB.

So maybe someone can explain how those two values correlate. Is this mismatch because of compression or deduplication?


Additionally, if there is a more effective method to achieve this, it would be great if you could tell us how.

 

Thanks in advance.

Robin

Best answer by Gseibak

@RobinH - have a look at the chargeback report which reports on both FET and Backend.

 

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

View original
Did this answer your question?

2 replies

Forum|alt.badge.img+11
  • Vaulter
  • 118 replies
  • Answer
  • April 17, 2024

@RobinH - have a look at the chargeback report which reports on both FET and Backend.

 

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


Forum|alt.badge.img+1
  • Author
  • Bit
  • 1 reply
  • May 8, 2024

@Gseibak Thank you for your answer. We will look into the chargeback report.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings