That worked like a charm! Thanks so much!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Sheridan, Peter T.
Sent: Tuesday, June 29, 2010 1:49 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement to only list backups with particular event
arist.edu
Subject: Re: [ADSM-L] Select statement to only list backups with
particular event status
The only way to see status=Started jobs is if you perform a query while
they are under way: if you really wanted that, a cron job capture would
take care of it. Running a query after all scheduled bac
n progress or has been started.
>
> Any suggestions/ideas are appreciated! This one has me stumped!
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
> Richard Sims
> Sent: Tuesday, June 29, 2010 12:09 PM
> To: ADSM-L@VM.
The only way to see status=Started jobs is if you perform a query while they
are under way: if you really wanted that, a cron job capture would take care of
it. Running a query after all scheduled backups have finished will report
final status of Completed (or Missed or Failed), which is probab
e 29, 2010 12:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement to only list backups with particular event status
The EVENTS table has been an oddball in TSM, as I note in ADSM QuickFacts,
because of the way it was engineered. Using relative timestamp references
traditionally doesn&#x
The EVENTS table has been an oddball in TSM, as I note in ADSM QuickFacts,
because of the way it was engineered. Using relative timestamp references
traditionally doesn't work, so you need to employ an absolute timestamp, as in
select * from events WHERE SCHEDULED_START >= '2010-06-28'
Not
Hello everyone,
I am trying to create a select statement that will list all backups for clients
in the domain: windows & hmig that started after yesterday at 6PM until today
at the current date/time that had a status of: Missed, In Progress, Fail%,
Started.
I tried the below select statement b
