Title: Techniques for Extracting Management Data from OpenView Software

1
Title Techniques for Extracting Management Data
from OpenView Software Session 338 Speaker
Jim Miller, AIS Company Management Technology
Group, Inc.
2
This introductory technical presentation has the
objective of sparking your interest and
creativity in extracting management data from
OpenView and related software on an as needed
basis.

• Agenda
• How to setup database connections.
• What data is available?
• Database Schemas Tables
• How can we access the data?
• Data Extraction Techniques
• CLI
• SQL
• ODBC
• Utilities/Programs
• OpenView Interconnect (OVI)

3

• Setup the Database Connections
• Define in tnsnames.ora

TNSNAMES.ORA Network Configuration File
C\oracle\ora92\network\admin\tnsnames.ora
Generated by Oracle configuration tools. HPOVOU
(DESCRIPTION (ADDRESS_LIST
(ADDRESS (PROTOCOL TCP)(HOST
itovou.csvd.any.domain)(PORT 1521)) )
(CONNECT_DATA (SERVICE_NAME openview)
) )
Use Oracle Client Tools or edit the file manually.
OVO Management Server
Database Instance (SID)
4

• Setup the Database Connections
• Define in Data Sources (ODBC)
• Under Administrative Tools

Network Node Manager ODBC setup
OpenView Operations ODBC setup using
tnsnames.ora definition
User Defined ODBC Connections
5
Network Node Manager (NNM) - DB Schema Tables
HP OpenView Network Node Manager, Reporting and
Data Analysis with NNM (T2490-90007 PDF)
Basic Topology and SNMP Information
nnm_nodes, nnm_networks, nnm_segments Extended
Topology (ET) and/or NNM 7.5 includes
additional tables to the Data Warehouse
Address, HSRP, NW
6
Network Node Manager (NNM) - Data Extraction

• ovtopodump, ovobjprint commands against the
  internal sparse database
• Home Base http//servername7510/topology/home
• OpenView Reporter Integration
• Data Warehouse ovdwquery

Connected to ODBC Datasource tcpip 2690 as
ovdb. Enter SQL command, terminated by ""
("quit" to terminate) select ip_hostname,
snmp_sysdescr from nnm_nodes where ip_hostname
like 'it03'
As root run ovdwquery, and specify desired SQL.
Here, all I want is the hostname and SNMP system
description for nodes starting with it03

• ODBC driver for Solid (or any 3.5. compliant
  driver)

7
Network Node Manager (NNM) - ODBC Sample
Start MS Excel, then select Data Get External
Data New Database Query
Choose the ODBC datasource previous defined.
Enter User and Password as appropriate
Hostname, IP Address and System Contact
information from nnm_nodes
8
OpenView Operations/Unix - DB Schema Tables
Reporting and Database Schema (A.08.10 Sept. 2004)
Find any single templates assigned to nodes along
with template groups. Youll need to access and
join the tables opc_nodes, opc_tgrp_on_node, and
opc_tmpl_on_node
9
OpenView Operations/Unix - Data Extraction

• Administrator GUI Actions Utilities Reports
  
• SQL OV_CONF/OpC/mgmt_sv/reports/C
• Execute with OV_BIN/call_sqlplus.sh desired_sql
• ODBC with Oracle driver

Template details including default alarm
attributes.
10
OpenView Operations/Windows - DB Schema Tables

• OVOW Troubleshooting Guide Version 2.01 Feb.
  2004
• SQL Enterprise Manager
• Visio Database Reverse Engineering

OVOW SQL Database
Included with OVOW for reporting and graphing are
the OVR and OVPM tables.
11
OpenView Operations/Windows - Data Extraction
Instruction Text
Linked OV_MS_Instruction to OV_PM_LogPolicy to
list the instructions associated with the policy
conditions.
Active Directory SPI Policies
12
OpenView Operations/Windows - Data Extraction
Example of using the MS Excel PivotTable feature
to summarize the output
13
OpenView Operations/Windows - Data Extraction
Policy Type SNMP Interceptor
Condition Summary ( of lines)
OVOW Policies
MS Excel PivotTable Wizard
14
OpenView Operations/Windows - Data
Extraction Crystal Reports integration with MS
Excel
Crystal Reports Wizard
Report Fields
MS Excel Worksheet Specification
15
OpenView Operations/Windows - Data Extraction
Crystal Reports Example OVOW Instruction Text by
Policy
16
OpenView Reporter (OVR) - DB Schema Tables

• SQL Enterprise Manager
• Visio Database Reverse Enginering

A few OVR Tables from the reporter DB
17
OpenView Reporter (OVR) - Data Extraction

• Reporter Itself
• Crystal Reports

• Here I pulled the data from the OVR systems
  table into MS Excel.
• Data includes
• System Name
• OS Name
• OS Release
• OS Version
• Machine Type
• Agent Version
• of CPUs
• of Disks
• Amount of Memory
• Amount of Swap

18
OpenView Performance Manager (OVPM) - Data
Extraction
DB Schema Tables Included with OpenView
Reporter Database
OVO 8 Coda (HTTPS Agent)
Data Sources and Collection Times
OVO 7 Coda
19
Systems Insight Manager (SIM) - DB Schema
Tables
HP Systems Insight Manager Help Guide (356920-004
Nov. 2004 Ed. 1.3)
Common Information Model (CIM) Classes
20
Systems Insight Manager (SIM) - Data Extraction
Microsoft Query
Define Filter(s)
Join of CIM_ComputerSystem and CIM_SoftwareElement
21
Systems Insight Manager (SIM) - Data Extraction
Server
Type of module
Description
Program/Module Name
Version
22
Common Information Model (CIM) / Windows
Management Information (WMI) - DB Schema
Tables

• WMI Tools (download from Microsoft Developers
  Network (MSDN))
• WMI ODBC Adapter (driver)
  (optional install on CD in separate
  folder VALUEADD\MSFT\MGMT\WBEMODBC) Not
  supported in Windows Server 2003 use MDAC
  instead.
• www.dmtf.org/standards/cim
• msdn.microsoft.com WMI Reference

23
Common Information Model (CIM) / Windows
Management Information (WMI) - DB Schema
Tables
OVOW Server
WMI CIM Studio
Default Namespace root\CIMV2
Login using Windows credentials
For OVOW change namespace to root\HewlettPackard
\OpenView\Data
24
Example of Hardware information from root\CIMV2
namespace CIM_PhysicalComponent
Type of Component
Description
25
CIM/WMI Information from OpenView
Operations/Windows
OVOW Managed Nodes
OVOW WMI Classes in root\HewlettPackard\OpenView\D
ata namespace
26
OpenView Interconnect (OVI) Developers Tools
Excerpt of sampleapplications document provided
with OVI install
TCP Socket Samples
HTTP Samples
SOAP Samples
27
OpenView Interconnect (OVI) Developers Tools

• Developers Resource http//devresource.hp.com/d
  rc/topics/OVI.jsp
• Setup the PERL environment
• World-wide Web Library for Perl (libwww-perl)
  and prerequisites
• Read the design document /opt/OV/examples/OVI/
  sampleCode/HttpNetworkInventoryRequester/HttpInven
  toryRequesterDesign.html
• Start the OVI Java virtual machine from the
  
  
  /opt/OV/examples/OVI/sam
  pleCode/HttpNetworkInventoryRequester/config
  directory, execute
• /opt/OV/bin/OVI.sh -d ./NnmInventoryRequest.deplo
  y gt./OVI_exec.log
• Execute the sample application (NNM Inventory
  Requester) from the /opt/OV/examples/OVI/sampleCod
  e/HttpNetworkInventoryRequester directory
  perl ./HttpInventoryReques
  ter.pl http//localhost8080/ovi/NnmInventoryPlugl
  et

28
OpenView Interconnect (OVI) Developers Tools
HttpInventoryRequesterDesign.html ltovitdatagt
ltovitnamegtnamelt/ovitnamegt
ltovitvalue type"string"gt192.2.34.2lt/ovitvaluegt
lt/ovitdatagt ltovitdatagt
ltovitnamegtdescriptionlt/ovitnamegt
ltovitvalue type"string"gtCisco Internetwork
Operating System Software (tm) C2600 Software
(C2600-I-M), Version 12.0(7)T, RELEASE SOFTWARE
(fc2)(c) 1986-1999 by cisco Systems, Inc.Tue
07-Dec-99 0212 by phanguyelt/ovitvaluegt
lt/ovitdatagt ltovitdatagt
ltovitnamegtcreationTimelt/ovitnamegt
ltovitvalue type"dateTime"gt2003-11-06T115001-07
00lt/ovitvaluegt lt/ovitdatagt
ltovitdatagt ltovitnamegtstatusChangeTime
lt/ovitnamegt ltovitvalue
type"dateTime"gt2003-11-14T073110-0700lt/ovitva
luegt lt/ovitdatagt ltovitdatagt
ltovitnamegtchangeTimelt/ovitnamegt
ltovitvalue type"dateTime"gt2003-11-06T115001-07
00lt/ovitvaluegt lt/ovitdatagt
ltovitdatagt ltovitnamegtipLevellt/ovitna
megt ltovitvalue type"string"gtIPV4lt/ovi
tvaluegt lt/ovitdatagt ltovitdatagt
ltovitnamegtstatuslt/ovitnamegt
ltovitvalue type"string"gtNormallt/ovitvaluegt
lt/ovitdatagt

• Returned from the execution of the HTTP NNM
  Inventory Requester is a string of XML with name
  / value pairs.
• Use your language of choice to parse and/or
  format the output.
• Visual Basic
• C
• C
• PERL (XMLParser)
• Java
• JScript

29
OpenView Interconnect (OVI) Developers Tools
OVI Execution Log
Pluglet Initialization
2005-04-05 164639,092 INFO OVI-2003 Starting
kernel. 2005-04-05 164641,584 INFO OVI-2032
Pluglet NnmInventoryPluglet initializing. 2005-04-
05 164646,456 WARN OVI-3032
NnmInventoryPluglet License "OV Interconnect
Instant-On" found for "Inventory Pluglets (Part
Number T2523AA)", expires at 2005-05-22T000000
-0400. 2005-04-05 164647,575 INFO OVI-2033
Pluglet NnmInventoryPluglet initialized. 2005-04-0
5 164647,576 INFO OVI-2032 Pluglet
ResponderProxyPluglet initializing. 2005-04-05
164648,388 INFO OVI-101 HTTP Server
Statistics on true for org.mortbay.http.HttpServ
er_at_331059 2005-04-05 164649,121 INFO
OVI-2033 Pluglet ResponderProxyPluglet
initialized. 2005-04-05 164649,122 INFO
OVI-2032 Pluglet NnmInventoryPluglet
starting. 2005-04-05 164649,123 INFO
OVI-2033 Pluglet NnmInventoryPluglet
started. 2005-04-05 164649,123 INFO OVI-2032
Pluglet ResponderProxyPluglet starting. 2005-04-05
164649,124 INFO OVI-2032 Pluglet
NnmInventoryPluglet starting. 2005-04-05
164649,250 INFO OVI-101 HTTP Server
Starting Jetty/4.2.21 2005-04-05 164649,269
INFO OVI-101 HTTP Server Started
HttpContext 2005-04-05 164649,322 INFO
OVI-101 HTTP Server Started SocketListener on
0.0.0.08080 2005-04-05 164649,323 INFO
OVI-101 HTTP Server Started org.mortbay.http.Http
Server_at_331059 2005-04-05 164649,323 INFO
OVI-2033 Pluglet ResponderProxyPluglet
started. 2005-04-05 164649,324 INFO OVI-2004
Kernel started.
Pluglet Startup
HTTP Server Startup Listening on Port 8080
30
Additional Resources

• HP OpenView Network Node Manager, Reporting and
  Data Analysis with NNM (T2490-90007 PDF)
• Reporting and Database Schema (A.08.10 Sept.
  2004) OVOU
• OVOW Troubleshooting Guide Version 2.01 Feb.
  2004
• HP Systems Insight Manager Help Guide (356920-004
  Nov. 2004 Ed. 1.3)
• Microsoft Developers Network (MSDN)
  msdn.microsoft.com
• Distributed Management Task Force (DMTF)
  www.dmtf.org
• HP Developers Site Tools devresource.hp.com
• HP OpenView Data Extraction and Reporting
  (Version 1.02 Feb. 1999)

31
Thank You. Have a Great Conference.

• Please remember to turn in the session review
  sheets.