View source for RHEL 8.x Spectrum Protect Reports configuration

[[Main Page|Home]] > [[RHEL]] > [[RHEL 8.x]] > [[RHEL 8.x Backup tools|Backup tools]] > [[RHEL 8.x Spectrum Protect Backup|Spectrum Protect Backup]] > [[RHEL 8.x Spectrum Protect Reports configuration|Spectrum Protect Reports configuration]]

#Schedule information
#:<pre>
#::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
#:</pre>
#Policy information
#:<pre>
#::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
#:</pre>
#Nodes Data information
#:<pre>
#::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
#:</pre>
#Tape Volume Information
#:<pre>
#::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
#:</pre>
#Last 24 hrs backup information
#:<pre>
#::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
#:</pre>


[[Main Page|Home]] > [[RHEL]] > [[RHEL 8.x]] > [[RHEL 8.x Backup tools|Backup tools]] > [[RHEL 8.x Spectrum Protect Backup|Spectrum Protect Backup]] > [[RHEL 8.x Spectrum Protect Reports configuration|Spectrum Protect Reports configuration]]