Components related to CMDB 360

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 4 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Components related to CMDB 360

    CMDB 360, part of the com.snc.cmdb plugin, includes various components like properties, tables, and roles essential for managing configuration data. Understanding these components is crucial for effective data management and reporting within ServiceNow.

    Show full answer Show less

    Key Features

    • Properties: Accessed via All > Configuration > CMDB 360 Properties. Key properties include:
      • glide.identificationengine.multisourceenabled: Activates CMDB 360 (default: false).
      • glide.identificationengine.multisourcecmdbcienabled: Captures data for CIs from CMDB classes (default: true).
      • glide.identificationengine.multisourcenoncmdbcienabled: Captures data for non-CMDB classes (default: false).
      • glide.cmdb.logger.source.cmdbmultisource: Enables logging for CMDB 360 with various log levels (info, warn, error, etc.).
      • sncmdbws.ms.reportclasscicountmaxthreshold: Sets a threshold for multisource records, controlling data population in Coverage charts (default: 10 million).
    • Tables: Key tables include:
      • CMDB 360 Data: Stores raw data from discovery sources.
      • CMDB Multisource Queries: User-created query definitions.
      • CMDB 360 Analytics Skipped Class: Stores records of classes excluded from data collection based on set thresholds.
    • Roles: Three roles manage access and capabilities:
      • cmdbmsread: Read access to queries.
      • cmdbmseditor: Create and run queries.
      • cmdbmsadmin: Full access to create, run queries, and modify properties.

    Key Outcomes

    By utilizing these components effectively, ServiceNow customers can enhance their CMDB data management, improve query performance, and optimize reporting capabilities. Proper configuration of properties and understanding of roles enables efficient data analysis and decision-making within the platform.

    Several types of components are related to CMDB 360 (included in the com.snc.cmdb plugin), such as tables and properties.

    Properties

    Open the CMDB 360 Properties page by navigating to All > Configuration > CMDB 360 Properties. You can hover over the '?' icon for a property, to show property names.

    You must have the cmdb_ms_admin role to modify property values.
    Property Description
    glide.identification_engine.multisource_enabled

    Enables CMDB 360.

    • Type: true | false
    • Default value: false
    • Location: CMDB 360 Properties page
    glide.identification_engine.multisource_cmdb_ci_enabled​

    Enables capturing CMDB 360 data for CIs from CMDB classes (derived from the cmdb_ci class).

    • Type: true | false
    • Default value: true
    • Location: CMDB 360 Properties page
    glide.identification_engine.multisource_non_cmdb_ci_enabled

    Enables capturing CMDB 360 data for CIs from non-CMDB classes (not derived from the cmdb_ci class). For example, the Serial Number [cmdb_serial_number] class, or the Software instance [cmdb_software_instance] class.

    • Type: true | false
    • Default value: false
    • Location: CMDB 360 Properties page
    glide.identification_engine.multisource.query.batch.limit​

    Max number of items to show per query results page, in the CMDB 360 Report Builder. Changing the value of this property, might affect performance when running a query.

    • Type: numeric
    • Default value: 100
    • Location: CMDB 360 Properties page
    glide.identification_engine.multisource.query.max.limit​

    Max number of query results to show when you click Load All Results in the CMDB 360 Report Builder. Changing the value of this property, might affect performance when running a query.

    • Type: numeric
    • Default value: 10000
    • Location: CMDB 360 Properties page
    glide.identification_engine.multisource.recompute.max.ci.limit

    Max number of CIs that can be included in a CMDB 360 recompute operation.

    • Type: numeric
    • Default value: 100000
    • Location: CMDB 360 Properties page
    glide.cmdb.logger.source.cmdb_multisource​

    Enable logging for CMDB 360. CMDB 360 logs are stored in the Log [syslog] table with source set to "cmdb_multisource".
    sn_cmdb_ws.ms.calculate_cmdb_only

    Limits the scope of data in the Coverage tile in the CMDB 360 dashboard in CMDB Workspace, to CMDB classes only (derived from the cmdb_ci class).
    sn_cmdb_ws.ms.report_class_ci_count_max_threshold

    Threshold number of multisource records that when exceeded for a class, CMDB 360 Coverage charts in CMDB Workspace stop populating data for that class (CMDB or non-CMDB tables).

    When the specified threshold number is reached for a class, the system creates a record in the CMDB 360 Analytics Skipped Class [sn_cmdb_ws_ms_skip_class] table causing that class to be skipped in future job runs.

    Note:
    Managing class inclusion in the Coverage charts, by using this system property and the CMDB 360 Analytics Skipped Class [sn_cmdb_ws_ms_skip_class] table, can greatly decrease or increase performance of the Coverage chart job.

    Tables

    Table Description
    CMDB 360 Data

    [cmdb_multisource_data]

    		 CMDB 360 data store. Contains the raw data sent by all discovery sources.
    CMDB MultiSource Column Metadata

    [cmdb_multisource_column_metadata]

    		 Mapping of attributes for each class to floatable columns​. Used to improves performance of queries that involve high volumes of data​.
    CMDB Multisource Queries

    [cmdb_multisource_query]

    		 CMDB 360 query definitions created by the user in CMDB Workspace or in the legacy Multisource Report Builder.
    Query Status

    [cmdb_multisource_query_status]

    		 State of execution, of queries created in CMDB Workspace or in the legacy Multisource Report Builder.
    CMDB Multisource Query Results

    [cmdb_multisource_query_result]​ ​

    		 Results for queries created in CMDB Workspace or in the legacy Multisource Report Builder, configured with result type of CI records.​
    CMDB Multisource Query Result Multisource Records

    [cmdb_multisource_query_result_ms_record]

    		 Results for queries created in CMDB Workspace or in the legacy Multisource Report Builder, configured with result type of CMDB 360 records.
    CMDB Multisource Query Result Discovery Sources

    [cmdb_multisource_query_result_disco_source]​

    		 Results for queries created in CMDB Workspace or in the legacy Multisource Report Builder, configured with result type of Discovery source records.
    CMDB MultiSource Recompute Task CIs

    [cmdb_multisource_recomp_task_ci​]

    		 All Cis that are involved in a recompute operation.​
    CMDB Multisource Recompute Tasks

    [cmdb_multisource_recomp_task​]

    		 Recomputation requests and progress status.
    CMDB 360 denied classes

    [cmdb_multisource_deny_class]

    		 Classes that are excluded from CMDB 360 data collection and processing. For any class with an active record, there won't be any data in the CMDB 360 Data [cmdb_multisource_data] table.
    CMDB 360 Analytics Skipped Class

    [sn_cmdb_ws_ms_skip_class]

    Internally used to store records of classes for which the threshold number of multisource records, as set in the sn_cmdb_ws.ms.report_class_ci_count_max_threshold property, has exceeded. Classes in this table are excluded from the Coverage charts in CMDB Workspace.

    You can set the Override class CI records population column for an excluded class to 'true', to include it in Coverage charts future computations.

    Note:
    Managing class inclusion in the Coverage charts, by using this table and the sn_cmdb_ws.ms.report_class_ci_count_max_threshold system property, can greatly decrease or increase performance of the Coverage chart job.

    Roles

    Role Description
    cmdb_ms_read Can access and run a CMDB 360 query but can't create a query. Contains cmdb_read role.
    cmdb_ms_editor Can create and run a query, has full read and write access, but can't do Recompute. Contains cmdb_ms_read role.
    cmdb_ms_admin Can create and run a query, and can modify CMDB 360 properties. Contains cmdb_ms_write role.