You can always use a ~select distinct(<field>)~ to view what is within
your current environment.


tsm:>select distinct(status) from events

STATUS
--------------------------
Completed
Failed
Future
Missed
Severed

tsm:>

Dwight E. Cook
Technical Services Prof. Sr.
Strategic Outsourcing Delivery
(918) 493-4678



From:   "Lee, Gary" <glee AT BSU DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   04/08/2015 01:55 PM
Subject:        finding possible values for a particular column
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



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.