ADSM-L

Re: [ADSM-L] SQL select for primary stgpool data amount

2007-06-06 18:28:47
Subject: Re: [ADSM-L] SQL select for primary stgpool data amount
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 6 Jun 2007 18:27:54 -0400
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

<Prev in Thread] Current Thread [Next in Thread>