Abstract
Since the first release of ADSM, users have wanted to extract information from the ADSM database. A variety of QUERY commands have always been available, but they are not very flexible and writing scripts to parse the output is difficult. There are the SHOW commands that many users have some acquaintance with, but SHOW is meant to be used only at the direction of IBM support; thus SHOW is undocumented and unsupported.
ADSM Version 3 includes an SQL interface that represents ADSM database information in the form of relational tables. The rows and columns in these tables can be accessed with the SQL SELECT statement which can be issued from the ADSM Administrator command line interface, and an ODBC driver for products such as Lotus Approach or Microsoft Access. This presentation will discuss the database tables, and how to extract information from them for generating reports.