On Aug 13, 2007, at 11:44 AM, Ray Louvier wrote:
Can this be pin pointed to just a 24 hour period?
The Audit Occupancy table is a current-state data source.
If you want an interval or event based data source, utilize
the SUMMARY table or accounting records.
Consider also that this may not be
Can this be pin pointed to just a 24 hour period?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Monday, August 13, 2007 10:30 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL select for primary stgpool data amount
On Aug 13, 2007
, August 13, 2007 10:17 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL select for primary stgpool data amount
If the backup session has to retry backing up a file the session byte
count will record each attempt. The session total does not always match
the amount of data backed up.
Jim
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 t
If the backup session has to retry backing up a file the session byte
count will record each attempt. The session total does not always match
the amount of data backed up.
Jim
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Ray Louvier
Sent: Monday
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 th
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...
I
It will take quite a while to run, but here is what I put
together...probably not a very efficient query, and I haven't tested it
with using all stgpools, but you could always do a single query for each
stgpoolOh yeah, and it is based off of EST_CAP, and PCT_UTIL, so it
is no real representatio
