Report Writer Query Help

[Ravelin]

Hi, I'd like to have a Report that tells me what tape to take out of the robot, and which to insert instead. This I HAVE accomplished by Media.Last Write Date>Today-1.
Now I want to know which tape to insert instead.
I have done a Media.Last Write Date > 2004-02-01 14:14:46 and Media.Pool Status = Scratch Set which gives me all tapes in the scratch pool regardless of which media pool it used to be in.

Is it possible to combine these queries somehow, and get a report saying:
Last night you used a tape with this Serial Y from Media Pool X, now today the oldest scratch media I have from pool X is Serial Z.

 

[davidmichel]

Not sure and don't have time to really get into it but maybe one of the can'd reports would work for you. Take a look at the GFS Media Prediction or Rotation Profile reports.