Page Properties | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
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_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 | ||||
...
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 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 |
---|---|---|---|---|---|---|
...