Versions Compared

Old Version 78

changes.mady.by.user Allena Kendrick (Unlicensed)

Saved on

compared with

New Version 79

changes.mady.by.user Allena Kendrick (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page Properties



Target releaseNew York
Platform OwnerDeanna Burns (Unlicensed)
Document status
Status
colourGreen
titleWork In Progress
Project ManagerDavid Swanson (Unlicensed)
Discovery Lead
Allena Kendrick (Unlicensed)
Business Analyst
Vandana Bansal
CMDB LeadVimalpriya Kothandapani (Unlicensed)
CMDB Manager
Christopher Abbott (Unlicensed)



Table of Contents

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 







































































































...

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

DATA CENTER
cmdb_ci_datacenterbuilding














...


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









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

DATA CENTER
cmdb_ci_datacenterdata center

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location









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


















































































































...

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

Name

Server

Major Version

Edition

Product Level

Product Upgrade Reference


SQL Instances

Instance

DataFile SizeMB

LogfilesizeMB

Create date


Instance










 



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

Name

Datafile SizeMB

LogfilesizeMB

Create Date

SQL database

Instance

DataFile SizeMB

LogfilesizeMB

Create date



Database infoDatabaseinfo









































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





































































































































































...