...

Table of Contents

Table of Contents

APERTURE CHANGE REQUESTS

...

Aperture Tasks

http://yaletemp1@service-now.com

...

Are we going to configure relationships scripted:

Applications to servers
Other to be defined

...

Server/Rack

...

Type > Aperture

Image Removed

Reference Tables

Manfacturers

Add Manufactures to Company Table and mark Manufacturer

Image Removed

CMDB_CI_RACK = Rack Data
CMDB_CI_DATACENTER = Data Centers
CMDB_CI_APPL = Applications

...

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

...

APERTURE DATA TABLES

cmdb_ci_appl= Application

...

SN data attribute

...

coalesce

...

Reference

...

Aperture data attribute

...

SN Relationships

...

Transform Map

...

Page Properties

Target release

New York

Platform Owner

Deanna Burns (Unlicensed)

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

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

Image Added

Reference Tables

Manfacturers

Add Manufactures to Company Table and mark Manufacturer

Image Added

CMDB_CI_RACK = Rack Data
CMDB_CI_DATACENTER = Data Centers
CMDB_CI_APPL = Applications

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 CENTER		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
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	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	SN Relationships	Transform Map
NAME

X

x

device_name

DEVICE TYPEdevice_type


MANUFACTURER	company	manufacturer
SERIAL NUMBER		serial_number
RACK NAME	cmdb_ci_rack	rack_name

MANUFACTURERcompanymanufacturerSTATUSinstall_status


DEVICE TYPE			device_type
MODEL			model
MODEL INFO			model_info

DESCRIPTIONdescription


DATA CENTER	cmdb_ci_datacenter	building
STATUS		install_status
GRID LOCATION		grid_location

SPACE IDspace_idSERIAL NUMBERserial_numberMODELmodel

...

cmdb_ci_storage_controller = controller

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X

rackRECEPTABLE TYPEreceptable_type

	device_name
DESCRIPTION			description
MANUFACTURER		company	manufacturer
MODEL			model
MODEL INFO			model_info

STATUSinstall_statusDESCRIPTIONdescriptionmGRID LOCATIONgrid_locationDATA CENTERcmdb_ci_datacenterbuildingFLOORfloorSPACE IDspace_idMOUNT TYPEmount_typeLOCATIONlocationSERVERcmdb_ci_serverdevice_nameSPACE UNIQUE IDspace_unique_id

RACK NAME	cmdb_ci_rackname	rack_name
GRID LOCATION		grid_location
DEVICE TYPE		device_type
DATA CENTER	cmdb_ci_datacenter	building

cmdb_ci_

...

datapower_

...

server =

...

power strip

SN

data attribute

Data Attribute	coalesce	Reference	Aperture data

attribute

Attribute

SN

Relationships

Relationship

Transform Map

NAME

x

X		device_name
MANUFACTURER

companyRACK NAMEcmdb_ci_rackrack_nameDEVICE TYPEdevice_typeMODEL

Company

manufacturer

SERIAL NUMBER

serial_number

MODEL ID		Product Models	model
MODEL

INFO

NUMBER

model_info

DATA CENTER

cmdb_ci_datacenterbuilding


STATUS		install_status
DESCRIPTION		description
GRID LOCATION		grid _location
DATA CENTER LOCATION	cmdb_ci_

...

SN data attribute

coalesce

Reference

Aperture data attribute

SN Relationships

Transform Map

NAMEXdevice_nameDESCRIPTIONdescription

MANUFACTURER

companymanufacturerMODELmodelMODEL INFOmodel_infoRACK NAME

datacenter	building
FLOOR			floor
SPACE ID			space_id
SPACE UNIQUE ID			space_unique_id
RACK		cmdb_ci_

racknameDEVICE

rack

rack_name

GRID LOCATIONgrid_location

MOUNT TYPE

device

mount_type

DATA CENTERcmdb_ci_datacenterbuilding


MOUNT LOCATION			location

cmdb_ci_

...

hvac = hvac unit

SN

Data Attribute

data attribute	coalesce	Reference	Aperture data

Attribute

attribute	SN

Relationship

Relationships	Transform Map
NAME

X

x

device_name

MANUFACTURERCompanymanufacturer


MODEL

ID

Product Models

model

MODEL NUMBERmodel_infoSTATUSinstall_statusDESCRIPTIONdescription


GRID LOCATION			grid_location
STATUS			install_status
DATA CENTER

LOCATIONSPACE IDspace_idSPACE UNIQUE IDspace_unique_idRACKcmdb_ci_rackrack_nameMOUNT TYPEmount_typeMOUNT LOCATIONlocation

cmdb_ci_datacenter

building

FLOORfloor

MODEL INFO		model_info
SERIAL NUMBER		serial_number
MANUFACTURER	company	manurfacturer

cmdb_ci_

...

environment =

...

environment

SN data attribute	coalesce

Reference

reference	Aperture data attribute	SN Relationships	Transform Map
NAME

x

X	device_name
MANUFACTURER	company	manufacturer
MODEL		model

GRID LOCATION

grid_locationSTATUSinstall_status


MODEL_INFO		model_info
DATA CENTER	cmdb_ci_datacenter	building

MODEL INFOmodel_infoSERIAL NUMBERserial_numberMANUFACTURERcompanymanurfacturer

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

MODEL_


RACK NAME	cndb_ci_rack	rack_name
MODLE INFO		model_info

DATA CENTERcmdb_ci_datacenterbuildingRACK NAME


DESCRIPTION		description
DATA CENTER	cmdb_ci_

rack

datacenter

rack_nameGRID LOCATIONgrid_locationDEVICE TYPEdevice_type

building
STATUS			install_status

cmdb_ci_ip_

...

firewall =

...

firewall

SN data attribute	coalesce	referenceReference	Aperture data attribute	SN Relationships
NAME	Xx		device_name
DESCRIPTION			description
SERIAL NUMBER			serial_number
MANUFACTURER		company	manufacturer
MODEL			model
RACK NAME		cndbcmdb_ci_rack	rack_nameMODLE INFO
MODEL			model
MODEL Info			model_info
DESCRIPTION			description
DATA CENTER		cmdb_ci_datacenter	buildingbulding
STATUS	install_statusASSET TAG			asset

cmdb_ci_ip_

...

router =

...

router

SN data attribute	coalesce	ReferenceColour picker	Aperture data attribute	SN Relationships	Transform Map
NAME	x		device_name

DESCRIPTIONdescription

SERIAL NUMBER

serial_numberMANUFACTURERcompanymanufacturerMODELmodel


MODEL		model
MODEL INFO		model_info
RACK NAME	cmdb_ci_rack	rack_name

MODELmodelMODEL Infomodel_infoDESCRIPTION

description


DATA CENTER		cmdb_ci_datacenter

buldingASSET TAGasset

	building
DEVICE TYPE			device_type
MANUFACTURER		company	manufacturer

cmdb_ci_

...

fddi_

...

card =

...

card

SN data attribute	coalesce	Reference

	Aperture data attribute	SN Relationships	Transform Map
NAME

x

X

device_name

MODELmodel


DEVICE TYPE		device_type
RACK NAME	cmdb_ci_rack	rack_name
MANUFACTURER	company	manufacturer
STATUS		install_status
MODEL INFO		model_info

RACK NAMEcmdb_ci_rackrack_name


DESCRIPTION		description
DATA CENTER	cmdb_ci_datacenter	building

DEVICE TYPEdevice_typeMANUFACTURERcompanymanufacturer


GRID LOCATION			grid_location
SPACE ID			space_id
SERIAL NUMBER			serial_number
MODEL			model

cmdb_ci_

...

cabinet =

...

cabinet

SN data attribute

coalesce

coalsce	Reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device

_name

_name
DESCRIPTION			description
MODEL			model
MODEL INFO			model_info
GRID LOCATION			grid_location
DEVICE TYPE			device_

type

tupe
MANUFACTURER	company	manufacturer
RACK NAME	cmdb_ci_rack	rack_name

MANUFACTURERcompanymanufacturerSTATUSinstall_statusMODEL INFO

model_infoDESCRIPTIONdescription


DATA CENTER		cmdb_ci_datacenter	building

GRID LOCATIONgrid_locationSPACE IDspace_id

SERIAL NUMBERserial_numberMODELmodel

cmdb_ci_

cabinet

vpn_connection =

cabinet

vpn

SN data attribute

coalsce

coalesce	Reference	Aperture data attribute	SN Relationships	Transform Map
NAME

X

x

device_name

DESCRIPTION


MANUFACTURER		company

description

manufacturer
MODEL			model
MODEL_INFO			model_info

GRID LOCATIONgrid_location


DEVICE TYPE			device_

tupe

type

MANUFACTURERcompanymanufacturerRACK NAME


DATA CENTER	cmdb_ci_datacenter	building
RACK Name	cmdb_ci_rack	rack

_

name

DATA CENTERcmdb_ci_datacenterbuilding


Location			location
GRID LOCATION			grid_location

cmdb_ci_

vpn

chassis_

connection

server =

vpn

chassis

device_name

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships	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	DEVICE TYPE	device_type
DATA CENTER		cmdb_ci_datacenter	building	RACK Name	cmdb_ci_rack	rack name
Location	location	GRID LOCATION			grid_location

cmdb_ci_

chassis_server

environment =

chassis

environment

SN data attribute	coalesce

ReferenceDESCRIPTIONdescription

RACK NAME

cmdb_ci_rackrack_nameSTATUSinstall_statusSERIAL NUMBERserial number

reference	Aperture data attribute	SN Relationships	Transform Map
NAME

xdevice_name

X		device_name
MANUFACTURER		company	manufacturer

DEVICE TYPE

device_type


MODEL		model
MODEL_INFO		model_info
DATA CENTER	cmdb_ci_datacenter	building
RACK NAME	cmdb_ci_rack	rack_name
GRID LOCATION		grid_location
DEVICE TYPE		device_type

u_cmdb_ci_

environment = environment

cable_management = cable management

SN data attribute	coalesce	reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device_name

MANUFACTURERcompany

manufacturer


MODEL			model
MODEL

_

INFO

model

_

info

DATA CENTER


DEVICE TYPE

cmdb

device_

ci_datacenter

type

building


RACK NAME	cmdb_ci_rack	rack_name
DATA CENTER	cmdb_ci_datacenter	building
GRID LOCATION		grid_location
MANUFACTURER

DEVICE TYPEdevice_type

	company	manufacturer

u_cmdb_ci_

cable

av_

management

equipment =

cable management

av equipment

SN data attribute	coalesce

reference

Reference	Aperture data attribute	SN Relationships	Transform Map
NAME

X

device_name

MODEL

model


DESCRIPTION			description
SERIAL NUMBER			serial_number
MODEL

INFO

model

info

DEVICE TYPEdevice_type


RACK NAME		cmdb_ci_rack	rack_name

DATA CENTER


DEVICE TYPE

cmdb_ci_datacenterbuilding

	device_type
STATUS		install_status
MODEL INFO		model_info
GRID LOCATION		grid_location
MANUFACTURER

company

Company

manufacturer

u_cmdb_ci_av_equipment = av equipment


DATA CENTER	cmdb_ci_datacenter	builiding

cmdb_ci_sa_server_array =array

MODELmodelRACK NAMEcmdb_ci_rackrack_name

SN data attribute	coalesce	Reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device_name
DESCRIPTION			description

SERIAL NUMBER

serial_number

MANUFACTURER		company	manufacturer
DEVICE TYPE			device_type

STATUS


MODEL

install_status

model

MODEL


MODEL INFO			model_info

GRID LOCATIONgrid_locationMANUFACTURERCompanymanufacturerDATA CENTERcmdb_ci_datacenterbuiliding

cmdb_ci_sa_server_array =array


DATA CENTER	cmdb_ci_datacenter	data center
RACK NAME	cmdb_ci_rack_name	rack name
GRID LOCATION		grid_location

cmdb_ci_pdu = pdu

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_

pdu = pdu

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_

web

filler_

appliance

panel =

web appliance

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	reference	Aperture data attribute	SN Relationships	Transform Map
NAME	X		device_name

rack nameGRID LOCATIONgrid_location


MANUFACTURER			manufacturer
MODEL INFO
Discovery Source			Aperture

u_cmdb_ci_

filler_panel = patch panel

drive= Storage Drive

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

reference

Aperture data attribute

SN Relationships

Transform Map

NAMEXdevice_nameMANUFACTURERmanufacturer

MODEL INFO

Discovery SourceApertureu_cmdb_ci_drive= Storage Drive

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

u_

cmdb_ci_tape_

ethernet

server =

ethernet

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

ats =

chiller

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

u_cmdb_ci_

ats

rpp =

ats

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 REQUESTS

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

...

Page Comparison

Versions Compared

Old Version 79

New Version 80

Key

APERTURE CHANGE REQUESTS

Aperture Tasks

Reference Tables

APERTURE DATA TABLES

cmdb_ci_appl= Application

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_

datapower_

server =

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