Would a simple   Query FILESPACE *   also work for you???
... joe.f.

Joseph A Faracchio,  Systems Programmer, UC Berkeley


On Thu, 1 Mar 2001, Shekhar      Dhotre wrote:

>
> hey there try this works for me..
>
> 'select Entity,Successful,Bytes,Examined,Affected,Failed from summary where
> activity='BACKUP' and cast((current_timestamp-start_time)hours as 
> decimal(8,0))
> < 24 order by Entity'
>
>
>
> shekhar Dhotre
> sys Admin
> Bayer.,.
>
>
>
>
> "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>@VM.MARIST.EDU> on 
> 03/01/2001
> 03:43:06 PM
>
> Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
> To:   ADSM-L AT VM.MARIST DOT EDU
> cc:
>
> Subject:  Re: SQL Reporting
>
>
> All those things are in the SUMMARY table - try SELECT * FROM SUMMARY.
>
> -----Original Message-----
> From: Jeffery Carroll [mailto:Jeffery_Carroll AT AGFG DOT COM]
> Sent: Thursday, March 01, 2001 3:07 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: SQL Reporting
>
>
> Running TSM 3.7.4 for NT
>
>
> We are looking to put a report together that would show the results of the
> previous nights incrementals.   We are looking for the following info via
> SQL reporting from TSM database.   What we are looking for is the
> following.
>
> NodeName,Actual Start Time, Actual Completions Time, Amount of data
> transferred per node, and Event Status (Complete,Missed,etc).
>
>
> I found a couple of the needed tables, but still missing some of the above
> information.
>
>
> Any assistance appreciated.
>
> Thanks,
>
>