select * from volhistory where type='BACKUPFULL' and
date_time>(current_timestamp-1 day)
You can use 'hour' instead of 'day' to get further granularity
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Roger Silva
Sent: 25 May 2006 17:24
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select Statements
Thank You Sandeep,
I made changes since some of the fields didn't work for me, but this is
what I have:
SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY
WHERE TYPE='BACKUPFULL'
But, what I would like to do is pull just the last or most current
BACKUPFULL or BACKUPINCR information. I have been looking for some
sort of a "CURRENT TIMESTAMP" or something on those lines?
Is there something I can add to get this info?
Rog
On May 25, 2006, at 3:19 AM, Sandeep Jain wrote:
> Hi,
> You can use below select statement to view the full db backup
> details.
>
> SELECT DATE_TIME AS "DATE TIME",TYPE,BACKUP_SERIES,VOLUME_NAME FROM
> VOLHISTORY WHERE TYPE='BACKUPFULL'
>
> REPLACE 'BACKUPFULL' WITH 'BACKUPINCR' IF YOU TAKE INCREMENTAL
> BACKUP
>
> With Best Regards,
> Sandeep Jain
>
>
>
> ********************** Legal Disclaimer
>
***********************************************************************
> *****
> ******
>
> "This email may contain confidential and privileged material for the
> sole
> use of the intended recipient. Any unauthorized review, use or
> distribution
> by others is strictly prohibited. If you have received the message in
> error,
> please advise the sender by reply email and delete the message. Thank
> you."
>
>
***********************************************************************
> *****
> *********
>
>
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> Roger Silva
> Sent: Thursday, May 25, 2006 1:54 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] Select Statements
>
>
> Hi,
>
> I am new to the this list and need some advice.
>
> I am trying to create a select statement I can run to monitor the
> Database
> Backups of our TSM Servers. I know there are fields in the SUMMARY
> portion
> of the table that has Start Time, End Time, Activity, Entity, Volume
> Name
> and Successful fields, but I am not sure as to how to put all this
> together
> in a nice script that can email to a group of
> individuals the status. I am not sure if I need to query several
> parts of the database in order to compile this info or not.
>
> Can anyone help me out?
>
> Thank You,
> Roger
>
>
>
> This email has been scanned for any virus infection at the sending
end.
>
|
