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 <GLEE AT bsu DOT edu<mailto:GLEE AT bsu
DOT 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.
|