Entities, metrics, and lookup information for the BMC - TrueSight Operations Management 9.0/9.5/9.6/10.0 extractor

This topic covers the following information:

Lookup details

  • Strong fields:
    1. TOKEN_ID
    2. HOSTNAME
  • Weak fields
    1. NAME
    2. _COMPATIBILITY_

TrueSight Infrastructure Management integration mapping parameters

The following table lists all mapping parameters for the integration of BMC Helix Capacity Optimization with BMC ProactiveNet.

Note

Download the attached PDF files to view the complete list of parameter mappings. Empty cells in the BMC ProactiveNet column represent derived BMC Helix Capacity Optimization metrics that do not have a corresponding BMC ProactiveNet metric mapping.

 Platform ↓

Mapping parameters

AIX

Solaris

Standalone

KVM

Debugging information for BMC ProactiveNet Sybase database

To configure the ETL in BMC Helix Capacity Optimization you must set up the connection with the BMC ProactiveNet repository database. The connector performs data extraction in two stages:

  • Discovering the entities in the BMC ProactiveNet Sybase database.
  • Extracting performance, configuration, and relationship data about these entities.

The discovery stage for top level entities for each platform for Sybase database are described below. You can use this information for help in diagnosis. In below queries, <schemaOwner> should be replaced by the schema owner, as the prefix for table or view name. 

Example: dba."_PATROL__UNIX_OS_CFG_VIEW" or dba.autodiscovery_inst_cfg

Discovery stage for top level entities for Sybase database

Standalone UNIX systems

BMC ProactiveNet 9.0
select DISTINCT DEVICENAME from <schemaOwner>."_PATROL__UNIX_OS_CFG_VIEW" where upper(ENTITYTYPE) like '%STANDALONE%' AND MOINSTID in (select instid from <schemaOwner>.autodiscovery_inst_cfg where flag=0)
BMC ProactiveNet 9.5
select DISTINCT DEVICENAME from <schemaOwner>."_PATROL__UNIX_OS_CFG_VIEW" where upper(ENTITYTYPE) like '%STANDALONE%' AND MOINSTID in (select itemid from <schemaOwner>.item_cfg where mfd=0)

Standalone Windows systems

BMC ProactiveNet 9.0
select DISTINCT DEVICENAME from <schemaOwner>."_PATROL__NT_OS_CFG_VIEW" where upper(ENTITYTYPE) like '%STANDALONE%' AND MOINSTID in (select instid from <schemaOwner>.autodiscovery_inst_cfg where flag=0)
BMC ProactiveNet 9.5
select DISTINCT DEVICENAME from <schemaOwner>."_PATROL__NT_OS_CFG_VIEW" where upper(ENTITYTYPE) like '%STANDALONE%' AND MOINSTID in (select itemid from <schemaOwner>.item_cfg where mfd=0)

AIX (IBM PowerVM) hosts

BMC ProactiveNet 9.0/9.5
select DISTINCT USERNAME from <schemaOwner>.DEVICE_CNTL where DEVICETYPE = 31

Solaris LDOM hosts

BMC ProactiveNet 9.0
SELECT DISTINCT DEVICENAME from <schemaOwner>."_PATROL__UNIX_OS_CFG_VIEW" where upper(ENTITYTYPE) like '%SUN.LDOM.PRIMARY%' AND MOINSTID in (select instid from <schemaOwner>.autodiscovery_inst_cfg where flag=0)
BMC ProactiveNet 9.5
SELECT DISTINCT DEVICENAME from <schemaOwner>."_PATROL__UNIX_OS_CFG_VIEW" where upper(ENTITYTYPE) like '%SUN.LDOM.PRIMARY%' AND MOINSTID in (select itemid from <schemaOwner>.item_cfg where mfd=0)

Solaris Zone hosts

BMC ProactiveNet 9.0
SELECT DISTINCT DEVICENAME from  <schemaOwner>."_PATROL__UNIX_OS_CFG_VIEW"  where upper(ENTITYTYPE) like '%SUN.ZONE.HOST%' AND MOINSTID in (select instid from <schemaOwner>.autodiscovery_inst_cfg where flag=0)
BMC ProactiveNet 9.5
SELECT DISTINCT DEVICENAME from  <schemaOwner>."_PATROL__UNIX_OS_CFG_VIEW"  where upper(ENTITYTYPE) like '%SUN.ZONE.HOST%' AND MOINSTID in (select itemid from <schemaOwner>.item_cfg where mfd=0)

KVM hosts

BMC TrueSight Infrastructure Management 10.0
SELECT DISTINCT DEVICENAME from <schemaOwner>."_PATROL__UNIX_OS_CFG_VIEW" where upper(ENTITYTYPE) like '%KVM.HOST%' AND MOINSTID in (select itemid from <schemaOwner>.item_cfg where mfd=0)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*