: 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
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)
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
