Hi Prem,
From within the OC, go to the Reports section and then create a new report using custom SQL queries. You can then enter multiple SQL queries to include in your report.
If you wish to know backup events from the last 24 hours for specific nodes, you could use a query like:
select * from events
where scheduled_start>current_date-1
and node_name in ('node1', 'node2', 'node3')
Regards
Darren
------------------------------
Darren Sanders
Principal Consultant
Celerity Ltd
http://www.celerity-uk.com#ibmchampion storage
------------------------------
Original Message:
Sent: Tue September 24, 2019 09:55 AM
From: Prem Singh
Subject: Select to get backup success detail of few specific nodes
Hi All,
I am looking for a select command to get a query of select to get the backup schedule success or failure email report through ops center on TSM version 8.1.5 for 10-15 specific clients, can anyone help on this.
------------------------------
Prem Singh
------------------------------