Solved

Qscript / SQL Stored Procedure BackendStorage

  • 5 April 2022
  • 1 reply
  • 254 views

Userlevel 2
Badge +6

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

icon

Best answer by Matt Medvedeff 5 April 2022, 15:36

View original

If you have a question or comment, please create a topic

1 reply

Userlevel 4
Badge +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