Storage policy properties from the command line

 Hi @dorota 

We have commands that lists the names of all the storage policies and storage policy copies available in the CommCell.

https://documentation.commvault.com/11.25/expert/11308_qlist_sp.html

https://documentation.commvault.com/11.25/expert/11314_qlist_spcopy.html

Or

We have a SQL query that can be executed to show all Storage Policy Copies and the retention set.

SELECT SP.name, SPC.name, R.retentionDays, R.FullCycles FROM archAgingRule R

JOIN ArchGroupCopy SPC ON SPC.id=R.Copyid

JOIN ArchGroup SP ON SP.id=SPC.archgroupID

Output:

=====