Richard I have tried sending to you at your personnel email address
but to no avail
> I have found some of the previous information you sent me very helpful.
>
> Do you
> have anything similar for SQL.  I would like to learn how to interogate
> ADSM
> tables and build a series of reporting jobs, but alas I am not very good
> at
> SQL. I cannot find any useful documentation on SQL (apart from the minor
> stuff in the mauals)  do you have anything or can you point me in the
> right
> direction ??
>
>
> ----------
> From:         Richard Sims[SMTP:rbs AT BU DOT EDU]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         18 February 2000 20:31
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Large Restores
>
> >> We had a situation where we had to restore a large  production
> >> server. This involved multiple tape mounts to rebuild
> >> the server. We have a large external tape library and multiple
> >> tape drives which are in STK silo's. Some of the
> >> tapes are in the silos and others are filed outside
> >> in a racked tape library. My question is, is there a
> >> way to get a picking list of tapes needed for the restore
> >> prior to the start of the restore. It would be
> >> a big time saver to stage the tapes or enter
> >> the tapes in the silo's before the tape is called
> >> to be mounted.
> >> I know this was not easily done with ADSM, however we have
> >> recently installed TSM 3.7.1 and was wondering if enhancements
> >> have been made to enable you to do this with Tivoli Storage
> >> manager.
>
> >Yes, there is.  You can run an SQL query against the ADSM DB to generate
> a
> >tape listing.
> >'select node_name,volume_name from volume_usage where
> node_name='nodename'
>
> Actually, you want to further qualify the query, because an unqualified
> query
> like this will show you all types (BACKUP, ARCHIVE) from all storage pools
> (Primary, Copy), and thus a lot more volumes than would be involved in the
> restoral.  Instead, you'd want something like:
>
>  select filespace_name,volume_name from volumeusage where node_name='____'
> -
>          and copy_type='backup' and stgpool_name='<YourBkupStgpoolName>'
>
> Richard Sims, BU
>