Discovery Mechanism

Aperture VISTA uses a Microsoft SQL Server database as its data repository. The Aperture Integration Management software package (v2.0 or greater) adds some views to the VISTA database, and this integration adapter collects information by running SQL Queries against these views.

The integration adapter in this package is triggered by SQL Server instances in UCMDB that have a database instance with vista in their name. Out-of-the-box discovery jobs may be used to discover these SQL Server database instances.

The adapter works as follows:

1. Datacenter and Power Infrastructure Details

   It runs the following SQL query to get details on Datacenter and Power infrastructure from the Aperture VISTA data repository:

   SELECT device_name, device_serial_number, device_asset_class, device_manufacturer, device_model, device_model_info, rack_name, rack_asset_number, rack_serial_number, row_name, grid_location, space_name, floor, building_name, parent_name, parent_serial_number

   FROM vista.dbo.vip_dal_dv_devices

   WHERE device_asset_class='SERVER' OR device_asset_class='PDU' OR device_asset_class='RPP' OR device_asset_class='CHASSIS' OR device_asset_class='RACK'

   GROUP BY device_name, device_serial_number, device_asset_class, device_manufacturer, device_model, device_model_info, rack_name, rack_asset_number, rack_serial_number, row_name, grid_location, space_name, floor, building_name, parent_name, parent_serial_number

   ORDER BY device_asset_class, device_name

2. Identification of Power Supply Routing

   After all the infrastructure, power, and server CIs are created, the adapter uses the following query to identify power supply routing to servers:

   SELECT downstream_device_name, downstream_device_serial_number, upstream_device_name, upstream_building_name

   FROM vista.dbo.vip_dal_pwr_device_power_sources

   WHERE (downstream_device_name IS NOT NULL OR downstream_device_serial_number IS NOT NULL) AND upstream_device_name IS NOT NULL AND upstream_building_name IS NOT NULL AND upstream_node_type='PDU'

   GROUP BY downstream_device_name, downstream_device_serial_number, upstream_device_name, upstream_building_name

   ORDER BY downstream_device_name