cmdb_multisource_diff_query_view
Highlights discrepancies between configuration data from multiple sources to support data reconciliation.
Columns
| Name | Type | References | Description |
| msd1_sys_id | String | Lists the system identifier (sys_id) that uniquely identifies the first Configuration Management Database (CMDB) data source record. | |
| msd1_ci | String | References the configuration item (CI) associated with the first data source entry. | |
| msd1_class | String | Lists the CMDB class name defining the record type in the first data source. | |
| msd1_cmdb_reference | String | Specifies the reference field linking the first source record to a related CMDB entity. | |
| msd1_cmdb_reference_link | String | Provides the hyperlink reference to the related CMDB record from the first data source. | |
| msd1_col0 | String | Stores the comparison data value 0 that is retrieved from the first CMDB data source. | |
| msd1_col1 | String | Stores the comparison data value 1 that is retrieved from the first CMDB data source. | |
| msd1_col10 | String | Stores the comparison data value 10 that is retrieved from the first CMDB data source. | |
| msd1_col11 | String | Stores the comparison data value 11 that is retrieved from the first CMDB data source. | |
| msd1_col12 | String | Stores the comparison data value 12 that is retrieved from the first CMDB data source. | |
| msd1_col13 | String | Stores the comparison data value 13 that is retrieved from the first CMDB data source. | |
| msd1_col14 | String | Stores the comparison data value 14 that is retrieved from the first CMDB data source. | |
| msd1_col15 | String | Stores the comparison data value 15 that is retrieved from the first CMDB data source. | |
| msd1_col16 | String | Stores the comparison data value 16 that is retrieved from the first CMDB data source. | |
| msd1_col17 | String | Stores the comparison data value 17 that is retrieved from the first CMDB data source. | |
| msd1_col18 | String | Stores the comparison data value 18 that is retrieved from the first CMDB data source. | |
| msd1_col19 | String | Stores the comparison data value 19 that is retrieved from the first CMDB data source. | |
| msd1_col2 | String | Stores the comparison data value 2 that is retrieved from the first CMDB data source. | |
| msd1_col20 | String | Stores the comparison data value 20 that is retrieved from the first CMDB data source. | |
| msd1_col21 | String | Stores the comparison data value 21 that is retrieved from the first CMDB data source. | |
| msd1_col22 | String | Stores the comparison data value 22 that is retrieved from the first CMDB data source. | |
| msd1_col23 | String | Stores the comparison data value 23 that is retrieved from the first CMDB data source. | |
| msd1_col24 | String | Stores the comparison data value 24 that is retrieved from the first CMDB data source. | |
| msd1_col25 | String | Stores the comparison data value 25 that is retrieved from the first CMDB data source. | |
| msd1_col26 | String | Stores the comparison data value 26 that is retrieved from the first CMDB data source. | |
| msd1_col27 | String | Stores the comparison data value 27 that is retrieved from the first CMDB data source. | |
| msd1_col28 | String | Stores the comparison data value 28 that is retrieved from the first CMDB data source. | |
| msd1_col29 | String | Stores the comparison data value 29 that is retrieved from the first CMDB data source. | |
| msd1_col3 | String | Stores the comparison data value 3 that is retrieved from the first CMDB data source. | |
| msd1_col30 | Bool | Indicates whether the Boolean comparison result for column 30 is true in the first CMDB data source. | |
| msd1_col31 | Bool | Indicates whether the Boolean comparison result for column 31 is true in the first CMDB data source. | |
| msd1_col32 | Bool | Indicates whether the Boolean comparison result for column 32 is true in the first CMDB data source. | |
| msd1_col33 | Bool | Indicates whether the Boolean comparison result for column 33 is true in the first CMDB data source. | |
| msd1_col34 | Bool | Indicates whether the Boolean comparison result for column 34 is true in the first CMDB data source. | |
| msd1_col35 | Bool | Indicates whether the Boolean comparison result for column 35 is true in the first CMDB data source. | |
| msd1_col36 | Long | Stores a numeric comparison value for column 36 captured from the first CMDB data source. | |
| msd1_col37 | Long | Stores a numeric comparison value for column 37 captured from the first CMDB data source. | |
| msd1_col38 | Long | Stores a numeric comparison value for column 38 captured from the first CMDB data source. | |
| msd1_col39 | Long | Stores a numeric comparison value for column 39 captured from the first CMDB data source. | |
| msd1_col4 | String | Stores the comparison data value 4 that is retrieved from the first CMDB data source. | |
| msd1_col40 | Long | Stores a numeric comparison value for column 40 captured from the first CMDB data source. | |
| msd1_col41 | Long | Stores a numeric comparison value for column 41 captured from the first CMDB data source. | |
| msd1_col42 | Long | Stores a numeric comparison value for column 42 captured from the first CMDB data source. | |
| msd1_col43 | Long | Stores a numeric comparison value for column 43 captured from the first CMDB data source. | |
| msd1_col44 | Long | Stores a numeric comparison value for column 44 captured from the first CMDB data source. | |
| msd1_col45 | Long | Stores a numeric comparison value for column 45 captured from the first CMDB data source. | |
| msd1_col46 | Decimal | Stores a decimal comparison value for column 46 captured from the first CMDB data source. | |
| msd1_col47 | Decimal | Stores a decimal comparison value for column 47 captured from the first CMDB data source. | |
| msd1_col48 | Decimal | Stores a decimal comparison value for column 48 captured from the first CMDB data source. | |
| msd1_col49 | Decimal | Stores a decimal comparison value for column 49 captured from the first CMDB data source. | |
| msd1_col5 | String | Stores the comparison data value 5 that is retrieved from the first CMDB data source. | |
| msd1_col50 | Decimal | Stores a decimal comparison value for column 50 captured from the first CMDB data source. | |
| msd1_col51 | Datetime | Stores a datetime comparison value for column 51 captured from the first CMDB data source. | |
| msd1_col52 | Datetime | Stores a datetime comparison value for column 52 captured from the first CMDB data source. | |
| msd1_col53 | Datetime | Stores a datetime comparison value for column 53 captured from the first CMDB data source. | |
| msd1_col54 | Datetime | Stores a datetime comparison value for column 54 captured from the first CMDB data source. | |
| msd1_col6 | String | Stores the comparison data value 6 that is retrieved from the first CMDB data source. | |
| msd1_col7 | String | Stores the comparison data value 7 that is retrieved from the first CMDB data source. | |
| msd1_col8 | String | Stores the comparison data value 8 that is retrieved from the first CMDB data source. | |
| msd1_col9 | String | Stores the comparison data value 9 that is retrieved from the first CMDB data source. | |
| msd1_discovery_source | String | Lists the discovery source that supplied the first CMDB record for comparison. | |
| msd1_json | String | Stores the JSON representation of the first data source record for structured comparison. | |
| msd1_parent | String | References the parent record associated with the first CMDB data source entry. | |
| msd1_sys_created_by | String | Shows the user or process that created the first CMDB data source record. | |
| msd1_sys_created_on | Datetime | Displays the date and time when the first CMDB data source record was created. | |
| msd1_sys_domain | String | Specifies the domain to which the first CMDB data source record belongs. | |
| msd1_sys_mod_count | Int | Tracks how many times the first CMDB data source record has been modified. | |
| msd1_sys_tags | String | Lists any system tags assigned to the first CMDB data source record. | |
| msd1_sys_updated_by | String | Shows the user or process that last updated the first CMDB data source record. | |
| msd1_sys_updated_on | Datetime | Displays the date and time when the first CMDB data source record was last updated. | |
| msd2_sys_id | String | Lists the sys_id that uniquely identifies the second CMDB data source record. | |
| msd2_ci | String | References the CI associated with the second data source entry. | |
| msd2_class | String | Lists the CMDB class name defining the record type in the second data source. | |
| msd2_cmdb_reference | String | Specifies the reference field linking the second source record to a related CMDB entity. | |
| msd2_cmdb_reference_link | String | Provides the hyperlink reference to the related CMDB record from the second data source. | |
| msd2_col0 | String | Stores the comparison data value 0 that is retrieved from the second CMDB data source. | |
| msd2_col1 | String | Stores the comparison data value 1 that is retrieved from the second CMDB data source. | |
| msd2_col10 | String | Stores the comparison data value 10 that is retrieved from the second CMDB data source. | |
| msd2_col11 | String | Stores the comparison data value 11 that is retrieved from the second CMDB data source. | |
| msd2_col12 | String | Stores the comparison data value 12 that is retrieved from the second CMDB data source. | |
| msd2_col13 | String | Stores the comparison data value 13 that is retrieved from the second CMDB data source. | |
| msd2_col14 | String | Stores the comparison data value 14 that is retrieved from the second CMDB data source. | |
| msd2_col15 | String | Stores the comparison data value 15 that is retrieved from the second CMDB data source. | |
| msd2_col16 | String | Stores the comparison data value 16 that is retrieved from the second CMDB data source. | |
| msd2_col17 | String | Stores the comparison data value 17 that is retrieved from the second CMDB data source. | |
| msd2_col18 | String | Stores the comparison data value 18 that is retrieved from the second CMDB data source. | |
| msd2_col19 | String | Stores the comparison data value 19 that is retrieved from the second CMDB data source. | |
| msd2_col2 | String | Stores the comparison data value 2 that is retrieved from the second CMDB data source. | |
| msd2_col20 | String | Stores the comparison data value 20 that is retrieved from the second CMDB data source. | |
| msd2_col21 | String | Stores the comparison data value 21 that is retrieved from the second CMDB data source. | |
| msd2_col22 | String | Stores the comparison data value 22 that is retrieved from the second CMDB data source. | |
| msd2_col23 | String | Stores the comparison data value 23 that is retrieved from the second CMDB data source. | |
| msd2_col24 | String | Stores the comparison data value 24 that is retrieved from the second CMDB data source. | |
| msd2_col25 | String | Stores the comparison data value 25 that is retrieved from the second CMDB data source. | |
| msd2_col26 | String | Stores the comparison data value 26 that is retrieved from the second CMDB data source. | |
| msd2_col27 | String | Stores the comparison data value 27 that is retrieved from the second CMDB data source. | |
| msd2_col28 | String | Stores the comparison data value 28 that is retrieved from the second CMDB data source. | |
| msd2_col29 | String | Stores the comparison data value 29 that is retrieved from the second CMDB data source. | |
| msd2_col3 | String | Stores the comparison data value 3 that is retrieved from the second CMDB data source. | |
| msd2_col30 | Bool | Indicates whether the Boolean comparison result for column 30 is true in the second CMDB data source. | |
| msd2_col31 | Bool | Indicates whether the Boolean comparison result for column 31 is true in the second CMDB data source. | |
| msd2_col32 | Bool | Indicates whether the Boolean comparison result for column 32 is true in the second CMDB data source. | |
| msd2_col33 | Bool | Indicates whether the Boolean comparison result for column 33 is true in the second CMDB data source. | |
| msd2_col34 | Bool | Indicates whether the Boolean comparison result for column 34 is true in the second CMDB data source. | |
| msd2_col35 | Bool | Indicates whether the Boolean comparison result for column 35 is true in the second CMDB data source. | |
| msd2_col36 | Long | Stores a numeric comparison value for column 36 captured from the second CMDB data source. | |
| msd2_col37 | Long | Stores a numeric comparison value for column 37 captured from the second CMDB data source. | |
| msd2_col38 | Long | Stores a numeric comparison value for column 38 captured from the second CMDB data source. | |
| msd2_col39 | Long | Stores a numeric comparison value for column 39 captured from the second CMDB data source. | |
| msd2_col4 | String | Stores the comparison data value 4 that is retrieved from the second CMDB data source. | |
| msd2_col40 | Long | Stores a numeric comparison value for column 40 captured from the second CMDB data source. | |
| msd2_col41 | Long | Stores a numeric comparison value for column 41 captured from the second CMDB data source. | |
| msd2_col42 | Long | Stores a numeric comparison value for column 42 captured from the second CMDB data source. | |
| msd2_col43 | Long | Stores a numeric comparison value for column 43 captured from the second CMDB data source. | |
| msd2_col44 | Long | Stores a numeric comparison value for column 44 captured from the second CMDB data source. | |
| msd2_col45 | Long | Stores a numeric comparison value for column 45 captured from the second CMDB data source. | |
| msd2_col46 | Decimal | Stores a decimal comparison value for column 46 captured from the second CMDB data source. | |
| msd2_col47 | Decimal | Stores a decimal comparison value for column 47 captured from the second CMDB data source. | |
| msd2_col48 | Decimal | Stores a decimal comparison value for column 48 captured from the second CMDB data source. | |
| msd2_col49 | Decimal | Stores a decimal comparison value for column 49 captured from the second CMDB data source. | |
| msd2_col5 | String | Stores the comparison data value 5 that is retrieved from the second CMDB data source. | |
| msd2_col50 | Decimal | Stores a decimal comparison value for column 50 captured from the second CMDB data source. | |
| msd2_col51 | Datetime | Stores a datetime comparison value for column 51 captured from the second CMDB data source. | |
| msd2_col52 | Datetime | Stores a datetime comparison value for column 52 captured from the second CMDB data source. | |
| msd2_col53 | Datetime | Stores a datetime comparison value for column 53 captured from the second CMDB data source. | |
| msd2_col54 | Datetime | Stores a datetime comparison value for column 54 captured from the second CMDB data source. | |
| msd2_col6 | String | Stores the comparison data value 6 that is retrieved from the second CMDB data source. | |
| msd2_col7 | String | Stores the comparison data value 7 that is retrieved from the second CMDB data source. | |
| msd2_col8 | String | Stores the comparison data value 8 that is retrieved from the second CMDB data source. | |
| msd2_col9 | String | Stores the comparison data value 9 that is retrieved from the second CMDB data source. | |
| msd2_discovery_source | String | Lists the discovery source that supplied the second CMDB record for comparison. | |
| msd2_json | String | Stores the JSON representation of the second data source record for structured comparison. | |
| msd2_parent | String | References the parent record associated with the second CMDB data source entry. | |
| msd2_sys_created_by | String | Shows the user or process that created the second CMDB data source record. | |
| msd2_sys_created_on | Datetime | Displays the date and time when the second CMDB data source record was created. | |
| msd2_sys_domain | String | Specifies the domain to which the second CMDB data source record belongs. | |
| msd2_sys_mod_count | Int | Tracks how many times the second CMDB data source record has been modified. | |
| msd2_sys_tags | String | Lists any system tags assigned to the second CMDB data source record. | |
| msd2_sys_updated_by | String | Shows the user or process that last updated the second CMDB data source record. | |
| msd2_sys_updated_on | Datetime | Displays the date and time when the second CMDB data source record was last updated. |