SQL query to get the client, subclient, SP, retention

@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.

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

@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.

That’s fantastic, thanks for sharing!!