Hi Richard,

The CONTENTS table contains some of the info that you want.

The available fields in CONTENTS table are:

VOLUME_NAME:
NODE_NAME:
TYPE:
FILESPACE_NAME:
FILE_NAME:
AGGREGATED:
FILE_SIZE:
SEGMENT:
CACHED:

For example you might

SELECT VOLUME_NAME, NODE_NAME, FILE_NAME, FILE_SIZE FROM CONTENTS WHERE
NODE_NAME='LOLA'

Of course this will generate one massive query!

Laura G. Buckley
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719)531-5133, FAX (719)260-5991
buckley AT storsol DOT com
www.storsol.com


> >>>-----Original Message-----
> >>>From: ADSM: Dist Stor Manager
> >>>[mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> >>>Richard Sims
> >>>Sent: Wednesday, January 26, 2000 11:41 AM
> >>>To: ADSM-L AT VM.MARIST DOT EDU
> >>>Subject: Getting file info via SQL query?
> >>>
> >>>
> >>>I've been looking into SQL for some means of reporting
> >>>Backup and Archive
> >>>files, but there seems to be no way to report file
> >>>attributes such as
> >>>file size, last accessed datestamp, last modified timestamp, etc.
> >>>Is this information actually unavailable via SQL, or can
> >>>someone give
> >>>an example of the means of displaying that info?
> >>>   thanks,  Richard Sims, BU
> >>>