Forum Discussion

Dollypee's avatar
Dollypee
Moderator
8 years ago

Tape written report using opscenter query

I need an assistance using an opscenter query to generate tapes written report for past 1 day or past 1 month etc.

Thank you

3 Replies

  • Hello Dollypee

     

    What issues are you having creating a report of the tapes that were written to in the previous day or previous month?

    • Dollypee's avatar
      Dollypee
      Moderator

      Hi GeForce123, am in need of an opscenter query to collect report for  tape written count. Thanks

      • GeForce123's avatar
        GeForce123
        Level 5

        Dollypee In OpsCenter, you know how to create a new report right? When you go to create a new report, create one based on an SQL query and paste this code there. It will report on tapes used in the past month.

        select TOP 20 START AT 1 domain_Media.barcode as "domain_Media.barcode",domain_Media.id as "domain_Media.id",adjust_timestamp(domain_Media.lastWriteTime,-14400000 ) as "domain_Media.lastWriteTime" from domain_Media , domain_MasterServer where domain_MasterServer.id = domain_Media.masterServerId and ( ( (domain_Media.allocationTime BETWEEN '137173432156970000' AND '137199352156970000') ) AND ( (domain_Media.lastWriteTime BETWEEN '137173432156970000' AND '137199352156970000') ) AND ( ( (CASE WHEN domain_Media.isValid = 1 THEN 1 WHEN domain_Media.isValid = 0 THEN 0 ELSE 1 END) = '1') ) AND ( ( (CASE WHEN domain_Media.deleted = 1 THEN 1 WHEN domain_Media.deleted = 0 THEN 0 ELSE 1 END) = '0') ) AND ( ( (domain_MasterServer.id IN (61,2530,8422140 )) ) ) )