Gary,
You could start with these: failed, failed - no restart, severed, pending.  
Then, find any others by sending the output of a select statement or a macro to 
a csv file and sort it by status. The query we run every month is  like this 
with the dates updated:

select scheduled_start,domain_name,node_name,status from events where 
scheduled_start> '1900-01-01' and scheduled_start>= '2015-04-01' and 
scheduled_start< '2015-05-01' and domain_name <> ' ' order by scheduled_start

Other status conditions are; In Progress, Started, Future, but they aren’t 
really conditions.

For ordinary tables you could run a ‘select unique status from <tablename>’, 
but I doubt that will work from the Events table.

Good hunting,
Keith Arbogast
Indiana University

On Apr 8, 2015, at 2:55 PM, Lee, Gary <g...@bsu.edu<mailto:g...@bsu.edu>> wrote:

Is there a list somewhere of the possible values for different columns in the 
tsm database?

What I am particularly looking for are all the possible values of the status 
column in the events table.

Writing a script to notify backup schedules which have gone amiss.

Don't care about restarted, in progress, etc.  just error conditions.

Thanks for any pointers.

Reply via email to