...

Page Properties

Target release

New York

Platform Owner

Document status

Status


colour	Green
title	Work In Progress

Project Manager

David Swanson (Unlicensed)

Discovery Lead

Allena Kendrick (Unlicensed)

Business Analyst

Vandana Bansal

CMDB Lead

Vimalpriya Kothandapani (Unlicensed)

CMDB Manager

Christopher Abbott (Unlicensed)

Table of Contents

Table of Contents

APERTURE

...

CHANGE REQUESTS

Date	Description	Class	Description	Comments	Status
12/2/2019	use First Discovery instead of Discovery Source	All Classes

Indicate update is from Aperture

Add Aperture as the option
12/2/2019	Add CI Location	All Clases	field to capture aperture location
12/16/2019	Location = Building	All Classes	Need to update the building based on Vanada File

Aperture Tasks

http://yaletemp1@service-now.com

Aperture	Task
Asset models Aperture/ServiceNow	Reconcilation SN Asset Classes with Aperture Classes
Approval of New Classes
User Interface Review	Adding/Removing fields from the UI
List Layout Standardization	For classes that will be utilized what will be the standard list layout by class
Network Classes	Current UI view and list layout
Data Validation with Aperture	Accesing Aperture to view data
Approval of New fields	Acceptance of new fields
Data is no longer needed	Identify any data that is no longer valid
Configure Relationships	Are we going to configure relationships scripted: Applications to servers Other to be defined
Validate related list	Server/Rack
Discovery Source	First Discovered, Discovery Source
Reconciling data attribute names	i.e datacenter_reference_1

Type > Aperture

Reference Tables

Manfacturers

Add Manufactures to Company Table and mark Manufacturer

...

SN Data Attribute

coalese

Transform map

application

X

https://yaletemp1.service-now.com/nav_to.do?uri=sys_transform_map.do?sys_id=a31acd461b994c1096610f6cdc4bcb5e

Critical Status

Support Group

APERTURE DATA TABLES

cmdb_ci_appl= Application

SN data attribute	coalesce	Aperture data attribute
NAME	X	device_name
DISCOVERY SOURCE		discovery_source

cmdb_ci_server = server,blade server, blade

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DEVICE TYPE			device_type
RACK NAME		cmdb_ci_rack	rack_name
MANUFACTURER		company	manufacturer
STATUS			install_status
MODEL INFO			model_info
DESCRIPTION			description
DATA CENTERLOCATION		cmdb_ci_datacenter	building
GRID LOCATION			grid_location
SPACE ID			space_id
SERIAL NUMBER			serial_number
MODEL			model

cmdb_ci_rack = rack

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		rack_name
MANUFACTURER		company
MODEL			model
MODEL INFO			model_info
STATUS			install_status
DESCRIPTION			descriptionm
GRID LOCATION			grid_location
DATA CENTER	cmdb_ci_datacenter	LOCATION			building
FLOOR			floor
SPACE ID			space_id
MOUNT TYPE			mount_type	LOCATION	location

SERVER		cmdb_ci_server	device_name
SPACE UNIQUE ID			space_unique_id
RECEPTABLE TYPE			receptable_type
DEVICE TYPE			device_type

cmdb_ci_storage_disk = disk

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	x		device_name
MANUFACTURER		company	manufacturer
SERIAL NUMBER			serial_number
RACK NAME		cmdb_ci_rack	rack_name
DEVICE TYPE			device_type
MODEL			model
MODEL INFO	model_info	DATA CENTER	cmdb_ci_datacenter	model_info
LOCATION			building
STATUS			install_status
GRID LOCATION			grid_location

cmdb_ci_storage_controller = controller

SN data attribute	coalesce	Reference	Aperture data attribute	Transform Map
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
MODEL			model
MODEL INFO			model_info
RACK NAME		cmdb_ci_rackname	rack_name
GRID LOCATION			grid_location
DEVICE TYPE			device_type
DATA CENTER	cmdb_ci_datacenter	LOCATION		building

cmdb_ci_

...

data_

...

equipment = category(power strip)

SN Data Attribute	coalesce	Reference	Aperture data Attribute	SN Relationship
NAME	X		device_name
MANUFACTURER		Company	manufacturer
MODEL ID		Product Models	model
MODEL NUMBER			model_info
STATUS			install_status
DESCRIPTION			description
GRID LOCATION			grid _location
DATA CENTER LOCATION	cmdb_ci_datacenter			building
FLOOR			floor
SPACE ID			space_id
SPACE UNIQUE ID			space_unique_id
RACK		cmdb_ci_rack	rack_name
MOUNT TYPE			mount_type
MOUNT LOCATION			location

cmdb_ci_hvac = hvac unit

SN data attribute	coalesce	Reference	Aperture data attribute	Transform Map
NAME	x		device_name
MODEL			model
GRID LOCATION			grid_location
STATUS			install_status
DATA CENTER	cmdb_ci_datacenter	LOCATION		building
MODEL INFO			model_info
SERIAL NUMBER			serial_number
MANUFACTURER		company	manurfacturer

cmdb_ci_environment = environment

SN data attribute	coalesce	reference	Aperture data attribute	Transform Map
NAME	X		device_name
MANUFACTURER		company	manufacturer
MODEL			model
MODEL_INFO			model_info
DATA CENTER	cmdb_ci_datacenter	LOCATION		building
RACK NAME		cmdb_ci_rack	rack_name
GRID LOCATION			grid_location
DEVICE TYPE			device_type

cmdb_ci_ip_switch = switch

SN data attribute	coalesce	reference	Aperture data attribute
NAME	X		device_name
SERIAL NUMBER			serial_number
MANUFACTURER		company	manufacturer
MODEL			model
RACK NAME		cndb_ci_rack	rack_name
MODLE INFO			model_info
DESCRIPTION			description

DATA CENTERcmdb_ci_datacenter


LOCATION			building
STATUS			install_status

cmdb_ci_ip_firewall = firewall

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships
NAME	x		device_name
DESCRIPTION			description
SERIAL NUMBER			serial_number
MANUFACTURER		company	manufacturer
MODEL			model
RACK NAME		cmdb_ci_rack	rack_name
MODEL			model
MODEL Info			model_info
DESCRIPTION			description
DATA CENTER	cmdb_ci_datacenterLOCATION			bulding
ASSET TAG			asset

cmdb_ci_ip_router = router

SN data attribute	coalesce	ReferenceColour picker	Aperture data attribute	SN Relationships	Transform Map
NAME	x		device_name
MODEL			model
MODEL INFO			model_info
RACK NAME		cmdb_ci_rack	rack_name	DATA CENTER	cmdb_ci_datacenter_name
LOCATION			building
DEVICE TYPE			device_type
MANUFACTURER		company	manufacturer

cmdb_ci_fddi_card = card

SN data attribute	coalesce	Reference	Aperture data attribute	Transform Map
NAME	X		device_name
DEVICE TYPE			device_type
RACK NAME		cmdb_ci_rack	rack_name
MANUFACTURER		company	manufacturer
STATUS			install_status
MODEL INFO			model_info
DESCRIPTION			description
DATA CENTER	cmdb_ci_datacenter	LOCATION		building
GRID LOCATION			grid_location
SPACE ID			space_id
SERIAL NUMBER			serial_number
MODEL			model

cmdb_ci_cabinet = cabinet

SN data attribute	coalsce	Reference	Aperture data attribute	SN Relationships
NAME	X		device_name
DESCRIPTION			description
MODEL			model
MODEL INFO			model_info
GRID LOCATION			grid_location
DEVICE TYPE			device_tupe
MANUFACTURER		company	manufacturer
RACK NAME		cmdb_ci_rack	rack_name
DATA CENTER	cmdb_ci_datacenterLOCATION			building

cmdb_ci_vpn_connection = vpn

SN data attribute	coalesce	Reference	Aperture data attribute	Transform Map
NAME	x		device_name
MANUFACTURER		company	manufacturer
MODEL			model
MODEL_INFO			model_info
DEVICE TYPE			device_type
DATA CENTERLOCATION		cmdb_ci_datacenter	building
RACK Name		cmdb_ci_rack	rack name

Location	location	GRID LOCATION		grid_location

cmdb_ci_chassis_server = chassis

SN data attribute	coalesce	Reference	Aperture data attribute	Transform Map
NAME	x		device_name
DESCRIPTION			description
RACK NAME		cmdb_ci_rack	rack_name
STATUS			install_status
SERIAL NUMBER			serial number
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER	cmdb_ci_datacenter	LOCATION		building
GRID LOCATION			grid_location

cmdb_ci_environment = environment

SN data attribute	coalesce	reference	Aperture data attribute	Transform Map
NAME	X		device_name
MANUFACTURER		company	manufacturer
MODEL			model
MODEL_INFO			model_info
DATA CENTER	cmdb_ci_datacenter	LOCATION		building
RACK NAME		cmdb_ci_rack	rack_name
GRID LOCATION			grid_location
DEVICE TYPE			device_type

u_cmdb_ci_cable_management = cable management

SN data attribute	coalesce	reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device_name
MODEL			model
MODEL INFO			model info
DEVICE TYPE			device_type
RACK NAME		cmdb_ci_rack	rack_name	DATA CENTER	cmdb_ci_datacenter
LOCATION			building
GRID LOCATION			grid_location
MANUFACTURER		company	manufacturer

u_cmdb_ci_av_equipment = av equipment

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships
NAME			device_name
DESCRIPTION			description
SERIAL NUMBER			serial_number
MODEL			model
RACK NAME		cmdb_ci_rack	rack_name
DEVICE TYPE			device_type
STATUS			install_status
MODEL INFO			model_info
GRID LOCATION			grid_location
MANUFACTURER		Company	manufacturer
DATA CENTER	cmdb_ci_datacenterLOCATION			builiding

cmdb_ci_sa_server_array =array

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info	DATA CENTER	cmdb_ci_datacenter	data center_info
LOCATION			Building
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

cmdb_ci_

pdu

power_equipment = category(pdu)

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info	DATA CENTER	cmdb_ci_datacenter	data center
LOCATION			building
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

cmdb_ci_web_appliance = web appliance

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_cmdb_ci_filler_panel = patch panel

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_cmdb_ci_telecom

= telecom

SN data attribute	coalesce	Aperture data attribute
NAME	X	device_name
MANUFACTURER		manufacturer
MODEL INFO
Discovery Source		Aperture

u_cmdb_ci_drive= Storage Drive

SN data attribute	coalesce

reference

Reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO

Discovery SourceAperture

		model_info
LOCATIOn		building
RACK NAME	cmdb_ci_rack_name	rack name
GRID LOCATION		grid_location

u_cmdb_ci_

drive

ethernet =

Storage Drive

ethernet

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_

cmdb_ci_

ethernet = ethernet

tape_server = Server Tape Unit

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

cmdb_ci_

tape

ip_

server = Server Tape Unit

cooling = cooling, cooling unit

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

cmdb_ci_

ip

monitoring_

cooling = cooling, cooling unit

hardware = monitor

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location
CI LOCATION			location

u_cmdb_ci_

monitoring_hardware

chiller =

monitor

chiller

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

CI LOCATIONlocation

u_

cmdb_ci_

chiller = chiller

power_equipment = category(ats)

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info

DATA CENTER


LOCATION		cmdb_ci_datacenter

data center

building
RACK NAME	cmdb_ci_rack_name	rack name
GRID LOCATION		grid_location

u_

cmdb_ci_

ats = ats

power_equipment = Category(rpp)

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_cmdb_ci_

rpp

copper =

rpp

copper

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_cmdb_ci_

copper = copper

console - console

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_cmdb_ci_

console - console

expansion = expansion

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_cmdb_ci_

expansion

transformer =

expansion

transformer

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_

cmdb_ci_san_

transformer

endpoint =

transformer

san

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info
DATA CENTER		cmdb_ci_datacenter	data center
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

cmdb_ci_san_

endpoint

fabric =

san

fabric

SN data attribute	coalesce	Reference	Aperture data attribute
NAME	X		device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type
MODEL

modelMODEL INFOmodel_infoDATA CENTER

		model
MODEL INFO		model_info
DATA CENTER	cmdb_ci_datacenter	data center
RACK NAME	cmdb_ci_rack_name	rack name
GRID LOCATION		grid_location

MSSQL DATA Imports

MS SQL CHANGES REQUESTS

Date	Modification	Table	Description	Comments	Status
12/12/2019	discovery source	cmdb_ci

_datacenterdata centerRACK NAME

_db_mssql_instance	add discovery source instance
12/12/2019	discovery source	cmdb_ci_

rack_namerack nameGRID LOCATIONgrid_location

db_mssql_database

add discovery source database

12/12/2019

UI Display

Name

Server

Major Version

Product Level

Product Update level

Remove

License Count

Monitoring

note: version and compatiblity review

cmdb_ci_

san_fabric = fabric

SN data attribute

coalesce

Reference

Aperture data attribute

SN Relationships

Transform Map

NAMEXdevice_nameDESCRIPTIONdescription

MANUFACTURER

companymanufacturerDEVICE TYPEdevice_typeMODELmodelMODEL INFOmodel_infoDATA CENTERcmdb_ci_datacenterdata centerRACK NAME

db_mssql_instance

List Layout

edition

product version

is clustered

windows schedule (Review)

product update reference

collations

full text installed

integrate security only

is hater enabled

relview description

cmdb_ci_db_mssql_instance

UI Display

Name

(add hoover to show db name)

servername

Datafile SizeMB

LogfilesizeMB

Create Date

remove dbowner

cmdb_ci_

rack_namerack nameGRID LOCATIONgrid_location

MSSQL DATA Imports

MS SQL CHANGES REQUESTED

Status

Date	Modification	Table	Description	Comments	db_mssql_database
	List Layout servername compatiblity level state_description Recovery model description (review description)	cmdb_ci_db_mssql_database

MS SQL Tasks

MSSQL	Tasks
Validate SQL Instance
Validate SQL DBs	Noticed that there are multiple dbs names but different creation dates and sizes
Configure Relationships	DB are connected to MS SQL Instances
Validate related list	Instance/DB
Approval of New fields	DBSIZE, DBOWNER, SQLCreation Date
Discovery Source	First Discovered, DIscovery Source

SQL Tables - Trustworthy Data

SQL Table	Data attributes
Instance	CREATE TABLE [dbo].[Instance]( [MachineName] [nvarchar](255) NULL, [ServerName] [nvarchar](255) NULL, [Instance] [nvarchar](255) NULL, [ComputerNamePhysicalNetBIOS] [nvarchar](255) NULL, [MajorVersion] [nvarchar](255) NULL, [Edition] [nvarchar](255) NULL, [ProductLevel] [nvarchar](255) NULL, [ProductUpdateLevel] [nvarchar](255) NULL, [ProductVersion] [nvarchar](255) NULL, [IsClustered] [int] NULL, [ProductBuildType] [nvarchar](255) NULL, [ProductUpdateReference] [nvarchar](255) NULL, [Collation] [nvarchar](255) NULL, [IsFullTextInstalled] [int] NULL, [IsIntegratedSecurityOnly] [int] NULL, [FilestreamConfiguredLevel] [int] NULL, [IsHadrEnabled] [int] NULL, [HadrManagerStatus] [int] NULL, [BuildCLRVersion] [nvarchar](255) NULL, [BackupCompressionDefault] [int] NULL, [AdHocDistributedQueries] [int] NULL, [CLREnabled] [sql_variant] NULL, [CostThresholdForParallelism] [int] NULL, [Max_DOP] [int] NULL, [MaxServerMemoryMB] [int] NULL, [MinServerMemoryMB] [int] NULL, [OptimizeForAdHocWorkloads] [int] NULL, [PriorityBoost] [int] NULL, [RemoteAdminConnections] [int] NULL, [XPCmdshell] [tinyint] NULL, [SQLServerStartTime] [datetime] NULL, [cpu_count] [int] NULL, [scheduler_count] [int] NULL, [Sockets] [int] NULL, [windows_release] [nvarchar](256) NULL, [windows_service_pack_level] [nvarchar](256) NULL )
DatabaseInfo	CREATE TABLE [dbo].[DatabaseInfo]( [ServerName] [varchar](256) NULL, [name] [varchar](100) NOT NULL, [DataFileSizeMB] [int] NULL, [LogFileSizeMB] [int] NULL, [DBOwner] [nvarchar](128) NULL, [create_date] [datetime] NOT NULL, [compatibility_level] [tinyint] NOT NULL, [collation_name] [sysname] NULL, [is_read_only] [bit] NULL, [is_auto_close_on] [bit] NOT NULL, [is_auto_shrink_on] [bit] NULL, [state_desc] [nvarchar](60) NULL, [recovery_model_desc] [nvarchar](60) NULL, [page_verify_option_desc] [nvarchar](60) NULL, [is_auto_create_stats_on] [bit] NULL, [is_broker_enabled] [bit] NOT NULL )
AD Properties	CREATE TABLE [dbo].[ADProperties]( [ServerName] [nvarchar](100) NULL, [Created] [datetime] NULL, [Description] [nvarchar](100) NULL, [MaintenanceWindow] [nvarchar](100) NULL, [Cycle] [nvarchar](100) NULL, [IP] [nvarchar](100) NULL, [OS] [nvarchar](100) NULL )

cmdb_ci_db_mssql_instance = SQL Instance Tab

https://yaletemp1.service-now.com/cmdb_ci_db_mssql_instance_list.do?sysparm_userpref_module=dc9485631b11845096610f6cdc4bcb64&sysparm_clear_stack=true

SN data attribute -

Description

SN class

MSSQL Data attribute

SN Relationships

SQL Instance connect to the SQL Databases

Related List

Schedule

UI Display

Name

Server

Major Version

Edition

Product Level

Product

Upgrade ReferenceSQL Instances

Instance

DataFile SizeMB

LogfilesizeMB

Create date

Image Removed

Instance

Update level

Remove

License Count

Monitoring

note: version and compatiblity review

SQL Instances

Instance

DataFile SizeMB

LogfilesizeMB

Create date

no relationships

Image Added

Instance

List Layout

edition

product version

is clustered

windows schedule (Review)

product update reference

collations

full text installed

integrate security only

is hater enabled

relview description

cmdb_ci_db_mssql_database = SQL Database Tab

https://yaletemp1.service-now.com/cmdb_ci_db_mssql_database_list.do?sysparm_userpref_module=89fcc294c0a8010c012421dba3f1ecd2&sysparm_clear_stack=true

...

Image Removed

SN data attribute	Description	MSSQL Data attribute	Scehdule	Schedule
UI Display Name (add hoover to show db name) servername Datafile SizeMB LogfilesizeMB Create Date remove dbowner	SQL database	Instance DataFile SizeMB LogfilesizeMB Create date	Database info	Databaseinfo
List Layout servername compatiblity level state_description Recovery model description (review description)

SCCM Integration

SN data attribute	Description	SN class	MSSQL Data attribute	SN Relationships	Transform Map	Schedule

V-Center Integration

SN data attribute	Description	SN class	MSSQL Data attribute	SN Relationships	Transform Map	Schedule

Open Questions

Question	Answer	Date Answered

Page Comparison

Versions Compared

Old Version 77

New Version Current

Key

APERTURE

CHANGE REQUESTS

Aperture Tasks

Reference Tables

APERTURE DATA TABLES

cmdb_ci_appl= Application

cmdb_ci_server = server,blade server, blade

cmdb_ci_rack = rack

cmdb_ci_storage_disk = disk

cmdb_ci_storage_controller = controller

cmdb_ci_

data_

equipment = category(power strip)

cmdb_ci_hvac = hvac unit

cmdb_ci_environment = environment

cmdb_ci_ip_switch = switch

cmdb_ci_ip_firewall = firewall

cmdb_ci_ip_router = router

cmdb_ci_fddi_card = card

cmdb_ci_cabinet = cabinet

cmdb_ci_vpn_connection = vpn

cmdb_ci_chassis_server = chassis

cmdb_ci_environment = environment

u_cmdb_ci_cable_management = cable management

u_cmdb_ci_av_equipment = av equipment

cmdb_ci_sa_server_array =array

cmdb_ci_

power_equipment = category(pdu)

cmdb_ci_web_appliance = web appliance

u_cmdb_ci_filler_panel = patch panel

u_cmdb_ci_telecom

= telecom

u_cmdb_ci_drive= Storage Drive

u_cmdb_ci_

ethernet =

ethernet

cmdb_ci_

tape_server = Server Tape Unit

cmdb_ci_

ip_

cooling = cooling, cooling unit

cmdb_ci_

monitoring_

hardware = monitor

u_cmdb_ci_

chiller =

chiller

cmdb_ci_

power_equipment = category(ats)

cmdb_ci_

power_equipment = Category(rpp)

u_cmdb_ci_

copper =

copper

u_cmdb_ci_

console - console

u_cmdb_ci_

expansion = expansion

u_cmdb_ci_

transformer =

transformer

cmdb_ci_san_

endpoint =

san

cmdb_ci_san_

fabric =

fabric

MSSQL DATA Imports

MS SQL CHANGES REQUESTS

cmdb_ci

_db_mssql_instance

cmdb_ci_

db_mssql_database

cmdb_ci_

db_mssql_instance