Re: Chicago TSM User Group meeting: Rescheduled

2015-04-08 Thread Mitchell, Ruth Slovik
I was just informed that the Chicago area TSM UG meeting date has been changed to Thursday, June 11, 2015. From: Mitchell, Ruth Slovik Sent: Tuesday, April 07, 2015 12:02 PM To: ADSM: Dist Stor Manager (ADSM-L@VM.MARIST.EDU) Subject: Chicago TSM User Group meeting: June 2, 2015 Hello all, If

so long and thank you

2015-04-08 Thread Lee, Gary
Thank you Wanda for all your help and advice through the years. May you enjoy your retirement, and not think about tsm or sql unless you want too. I appreciate all you have taught me.

finding possible values for a particular column

2015-04-08 Thread Lee, Gary
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,

Re: finding possible values for a particular column

2015-04-08 Thread Dwight Cook
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)

Re: finding possible values for a particular column

2015-04-08 Thread Arbogast, Warren K
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

Re: finding possible values for a particular column

2015-04-08 Thread Arbogast, Warren K
Wow, I forgot ‘Missed’. It takes a community to support TSM. Thank you Dwight. K. On Apr 8, 2015, at 3:28 PM, Arbogast, Warren K warbo...@iu.edumailto:warbo...@iu.edu wrote: Gary, You could start with these: failed, failed - no restart, severed, pending. Then, find any others by sending the

distinct field values

2015-04-08 Thread Lee, Gary
Thanks all.