Open Items

• repoint data sources once FW rules in place (developing w/ SSH tunnels)
• create a read-only role in MS SQL (currently the credential is too privileged)

Overview

Aperture is an application that provides a configuration data store for data center infrastructure. It's a primary source of practically undiscoverable physical metadata about configuration items:

• racks
• data center spaces/rooms
• UPS/HVAC equipment
• physical servers
• network devices
• cards

Most of this data is in the "VISTA" database underneath Aperture. This data can be imported and transformed into ServiceNow using MID Server (on Yale premises proxy)

VISTA Database Views

For the purposes of this integration, DC Operations is working with Avocent via a professional services contract to provide and maintain views for exposing configuration data to ServiceNow. At first this will be a one-way (SN read-only) integration, so Aperture will remain the canonical source of information, while SN will be used to plan & detect changes under the rubric of ITIL Change & Configuration management.

Servers

• APERDB (prod)
• APERDB-T (test)

Data Source + Credentials

Views

Here's an overview of how the views are related: