Can this be pin pointed to just a 24 hour period?

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Sims
Sent: Monday, August 13, 2007 10:30 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL select for primary stgpool data amount

On Aug 13, 2007, at 11:09 AM, Ray Louvier wrote:

> Does anyone have a Select command that I can pick one node and
> report on
> total GB(bytes) backed up for that node. I have management playing
> with
> Veritas and it does not seem to match what I see on a nightly basis. I
> am even a little skeptical of the TSM Operational reporting tool. It
> always says the servers in question only backup 160 GB but when I
> watch
> the sessions for these servers they say 300 GB backed up and so on.

Just run a Select like the following, after doing AUDit LICenses.

SELECT NODE_NAME AS "Node Name", BACKUP_MB/1024 AS "Backup GB",
BACKUP_COPY_MB/1024 AS "Backup Copies GB", -
        ARCHIVE_MB/1024 AS "Archive GB", ARCHIVE_COPY_MB/1024 AS
"Archive Copy GB", -
        SPACEMG_MB/1024 AS "HSM GB", SPACEMG_COPY_MB/1024 AS "HSM
Copy GB", TOTAL_MB/1024 AS "Total GB" -
        FROM AUDITOCC

SELECT SUM(BACKUP_MB + BACKUP_COPY_MB + ARCHIVE_MB + ARCHIVE_COPY_MB
+ SPACEMG_MB + SPACEMG_COPY_MB) -
        /(1024 * 1024) AS "Total TB of Stored Data" FROM AUDITOCC

Also have a look at your server Activity Log ANE messages, and
accounting records.

See http://people.bu.edu/rbs/ADSM.QuickFacts for nuances on AUDITOCC
vs. Query OCCupancy.

   Richard Sims, at Boston University

----------------------------------------------------------------------
This e-mail, including any attached files, may contain confidential and 
privileged information for the sole use of the intended recipient.  Any review, 
use, distribution, or disclosure by others is strictly prohibited.  If you are 
not the intended recipient (or authorized to receive information for the 
intended recipient), please contact the sender by reply e-mail and delete all 
copies of this message.