garychan789
Active Newcomer
- Joined
- Jul 3, 2012
- Messages
- 14
- Reaction score
- 0
- Points
- 0
Hello anyone,
Following select statement just show tape is state of "VAULT" in all time. I would show changed the state of "VAULT" in today.
SELECT drmedia.volume_name, volumes.stgpool_name, drmedia.state, drmedia.voltype, volumes.status, volumes.pct_utilized FROM drmedia, volumes WHERE drmedia.state='VAULT'
Thanks
Gary Chan
Following select statement just show tape is state of "VAULT" in all time. I would show changed the state of "VAULT" in today.
SELECT drmedia.volume_name, volumes.stgpool_name, drmedia.state, drmedia.voltype, volumes.status, volumes.pct_utilized FROM drmedia, volumes WHERE drmedia.state='VAULT'
Thanks
Gary Chan