Integration for Tivoli

Integrating HP asset information with Tivoli Inventory 59
h_hp_oracle_views.sql
h_hptiv_queries.sh
Extending the Tivoli Inventory Database
Tivoli Inventory generates hardware and software .MIF files during an associated hardware or software
scan. The information in these .MIF files is stored in predefined tables within the configuration repository of
the database schema in the RDBMS. HP provides predefined scripts that will automatically extend an
associated Tivoli Inventory Database with the necessary HP tables in Microsoft® SQL and Oracle®
environments.
If you plan to use custom .MIF files, they must meet certain requirements that include creating tables and
columns in the Tivoli Inventory configuration repository to store the custom information.
When creating a custom table in the Tivoli Inventory configuration repository, follow these guidelines:
Do not modify existing tables in the Tivoli Inventory configuration repository.
The table name must be identical to the .MIF group name you use.
The column names must be identical to the attributes you will be use.
In each custom table, create a primary key that includes the following columns:
o HARDWARE_SYSTEM_ID
o CONFIG_CHANGE_TYPE
These guidelines enable tracking the configuration change history of the table by relating it to the
CONFIG_CHANGE_HISTORY table. In each custom table, include the CONFIG_CHANGE_TIME column.
This column does not have to be part of the primary key.
The primary key must also include any .MIF attribute that you designate as a key, for example, the CPU
Number and PCI Slot number require additional primary keys.
HP database scripts
The following scripts automatically extend the Tivoli Inventory Database and add the necessary tables for a
Microsoft® SQL Server or Oracle® implementation. These scripts are included with the HP Insight Integration
for Tivoli and are located in the \hpq\Inventory directory.
hp_oracle_schema.sql
hp_mssql_schema.sql
The following scripts create the history tables for the HP specific tables for Microsoft® SQL and Oracl
implementations:
h_hp_oracle_schema.sql
h_hp_mssql_schema.sql
Run the scripts that apply for the configured Tivoli Inventory Database using the appropriate ISQL or SQL Plus
database client. Ensure that the table permissions are set to run the script using the same Database ID
configured for Tivoli. The ID configuration information can be determined by running the wgetrim
command on the TMR Server.