Forum Discussion

BreezeWJ's avatar
BreezeWJ
Level 2
10 years ago

Low Scratch Script

Hello, I am looking for a Script or way to monitor our scratch pool to send an alert(email) when remaining available tapes reach a threshold of 8. We are running NB 7.6.0.1. I am New to the Net...
  • revarooo's avatar
    10 years ago

    You will need Opscenter Analytics license for this.

    This will count the number of media in the Scratch pool. You need to create a new report and select the "Run SQL Query"

    select COUNT (id) from Domain_Media where volumepoolname = 'Scratch'

     

    You can then save this report.

    Then Goto Reports -> Schedules and setup a new schedule to email this report.