Integration for Tivoli

Integrating HP asset information with Tivoli Inventory 60
Creating HP specific views
If Tivoli Inventory is used to gather custom information, the predefined views provided with the HP integration
does not enable the Tivoli Inventory configuration repository to be queried for the custom HP specific
information. You must create additional database views. Creating a new view requires running a database
script to add the new views to the Tivoli Inventory configuration repository.
When creating a new view, note the following guidelines:
• Do not edit any predefined views.
• If the new view is to be used to query the Tivoli Inventory configuration repository and then return the
results to a subscription list, ensure that the new view contains the following columns: TME_OBJECT_ID
and TME_OBJECT_LABEL. This type of query can be used for Managed Nodes, Endpoints, PC
Managed Nodes, or any other managed site that meets the query criteria.
The following scripts provide examples of custom view creation and are included with the HP Insight
Integration for Tivoli in the \hpq\Inventory directory:
• hp_oracle_views.sql
• hp_mssql_views.sql
For HP specific views for historical data, use the following scripts:
• h_hp_oracle_views.sql
• h_hp_mssql_views.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.
These scripts create new views with HP specific information. They also demonstrate how the views can
contain both Tivoli collected inventory information in addition to HP Extended information.
NOTE: These sample views reflect only a relatively small number of the available HP Collected
Attributes. For a working Tivoli Management Environment, it is likely that additional views will
need to be created to meet individual requirements.
Create an HP query library and HP queries
To help in the creation of an HP query library and associated HP queries, the following reference script is
provided with the HP Insight Integration for Tivoli and is located in the hpq\Inventory directory:
hptiv_queries.sh
This script creates a new query library and new queries in a Tivoli Policy Region, specified at the time of
execution. These queries use the additional views that were created in previous sections of this chapter
("Extending the Tivoli Inventory Database (on page 59)" and "Creating HP specific views (on page 60)").
The queries created by this script are:
• HP CPU Information
• HP DRIVE ARRAY information
• HP FCA Information
• HP Inventory