Versions Compared

Old Version 82

changes.mady.by.user Allena Kendrick

Saved on

compared with

New Version 83

changes.mady.by.user Allena Kendrick

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)



...

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

...

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














...

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





































































































































































...