On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote:
Hello, Does anyone has a select statement I can use to find out how many tapes I used on a daily basis? Thanks!
Most commonly, tapes automatically come from the scratches collection and return to scratch when emptied (rather than being assigned to a storage pool via DEFine Volume). And, UPDate Volume is rarely performed on volumes such that the administrative change timestamp remains that of when the volume was taken from scratch to be used in a storage pool. For basic reporting you can thus employ a variant of a Select statement like: select * from volumes where DAYS(CURRENT_DATE)-DAYS(CHG_TIME)<2 and DATE(LAST_WRITE_DATE)=DATE(CURRENT_TIMESTAMP) From that point of departure you can play with timestamps for desired intervals, and further select on STATUS value as desired. Richard Sims http://people.bu.edu/rbs/
