: Friday, April 10, 2015 10:36 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: finding possible values for a particular column
It's just a bash script, so:
yesterday=`date -d yesterday +%m/%d/%Y`
today=`date +%m/%d/%Y`
-
Cameron Hanover
chano...@umich.edu
They that can give up essential liberty
Rather than figure out all the possible conditions, I just scripted for the
ones I cared about and warned on the rest:
for STATUS in `tsm_run_command_as_admin $INSTANCE -tab select status from
events where domain_name like upper('${PREFIX}%') and
scheduled_start'${yesterday} 09:00' and
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Hanover, Cameron
Sent: Thursday, April 09, 2015 1:15 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: finding possible values for a particular column
Rather than figure out all the possible conditions, I just
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,
) 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
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
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