On Jun 6, 2007, at 4:21 PM, Bell, Charles (Chip) wrote:
Does anyone have a handy SQL select statement or query that will
give you a
one-line picture of how much total data you have sitting on all
primary
storage pools in that moment of time? Thanks in advance! I kinda
need this in
a hurry...
If you will accept two and a half lines... :-)
SELECT SUM(BACKUP_MB + ARCHIVE_MB + SPACEMG_MB) / (1024 * 1024) AS
"Total TB of Primary Pool Data" FROM AUDITOCC
|