Using SQL to query ADSM
TABLES lists all ADSM database tables that can be queried with SELECT.
Columns of interest are TABNAME and REMARKS.
Use TABNAME and REMARKS to determine where the information you are looking for might be.
For example:
- ADMINS might be a good place to start if you want information on ADSM administrators.
- BACKUPS probably contains information about backup versions.