Import Transform Map Details
Table of Contents
APERTURE CHANGE REQUESTS
Date | Description | Class | Description | Comments | Status |
---|---|---|---|---|---|
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
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:
| ||
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
- CMDB_CI_RACK = Rack Data
- CMDB_CI_DATACENTER = Data Centers
- CMDB_CI_APPL = Applications
SN Data Attribute | coalese | Transform map | |
---|---|---|---|
application | X | ||
Critical Status | |||
Support Group |
APERTURE DATA TABLES
cmdb_ci_appl= Application
SN data attribute | coalesce | Reference | Aperture data attribute | SN Relationships | Transform Map |
---|---|---|---|---|---|
NAME | X | device_name | |||
DISCOVERY SOURCE | discovery_source | ||||
cmdb_ci_server = server,blade server, blade
SN data attribute | coalesce | Reference | Aperture data attribute | SN Relationships | 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 | ||||
LOCATION | 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 | ||||
LOCATION | building | ||||
FLOOR | floor | ||||
SPACE ID | space_id | ||||
MOUNT TYPE | mount_type | ||||
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 | 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 | ||||
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 |
---|---|---|---|---|---|
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 | ||||
LOCATION | building | ||||
cmdb_ci_data_equipment = category(power strip)
SN Data Attribute | coalesce | Reference | Aperture data Attribute | SN Relationship | Transform Map |
---|---|---|---|---|---|
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 | ||||
LOCATION | 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 | SN Relationships | Transform Map |
---|---|---|---|---|---|
NAME | x | device_name | |||
MODEL | model | ||||
GRID LOCATION | grid_location | ||||
STATUS | install_status | ||||
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 | SN Relationships | Transform Map |
---|---|---|---|---|---|
NAME | X | device_name | |||
MANUFACTURER | company | manufacturer | |||
MODEL | model | ||||
MODEL_INFO | model_info | ||||
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 | SN Relationships | Transform Map |
---|---|---|---|---|---|
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 | ||||
LOCATION | building | ||||
STATUS | install_status | ||||
cmdb_ci_ip_firewall = firewall
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 | |||
MODEL | model | ||||
RACK NAME | cmdb_ci_rack | rack_name | |||
MODEL | model | ||||
MODEL Info | model_info | ||||
DESCRIPTION | description | ||||
LOCATION | bulding | ||||
ASSET TAG | asset | ||||
cmdb_ci_ip_router = router
cmdb_ci_fddi_card = card
SN data attribute | coalesce | Reference | Aperture data attribute | SN Relationships | 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 | ||||
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 | |||
LOCATION | building | ||||
cmdb_ci_vpn_connection = vpn
SN data attribute | coalesce | Reference | Aperture data attribute | SN Relationships | Transform Map |
---|---|---|---|---|---|
NAME | x | device_name | |||
MANUFACTURER | company | manufacturer | |||
MODEL | model | ||||
MODEL_INFO | model_info | ||||
DEVICE TYPE | device_type | ||||
LOCATION | cmdb_ci_datacenter | building | |||
RACK Name | cmdb_ci_rack | rack name | |||
GRID LOCATION | grid_location | ||||
cmdb_ci_chassis_server = chassis
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 | ||||
LOCATION | building | ||||
GRID LOCATION | grid_location | ||||
cmdb_ci_environment = environment
SN data attribute | coalesce | reference | Aperture data attribute | SN Relationships | Transform Map |
---|---|---|---|---|---|
NAME | X | device_name | |||
MANUFACTURER | company | manufacturer | |||
MODEL | model | ||||
MODEL_INFO | model_info | ||||
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 | |||
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 | Transform Map |
---|---|---|---|---|---|
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 | |||
LOCATION | 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 | ||||
LOCATION | Building | ||||
RACK NAME | cmdb_ci_rack_name | rack name | |||
GRID LOCATION | grid_location | ||||
cmdb_ci_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 | ||||
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 | |||
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 | 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 | |||
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 | |||
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 |
---|---|---|---|---|---|
NAME | X | device_name | |||
DESCRIPTION | description | ||||
MANUFACTURER | company | manufacturer | |||
DEVICE TYPE | device_type | ||||
MODEL | model | ||||
MODEL INFO | model_info | ||||
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 | 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 | |||
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 | 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 | |||
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 | 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 | |||
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 | 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 | |||
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 | 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 | |||
RACK NAME | cmdb_ci_rack_name | rack name | |||
GRID LOCATION | grid_location | ||||
cmdb_ci_power_equipment = category(ats)
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 | ||||
LOCATION | cmdb_ci_datacenter | building | |||
RACK NAME | cmdb_ci_rack_name | rack name | |||
GRID LOCATION | grid_location | ||||
cmdb_ci_power_equipment = Category(rpp)
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 | |||
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 | 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 | |||
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 | 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 | |||
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 | 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 | |||
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 | 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 | |||
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 | 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 | |||
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 | 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 | |||
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_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 Tables - Trustworthy Data
SQL Table | Data attributes |
---|---|
Instance |
|
DatabaseInfo |
|
AD Properties |
|
cmdb_ci_db_mssql_instance = SQL Instance Tab
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
SN data attribute | Description | SN class | MSSQL Data attribute | UI | Relationship ( Requires Scripting) | 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 |
---|---|---|