select statement below....mount...dismount messages from actlog for the prior
day...
FYI
cutlines strips header text...
hope this helps.

dsmadmc -id=admin -pa=xxxxx -itemcommit macro
/flapps/adsm/macros/tape_drive_util.mac
cat /tmp/tape_drive_util |/usr/local/bin/cutlines 4 >>
/var/tsm/report_data/tape_drive_util_mnt_dism
nt.rpt

[pbsxsz00004][/flapps/aix/prod.script]>more
/flapps/adsm/macros/tape_drive_util.mac
set sqldisplaymode wide
select date_time, message from actlog where (msgno=8337 or msgno=8468) -
and days(current_date)-days(date_time)=1 > /tmp/tape_drive_util






Ray Pratts <rpratts AT SWBELL DOT NET>
01/12/2001 09:47 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT 
EDU>@SMTP@Exchange

To:   ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
cc:

Subject:  Re: Which table shows mounts

Doesn't look like that information is kept in a table.  I look also and do not
see
it in the table definitions.

Kai G Hintze wrote:

> ADSM 3.1.2 on aix 4.1.5
>
> Which table holds mount information? I have looked and looked but I just can't
> see it. I see drive information, but it doesn't say whether the drive has a
> tape mounted. I guess I could query procedures and sessions and extract the
> info from them, but that is ugly.... It would probably be better to 'query
> mount' and parse the data.... But I really would like a table I could select
> from.