To modify the retension of either backup or archive

Archive retension:

update copygroup domain_name policy_set_name class_name type=Archive destination=pool_name RETVer=days

(Note: if you don't need to modify destination then skip the destination=pool_name)

Backup retension:

update copygroup domain_name policy_set_name class_name type=Backup VERExists=Number VERDeleted=number RETExtra=days RETOnly=days

Management classes per domain

Management classes per domain

SELECT domain_name, set_name, class_name, defaultmc FROM mgmtclasses

To know the destination and retension of a particular management class

To know the destination and retension of a particular management class, whether its backup or archive, below are the useful select statements.

For Archive copy-group

Select * from AR_COPYGROUPS

For backup copy-group:

Select * from BU_COPYGROUPS

For selecting specific files from a storage (primary or copy storage)pool

For specific node in a particular storage pool:

query occupancy node_name stgpool=stgpool_name

For all files in a specific storage pool:

query occupancy stgpool=stgpool_name

For all files in all storage pools(primary and copy storage pool):

query occupancy

For all files for one specific node:

query occupancy node_name

To select data for nodes with respect to storage pool

select node_name, stgpool_name,sum(num_files) as Number_of_files, sum(physical_mb) as MB from occupancy group by node_name, stgpool_name