I kinda like the summary table and it may have less issues than the
dsmaccnt.log
**
we have nodes that do hundreds of archives not to mention that
multithreading
incremental backups (resourceutilization in the dsm.opt) will create
multiple dsmaccnt.log records...
**
the select (2nd one below) will sum inbound data by...you can choose backup
or archive....for a day's activity
by node...
FYI Thanks Tim
tsm: ADSM>select activity from summary group by activity order by activity
ACTIVITY
------------------
ARCHIVE
BACKUP
EXPIRATION
FULL_DBBACKUP
MIGRATION
MOVE DATA
RECLAMATION
RESTORE
RETRIEVE
STGPOOL BACKUP
TAPE MOUNT
tsm: ADSM>macro thebest
ANS8000I Server command: 'select date(days(current_date)-1) as "DATA date",
summary.entity, nodes.domain_name, nodes.platform_name, sum(summary.bytes)
as sum_bytes from summary, nodes where summary.entity=nodes.node_name and
summary.activity='BACKUP' and days(current_date)-days(start_time)=1 group by
summary.entity, nodes.domain_name, nodes.platform_name' order by sum_bytes
desc
DATA date: 2002-01-08
ENTITY: US504S3E
DOMAIN_NAME: NOTES_PD
PLATFORM_NAME: WinNT
SUM_BYTES: 98826545113
-----Original Message-----
From: Marc David [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: Accounting Log
Hi All,
We turn on the Account Log on our TSM server (H50 running AIX 4.3.3).
This way we can charge back clients for disk space usage.
My question is, does anyone use this ?
Plus how do you get the output from the file DSMACCNT.LOG into a readable
report for management.
Marc David
Storage Manager
PFPC Global Fund Services
(508) 871-9961
