I was just brushing up on using the select command in ADSM, and i cannot
seem to find any table that
contains the recent events.

What table does the information when you issue the following command
come from?

adsm> q event * *

Scheduled Start      Actual Start         Schedule Name Node Name
Status
-------------------- -------------------- ------------- -------------
---------
---------
09/20/99   00:05:00  09/20/99   00:30:14  DAILY         MYNODE
09/20/99   00:05:00  09/20/99   00:30:14  DAILY         MYNODE
Completed
...

My guess is it may be from some sort of combination between the ACTLOG
and CLIENT_SCHEDULES and ASSOCIATIONS.

I thought I would ask here before I do any major searching on each table
for things.

Anyone have any ideas?

Matt Glanville
mwg AT kodak DOT com

(pick one)
adsm> select tabname from syscat.tables

TABNAME
------------------
ACTLOG
ACTLOG
ADMINS
ADMIN_SCHEDULES
ARCHIVES
AR_COPYGROUPS
ASSOCIATIONS
AUDITOCC
BACKUPS
BU_COPYGROUPS
CLIENTOPTS
CLIENT_SCHEDULES
CLOPTSETS
CONTENTS
DB
DBBACKUPTRIGGER
DBSPACETRIGGER
DBVOLUMES
DEVCLASSES
DOMAINS
DRIVES
DRMCSTGPOOLS
DRMEDIA
DRMMACHINE
DRMMACHINECHARS
DRMMACHINENODE
DRMMACHINERECINST
DRMMACHINERECMEDIA
DRMPSTGPOOLS
DRMRECOVERYMEDIA
DRMSRPF
DRMSTANZA
DRMSTATUS
DRMTRPF
FILESPACES
GROUP_MEMBER
LIBRARIES
LIBVOLUMES
LICENSES
LOG
LOGSPACETRIGGER
LOGVOLUMES
MEDIA
MGMTCLASSES
NODES
OCCUPANCY
OPTIONS
POLICYSETS
PROCESSES
PROFILES
PROF_ASSOCIATIONS
RECLAIM_ANALYSIS
RESTORES
SCRIPTS
SCRIPT_NAMES
SERVERS
SERVER_GROUP
SESSIONS
SPACEMGFILES
STATUS
STGPOOLS
SUBSCRIPTIONS
VOLHISTORY
VOLUMES
VOLUMEUSAGE
COLUMNS
ENUMTYPES
TABLES