To know onsite and offsite tapes using select statements.

For Auditing use below select statements for ONSITE tapes:

tsm: server>select volume_name,access from volumes where access<>'OFFSITE'

Select statement for OFFSITE tapes:

tsm: server>select volume_name,access from volumes where access='OFFSITE'