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
