TADDM database schema and views

The TADDM database contains all of the configuration items (CIs) managed by a TADDM domain.

The database can be populated with CIs in several different ways:
  • TADDM discoveries
  • Bulk loading of Discovery Library Adapter (DLA) book files
  • Manual adding of CIs using the graphical user interface
  • Programmatic adding of CIs through the TADDM application programming interface (API)

CIs in the TADDM database are organized according to their classification within the IBM® Tivoli® Common Data Model (CDM). The object types, attributes, relationships, and naming rules for the CDM are documented in the CDMWebsite.zip file, located in the $COLLATION_HOME/sdk/doc/model directory. To browse this documentation, extract the .zip file to a new directory, and then open the misc/CDM.htm file in a Web browser.

For more information about the Tivoli Common Data Model, see Introducing the Common Data Model.

When developing custom reports for TADDM, you can use SQL queries to retrieve data stored in the TADDM database. However, rather than querying data directly from the TADDM database tables, reports should use the TADDM database views. TADDM provides many predefined database views to simplify the task of writing SQL queries to extract data from the database, and you can also design your own custom views.

There are four categories of TADDM database views:
  • Building block views
  • Details panel views
  • Custom views
  • Extended attributes views
Fix Pack 3Note: In TADDM 7.3.0.3, and later, the maximum number of characters that column names in database views can have is 30.
Fix Pack 5Note: A new view “MSS_INFO_VIEW” has been defined for the user to query the MSS Info details. User can write a query on this view to fetch the MSS Info specific data. To see the columns that are defined for this view, user can run the following SQL query:
DESCRIBE TABLE MSS_INFO_VIEW