cancel
Showing results for 
Search instead for 
Did you mean: 

OpsCenter SQL query to find "Front End TB"

MatsHolm
Level 4
Partner Accredited

Hi

Have a client that uses NetBackup in a Backup-as-aService solution and they want to have SQL query report finding Front End TB correlation gto different customers. They are using keywords on policies and want to have the queries based on that.

Have done one start query to find Full backups but not sure if this is Front End TB and then can't get the keyword to set.

Want to have domain_Policy.keyword=customername as a selcetion.

 

 

select F.clientName as "Client Name", cast(F.size / 1048576 as int) "Full Backup (MB)", cast(I.size / 1048576 as int) as "Incremental Backup (MB)“

        from

    (select clientName, sum(bytesWritten) as "size"

    from domain_JobArchive

    where scheduleType = 0

    and endTime > nomtimetoutcbigint(dateadd(month, -1, getdate()))

    group by clientName) F

1 REPLY 1

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi,

 

What type of storage are you using? If its appliance you'll have to use the presissize instead of kbytes written.