RHEL 8.x Spectrum Protect Reports configuration

From Notes_Wiki
Revision as of 08:19, 12 May 2023 by Saurabh (talk | contribs) (Created page with "Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > 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_sc...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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