@Hongmo Kim have you considered looking at the rest API? it should be fairly simple to retrieve this information using a few API calls. see for more context and pointes https://api.commvault.com.
@ Onno
Thanks for your advice but customer doesn’t consider the REST API at the moment.
Customer is eager to know how to get the config value using SQL query.
Any stunning way?
Hi @Hongmo Kim
I guess you could try using the CommCellSubClientConfig view for the Client, Subclient, SP and Retention, then use the CommCellBkScheduleForSubclient view to get the associated Schedule Policy, Schedule Name and Schedule Backup Type.
- The two could be joined with the Subclient ID (appid)
Something like this might possibly help:
use commserv
select distinct CommCellSubClientConfig.clientname, CommCellSubClientConfig.subclient, data_sp, data_sp_copy, log_sp, data_sp_copy_fullcycles, data_sp_copy_retendays, CommCellBkScheduleForSubclients.scheduePolicy, CommCellBkScheduleForSubclients.scheduleName, CommCellBkScheduleForSubclients.schedbackuptype
from CommCellSubClientConfig
join CommCellBkScheduleForSubclients
on CommCellSubClientConfig.appid = CommCellBkScheduleForSubclients.appid
where CommCellSubClientConfig.clientname like 'cvltclnt' and CommCellSubClientConfig.subclient like 'cvltclnt_file_backup'
My MSSQL is limited, so I am interested to see if anyone else has any other (better) ideas here
Best Regards,
Michael
@MichaelCapon
Grateful for your tip !
but still cannot bring the Storage Policy and Retention set as “Incremental Storage Policy”.
Wondering where option value for “Incremental Storage Policy” is saved.
It won’t be a problem if customer doesn’t use this option “Incremental Storage Policy” for incremental backup but it’s mandatory option for customer so should be able to bring the value from Storage Policy set as “Incremental Storage Policy”.
Any decent idea?
@Hongmo Kim , the closest View I can find is this one:
https://documentation.commvault.com/11.25/expert/5546_commcellstoragepolicy.html
though that doesn’t include Incremental SP info.
I’ll see if I can get that from anyone in our docs team as the preferred method is CC Views, not direct MSSQL queries to the tables.
@Mike Struening
Grateful for your update on this.
I figured out and want to share where this value is saved. You can find this in “dbo.archGroup” table for Incremental Storage Policy and “dbo.ArchCopyToApp” for associaton related value.
That’s fantastic, thanks for sharing!!
Just wanted to create a new thread and somehow stumbled on this one.. This is amazing answer!
Thank you!