Skip to main content
Solved

Qscript / SQL Stored Procedure BackendStorage

  • April 5, 2022
  • 1 reply
  • 284 views

ApK
Byte
Forum|alt.badge.img+6
  • Byte
  • 33 replies

Hi All.

 

I’m using the BackendStorage (QS_BackendStorage) Qscript / Stored Procedure to calculate backend storage usage for a given customer, to be able to invoice the customer for backend storage usage.

 

When sealing a DDB, I would like to exclude the storage usage from that DDB, would this be achievable, either by a command via the qoperation executing or by editing the QS_BackendStorage Stored procedure in SQL?

 

Thanks

-Anders

Best answer by Matt Medvedeff

Hello @ApK 

You could try modifying the i_fromTime variable to a date after the DDB was sealed. This should only report on Data written after this date

Usage

qoperation execscript -sn BackendStorage [-si @i_fromTime='2013/02/12'] [-si @i_toTime='2013/02/20'] [-si @i_isAged='2'] [-si @i_backupType='Full'] [-si @i_orderBy='Client'] [-si @i_policyName='policyName'] [-si @i_copyName='copyName']

https://documentation.commvault.com/11.24/expert/BackendStorage.html

 

View original
Did this answer your question?
If you have a question or comment, please create a topic

1 reply

Forum|alt.badge.img+10

Hello @ApK 

You could try modifying the i_fromTime variable to a date after the DDB was sealed. This should only report on Data written after this date

Usage

qoperation execscript -sn BackendStorage [-si @i_fromTime='2013/02/12'] [-si @i_toTime='2013/02/20'] [-si @i_isAged='2'] [-si @i_backupType='Full'] [-si @i_orderBy='Client'] [-si @i_policyName='policyName'] [-si @i_copyName='copyName']

https://documentation.commvault.com/11.24/expert/BackendStorage.html

 


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