Hello,

as a quick answer, please ask Andy Raibeck for a copy of his excellent
paper: ADSM Using the ADSM SQL Interface. This paper has been distributed in
the Karlsruhe seminar.

But, be sure you will not be able to write / update any data within the adsm
database. You only have READ access to all tables!

Regards,

Rene Lambelet  
Nestec SA - 55, Av. Nestle - CH-1800 Vevey
Tel: ++41'21'924'35'43 / Fax: ++41'21'924'45'89
E-Mail: rene.lambelet AT nestle DOT com


> -----Original Message-----
> From: Leo Humr [SMTP:lhumar AT VIC.BIGPOND.NET DOT AU]
> Sent: Tuesday, 1. December 1998 16:09
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      select command
> 
> Dear ADSMr's
>  
> We are trying to use select to extract information from our ADSM server.
> The commands do not function as expected.
> Can anybody tell me where I can find the subset of SQL92/93 commands for
> ADSM. Can we select files with certain extensions and how much space they
> occupy using the select command ?
> Does SAMS vantage give that functionality ?
> I like to delete the files that are not required and try to ascertain how
> much space is used up legitimately by the users.
>  
> Regards 
>  
> Leo Humar