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
