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" <g...@bsu.edu> To: ADSM-L@VM.MARIST.EDU Date: 04/08/2015 01:55 PM Subject: finding possible values for a particular column Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.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.