Prem,
Regardless if the task is an administrative or client action if it is scheduled by an external scheduler, such as TNG, the TSM server will have no knowledge of the schedule. It is asked to perform an explicit task not execute a schedule. The backup server has no knowledge of the schedule only the actual task itself.
If the task is scheduled using the internal TSM scheduler you could then query the EVENTS table for pertinent information, for example:
Select * from EVENTS where SCHEDULE_NAME='EXPIRATION' and ACTUAL_START>=CURRENT_TIMESTAMP-24 hours order by ACTUAL_START
Note: Always use care in querying the events table, too broad of a query can severely impact system performance and operation.
Alternatively, even when using an external scheduler you could query the ACTLOG table for task error messages and filter the output, but doing this can be complicated and time consuming.
Here is an example I use for monitoring SQL backups that ran in the last 24 hours for specific database failures:
Select date_time,nodename,message from actlog where domainname='SQL_DOMAIN' and severity='E' and date_time>=current_timestamp-24 hours order by nodename
Combined with a simple for/next script I query all of my TSM backup servers and port results off to a csv file that can be reviewed for issues.
However the easiest and most reliable place to generate the reporting would be from the actual scheduler itself and should be completely reasonable to expect some sort of reporting from it.
------------------------------
Richard Adamson
TSM/ISP Consultant
------------------------------
Original Message:
Sent: 09-29-2018 10:09
From: Prem Singh
Subject: Looking for sql query for TSM 6.1 on AIX
Hi Guys,
I am waiting for your advise bit urgent requirement, Please help me.
------------------------------
Prem Singh
------------------------------