Forum Discussion

BMcg66's avatar
BMcg66
15 years ago

Custom report to show Deactivated Policy(ies) needed ASAP please!

I'm totally new to Backup Reporter and while I've done *some* in the past, it's not my forte.  I'm going to see what tutorial(s) are available to help me become proficient, but right now, time is precious.  What I need to create is a report for my VP of IT that shows what Backup Policy or Policies are currently deactivated.  Thanks!!
Backup and Recovery
OpsCenter
Reporting
Tip-How to
  • Zenshai's avatar
    Zenshai
    Level 4
    15 years ago
    select distinct backupPolicyName as InactivePolicy,
                objectPrimaryDisplayName as Masterserver
from ccsvc.backupPolicy,
     ccsvc.backupPolicydomain, 
     ccsvc.Object
where backupPolicyActive = 0
  and backupPolicyDomainID = backupPolicyBackupPolicyDomainID
  and backupPolicyDomainMasterServerObjectID = ObjectID
    • shwetadogra's avatar
      shwetadogra
      Level 1
      8 years ago

      Hello.

       

      Can you tell me what is ccsvc? while running query i am getting unable to find user id.