Versions Compared

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
Business Analyst
CMDB LeadVimalpriya Kothandapani (Unlicensed)
CMDB Manager



Table of Contents

Table of Contents


APERTURE

...

CHANGE REQUESTS

Date DescriptionClassDescriptionCommentsStatus
12/2/2019use First Discovery instead of Discovery SourceAll Classes
Indicate update is from Aperture
Add  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

...

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

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

DATA CENTERcmdb_ci_datacenterLOCATION

building

FLOOR

floor

SPACE ID

space_id

MOUNT TYPE

mount_typeLOCATIONlocation







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

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

DATA CENTERcmdb_ci_datacenterLOCATION

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

DATA CENTER LOCATIONcmdb_ci_datacenter

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

DATA CENTERcmdb_ci_datacenterLOCATION

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

DATA CENTERcmdb_ci_datacenterLOCATION

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


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

DATA CENTERcmdb_ci_datacenterLOCATION

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

DATA CENTERcmdb_ci_datacenterLOCATION

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

DATA CENTERcmdb_ci_datacenterLOCATION

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

DATA CENTERLOCATION
cmdb_ci_datacenterbuilding

RACK Name
cmdb_ci_rackrack name







LocationlocationGRID 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

DATA CENTERcmdb_ci_datacenterLOCATION

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

DATA CENTERcmdb_ci_datacenterLOCATION

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

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

DATA CENTERcmdb_ci_datacenterLOCATION

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_infoDATA CENTERcmdb_ci_datacenterdata center_info

LOCATION

Building

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location








cmdb_ci_

pdu

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_infoDATA CENTERcmdb_ci_datacenterdata center

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

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

DESCRIPTION

description

MANUFACTURER


companymanufacturer

DEVICE TYPE

device_type

MODEL

model

MODEL  INFO
Discovery SourceAperture


model_info

LOCATIOn

building

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location















u_cmdb_ci_

drive

ethernet =

Storage Drive

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
u_









cmdb_ci_

ethernet = ethernet

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_

tape

ip_

server = Server Tape Unit

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_

ip

monitoring_

cooling  = cooling, cooling unit

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_

monitoring_hardware

chiller =

monitor

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










u_

cmdb_ci_

chiller = chiller

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


LOCATION
cmdb_ci_datacenter
data center
building

RACK NAME
cmdb_ci_rack_namerack name

GRID LOCATION

grid_location








u_


cmdb_ci_

ats = ats

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_

rpp

copper =

rpp

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_

copper = copper

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_

console - console

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_

expansion

transformer =

expansion

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








u_

cmdb_ci_san_

transformer

endpoint =

transformer

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_

endpoint

fabric =

san

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
modelMODEL  INFOmodel_infoDATA CENTER


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

_datacenterdata centerRACK NAME

_db_mssql_instance

add discovery source instance

12/12/2019discovery 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 REQUESTED

Status
Date ModificationTable DescriptionComments

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

Edition


Product Level

Product

Upgrade ReferenceSQL Instances

Instance

DataFile SizeMB

LogfilesizeMB

Create date

Image Removed

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