| Table of Contents |
|---|
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)
| Gliffy | ||||||||
|---|---|---|---|---|---|---|---|---|
|
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)
Credentials
(TBD - SQL server is currently configured to accept DB auth as well as Windows auth, will probably set up a DB-specific account)
Views
View | Description |
|---|---|
SN_Blade_Chassis | |
SN_Blade_Servers | |
SN_Cards | |
SN_Network_Devices | |
SN_Physical_Servers | |
SN_Racks | |
SN_Space_Info | |
SN_Storage |
Here's an overview of how the views are related:
