Import Transform Map Details


Target releaseNew York
Platform OwnerDeanna Burns (Unlicensed)
Document status
WORK IN PROGRESS
Project ManagerDavid Swanson (Unlicensed)
Discovery Lead
Business Analyst
CMDB LeadVimalpriya Kothandapani (Unlicensed)
CMDB Manager


Table of Contents

APERTURE CHANGE REQUESTS

Date DescriptionClassDescriptionCommentsStatus
12/2/2019use First Discovery instead of Discovery SourceAll ClassesAdd  Aperture as the option

12/2/2019Add CI Location All Clasesfield to capture aperture location 

12/16/2019Location = BuildingAll ClassesNeed to update the building based on Vanada File

































































































Aperture Tasks

http://yaletemp1@service-now.com

Aperture Task

Asset models Aperture/ServiceNowReconcilation SN Asset Classes with Aperture Classes

Approval of New Classes


User Interface ReviewAdding/Removing fields from the UI

List Layout StandardizationFor classes that will be utilized what will be the standard list layout by class

Network ClassesCurrent 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 neededIdentify any data that is no longer valid

Configure Relationships

Are we going to configure relationships scripted:


  1. Applications  to servers
  2. Other to be defined


Validate related list

Server/Rack 




Discovery SourceFirst Discovered, Discovery Source

Reconciling data attribute namesi.e datacenter_reference_1

Type > Aperture

Reference Tables

  • Manfacturers

Add  Manufactures to Company Table and mark Manufacturer



  • CMDB_CI_RACK = Rack Data
  • CMDB_CI_DATACENTER = Data Centers
  • CMDB_CI_APPL = Applications
SN Data Attributecoalese
Transform map
applicationX

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
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DISCOVERY SOURCE

discovery_source







cmdb_ci_server = server,blade server, blade

SN data attributecoalesceReferenceAperture data attributeSN RelationshipsTransform Map
NAMEX
device_name

DEVICE TYPE

device_type

RACK NAME


cmdb_ci_rackrack_name

MANUFACTURER
companymanufacturer

STATUS

install_status

MODEL INFO

model_info

DESCRIPTION

description

LOCATION
cmdb_ci_datacenterbuilding

GRID LOCATION

grid_location

SPACE ID

space_id

SERIAL NUMBER

serial_number

MODEL

model













cmdb_ci_rack = rack

SN data attributecoalesceReferenceAperture data attributeSN RelationshipsTransform Map
NAMEX
rack_name

MANUFACTURER
company


MODEL



model

MODEL INFO

model_info

STATUS

install_status

DESCRIPTION

descriptionm

GRID LOCATION

grid_location

LOCATION

building

FLOOR

floor

SPACE ID

space_id

MOUNT TYPE

mount_type







SERVER
cmdb_ci_serverdevice_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
NAMEx
device_name

MANUFACTURER
companymanufacturer

SERIAL NUMBER



serial_number

RACK NAME
cmdb_ci_rackrack_name

DEVICE TYPE

device_type

MODEL

model

MODEL INFO

model_info

LOCATION

building

STATUS

install_status

GRID LOCATION

grid_location































cmdb_ci_storage_controller = controller

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

MODEL

model

MODEL INFO

model_info

RACK NAME
cmdb_ci_racknamerack_name

GRID LOCATION

grid_location

DEVICE TYPE

device_type

LOCATION

building













cmdb_ci_data_equipment = category(power strip)

SN Data AttributecoalesceReference

Aperture data Attribute


SN Relationship

Transform Map


NAMEX
device_name

MANUFACTURER
Companymanufacturer

MODEL ID


Product Modelsmodel

MODEL NUMBER

model_info

STATUS

install_status

DESCRIPTION

description

GRID LOCATION

grid _location

LOCATION

building

FLOOR

floor

SPACE ID

space_id

SPACE UNIQUE ID

space_unique_id

RACK
cmdb_ci_rackrack_name

MOUNT TYPE

mount_type

MOUNT LOCATION

location



















cmdb_ci_hvac = hvac unit

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEx
device_name

MODEL

model

GRID LOCATION



grid_location

STATUS

install_status

LOCATION

building

MODEL INFO

model_info

SERIAL NUMBER

serial_number

MANUFACTURER
companymanurfacturer











































cmdb_ci_environment = environment

SN data attribute
coalesce
reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

MANUFACTURER
companymanufacturer

MODEL



model

MODEL_INFO

model_info

LOCATION

building

RACK NAME
cmdb_ci_rackrack_name

GRID LOCATION

grid_location

DEVICE TYPE

device_type







cmdb_ci_ip_switch = switch

SN data attribute

coalesce

reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

SERIAL NUMBER

serial_number

MANUFACTURER


companymanufacturer

MODEL

model

RACK NAME
cndb_ci_rackrack_name

MODLE INFO

model_info

DESCRIPTION

description

LOCATION

building

STATUS

install_status







cmdb_ci_ip_firewall = firewall

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEx
device_name

DESCRIPTION

description

SERIAL NUMBER



serial_number

MANUFACTURER
companymanufacturer

MODEL

model

RACK NAME
cmdb_ci_rackrack_name

MODEL

model

MODEL Info

model_info

DESCRIPTION

description

LOCATION

bulding

ASSET TAG

asset







cmdb_ci_ip_router = router

SN data attribute
coalesce
ReferenceColour picker
Aperture data attribute
SN Relationships
Transform Map
NAMEx
device_name

MODEL

model

MODEL INFO



model_info

RACK NAME
cmdb_ci_rackrack_name

LOCATION

building

DEVICE TYPE

device_type

MANUFACTURER
companymanufacturer







cmdb_ci_fddi_card = card

SN data attributecoalesceReferenceAperture data attributeSN RelationshipsTransform Map
NAMEX
device_name

DEVICE TYPE

device_type

RACK NAME


cmdb_ci_rackrack_name

MANUFACTURER
companymanufacturer

STATUS

install_status

MODEL INFO

model_info

DESCRIPTION

description

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

DESCRIPTION

description

MODEL



model

MODEL INFO

model_info

GRID LOCATION

grid_location

DEVICE TYPE

device_tupe

MANUFACTURER
companymanufacturer

RACK NAME
cmdb_ci_rackrack_name

LOCATION

building













cmdb_ci_vpn_connection = vpn

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEx
device_name

MANUFACTURER
companymanufacturer

MODEL



model

MODEL_INFO

model_info

DEVICE TYPE

device_type

LOCATION
cmdb_ci_datacenterbuilding

RACK Name
cmdb_ci_rackrack name







GRID LOCATION

grid_location







cmdb_ci_chassis_server = chassis

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEx
device_name

DESCRIPTION

description

RACK NAME


cmdb_ci_rackrack_name

STATUS

install_status

SERIAL NUMBER

serial number

MANUFACTURER
companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL INFO

model_info

LOCATION

building

GRID LOCATION

grid_location

























cmdb_ci_environment = environment

SN data attribute
coalesce
reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

MANUFACTURER
companymanufacturer

MODEL



model

MODEL_INFO

model_info

LOCATION

building

RACK NAME
cmdb_ci_rackrack_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
NAMEX
device_name

MODEL



model

MODEL INFO



model info

DEVICE TYPE

device_type

RACK NAME
cmdb_ci_rackrack_name

LOCATION

building

GRID LOCATION

grid_location

MANUFACTURER
companymanufacturer







u_cmdb_ci_av_equipment = av equipment

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

device_name

DESCRIPTION

description

SERIAL NUMBER



serial_number

MODEL

model

RACK NAME
cmdb_ci_rackrack_name

DEVICE TYPE

device_type

STATUS

install_status

MODEL INFO

model_info

GRID LOCATION

grid_location

MANUFACTURER
Companymanufacturer

LOCATION

builiding







cmdb_ci_sa_server_array =array

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

LOCATION

Building

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







cmdb_ci_power_equipment  = category(pdu)

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

LOCATION

building

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location













cmdb_ci_web_appliance = web appliance

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







u_cmdb_ci_filler_panel = patch panel

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







u_cmdb_ci_telecom = telecom

SN data attribute
coalesce
reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

MANUFACTURER

manufacturer

MODEL INFO






Discovery Source

Aperture







u_cmdb_ci_drive= Storage Drive

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

LOCATIOn

building

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location













u_cmdb_ci_ethernet = ethernet

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







cmdb_ci_tape_server = Server Tape Unit

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







cmdb_ci_ip_cooling  = cooling, cooling unit

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







cmdb_ci_monitoring_hardware = monitor

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location

CI LOCATION

location

u_cmdb_ci_chiller = chiller

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







cmdb_ci_power_equipment = category(ats)

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

LOCATION
cmdb_ci_datacenterbuilding

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







cmdb_ci_power_equipment = Category(rpp)

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location













u_cmdb_ci_copper = copper

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







u_cmdb_ci_console - console

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







u_cmdb_ci_expansion = expansion

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







u_cmdb_ci_transformer = transformer

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







cmdb_ci_san_endpoint = san

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location













cmdb_ci_san_fabric = fabric

SN data attribute
coalesce
Reference
Aperture data attribute
SN Relationships
Transform Map
NAMEX
device_name

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO

model_info

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location







MSSQL DATA Imports


MS SQL CHANGES REQUESTS

Date ModificationTable DescriptionCommentsStatus
12/12/2019discovery source

cmdb_ci_db_mssql_instance

add discovery source instance

12/12/2019discovery 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 DBsNoticed that there are multiple dbs names but different creation dates and sizes

Configure RelationshipsDB are connected to MS SQL Instances

Validate related listInstance/DB 

Approval of New fieldsDBSIZE, DBOWNER, SQLCreation Date

Discovery SourceFirst Discovered, DIscovery Source


SQL Tables - Trustworthy Data


SQL TableData 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
SN class
MSSQL Data attribute
UI
Relationship ( Requires Scripting) 
ScehduleSchedule

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 infoDatabaseinfo

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

QuestionAnswerDate Answered



Out of Scope