Versions Compared

Old Version 76

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

Saved on

compared with

New Version 77

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)



...

Date DescriptionClassDescriptionCommentsStatus
12/2/2019use First Discovery instead of Discovery SourceAll ClassesIndicate update is from Aperture

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







































































































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

DATA CENTER
cmdb_ci_datacenterbuilding














...

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





































































































































































...