RHEL 8.x Spectrum Protect Reports configuration

Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Reports configuration

1. Schedule information

   SELECT associations.domain_name, associations.node_name, associations.schedule_name,client_schedules.description, client_schedules.action, client_schedules.options,client_schedules.objects, client_schedules.starttime FROM associations associations,client_schedules client_schedules WHERE associations.domain_name = client_schedules.domain_name AND associations.schedule_name = client_schedules.schedule_name ORDER BY associations.domain_name,associations.node_name, associations.schedule_name

2. Policy information

   SELECT mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name, mgmtclasses.defaultmc, bu_copygroups.verexists, bu_copygroups.verdeleted, bu_copygroups.retextra, bu_copygroups.retonly, bu_copygroups.destination FROM mgmtclasses mgmtclasses, bu_copygroups bu_copygroups WHERE mgmtclasses.domain_name = bu_copygroups.domain_name AND mgmtclasses.set_name = bu_copygroups.set_name AND mgmtclasses.class_name = bu_copygroups.class_name AND mgmtclasses.set_name='ACTIVE' ORDER BY mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name

3. Nodes Data information

   SELECT n.node_name, n.domain_name, n.platform_name,TRIM(CHAR(client_version))||'.'||TRIM(CHAR(client_release))||'.' ||TRIM(CHAR(client_level))||'-'||TRIM(CHAR(client_sublevel)) as TSM_Client_Version,cast(float(a.total_mb)/1024 as DEC(8,2)) AS TOTAL_GB, DATE(n.lastacc_time) as LASTACC_DATE FROM nodes n, auditocc a WHERE n.node_name=a.node_name ORDER BY TOTAL_GB DESC

4. Tape Volume Information

   SELECT volumes.volume_name, volumes.stgpool_name, volumes.pct_utilized, volumes.pct_reclaim, volumes.status,volumes.access FROM volumes, libvolumes WHERE volumes.volume_name=libvolumes.volume_name ORDER BY stgpool_name

5. Last 24 hrs backup information

   SELECT activity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary WHERE activity<>'TAPE MOUNT' AND activity<>'EXPIRATION' AND end_time>current_timestamp-24 hours GROUP BY activity

Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Reports configuration