ADSM-L

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

2007-08-13 11:31:32
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: Mon, 13 Aug 2007 11:29:30 -0400
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