Hi,

I'm trying to understand the contents of the summary table on our TSM
5.3.4.0 server.

When I do

select entity,failed from summary where activity='BACKUP' and
cast((current_timestamp-start_time)hours as decimal(8,0)) < 24 and failed>0
order by entity

I get a number of results.

However, when I check the activity log for the results of a certain MSSQL
server with

q act begint=-24 search=SQLSERVER

I get results like

10/17/2007 22:01:26  ANE4993E (Session: 475, Node: SQLSERVER)  TDP
MSSQL Win32 ACO3002 Data Protection for SQL: full backup
of database Database from server SQLSERVER failed, rc = 1914. (SESSION: 475)

Why is this node listed in the summary table as OK, while it in fact failed?
Is this because the backup is initialized on the SQLServer through a task
scheduler command instead of by using the schedule settings on the server?

Kind regards,

Rick