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.
