Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

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:

...

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

Data Source + Credentials

...

Data Source (SN Name)

Staging Table

Credentials

Source DB

CMDB Racks (Dev)

u_cmdb_racks_import

[CMDB Racks (Dev) Credentials

jdbc:sqlserver://aperdb-t.its.yale.edu:1433;databaseName=VISTA

Views

View

Description

SN_Blade_Chassis

SN_Blade_Servers

SN_Cards

SN_Network_Devices

SN_Physical_Servers

SN_Racks

SN_Space_Info

SN_Storage

...