You'll have to work at it a bit, but you can get the backup start/end time
by:
select * from filespaces where nodename='BLAH'
You can get the files with errors by:
select * from actlog where msgno=4007 and nodename in ('BLAH1','BLAH2')
Of course instead of select *, you can select just the fields you want to
see.
It will take a little massaging, but the info is there.
I would be inclined to set up a scheduled script that dumped the previous 24
hours to a disk file each day for all clients, and let your users write
their own report!
-----Original Message-----
From: Anderson, Michael - HMIS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 10:29 AM
To: [EMAIL PROTECTED]
Subject: Query report
I have a group that wants the following information for their
backups: Client name, the start time of the backup,
end time of the backup, and any files that missed. I tried to
show them the schedule log, but this was not
clean enough for them. Anybody have any ideas? The TSM server is
AIX 4.3.3 the client nodes are NT 4.0
Tsm ver 4.1.0
Client ver 4.1.2.12
Thanks
Mike Anderson
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
