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)

...

Date	Description	Class	Description
12/2/2019	use First Discovery instead of Discovery Source	All Classes	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

...

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

...

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_typeLOCATION	location

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

...

SN data attribute	coalesce	Reference	Aperture data attribute	Transform Map
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	LOCATION		building
STATUS			install_status
GRID LOCATION			grid_location

...

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships
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_datacenterLOCATION			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

...

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships
NAME	x		device_name
MODEL			model
GRID LOCATION			grid_location
STATUS			install_status
DATA CENTER	cmdb_ci_datacenterLOCATION			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

	description
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
LOCATION			building
DEVICE TYPE			device_type
MANUFACTURER		company	manufacturer

...

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	Transform Map
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_datacenter
LOCATION			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	SN Relationships
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_datacenterLOCATION			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
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_datacenterLOCATION			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
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	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

...

u_cmdb_ci_ethernet = 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

cmdb_ci_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_ip_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_monitoring_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_chiller = 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

u_

cmdb_ci_power_

ats

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 CENTERLOCATION		cmdb_ci_datacenter	data centerbuilding
RACK NAME		cmdb_ci_rack_name	rack name
GRID LOCATION			grid_location

u_

cmdb_ci_

rpp

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_copper = 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_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_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_transformer = 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

cmdb_ci_san_endpoint = 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_fabric = fabric

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

...

Date	Modification	Table	Description
12/12/2019	discovery source	cmdb_ci_db_mssql_instance	add discovery source instance
12/12/2019	discovery source	cmdb_ci_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_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_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 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

Product Level

Product Update level

Remove

License Count

Monitoring

note: version and compatiblity review

SQL Instances

Instance

DataFile SizeMB

LogfilesizeMB

Create date

no relationships

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

...

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

...

Page Comparison

Versions Compared

Old Version 81

New Version Current

Key

Aperture Tasks

cmdb_ci_

data_

equipment = category(power strip)

cmdb_ci_environment = environment

cmdb_ci_ip_switch = switch

cmdb_ci_ip_firewall = firewall

cmdb_ci_ip_router = router

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_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

cmdb_ci_db_mssql_instance

cmdb_ci_db_mssql_database

cmdb_ci_db_mssql_instance

cmdb_ci_db_mssql_instance

cmdb_ci_db_mssql_database

cmdb_ci_db_mssql_database

MS SQL Tasks

cmdb_ci_db_mssql_instance = SQL Instance Tab

cmdb_ci_db_mssql_database = SQL Database Tab

SCCM Integration

V-Center Integration