Components related to CMDB 360

  • Release version: Xanadu
  • Updated August 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 such as properties, tables, and roles that enable enhanced configuration management database capabilities. Understanding these components is crucial for effective management and utilization of the CMDB 360 features.

    Show full answer Show less

    Key Features

    • Properties: Access and modify properties on the CMDB 360 Properties page, requiring the cmdbmsadmin role. Key properties include:
      • glide.identificationengine.multisourceenabled: Activates CMDB 360 (default: false).
      • glide.identificationengine.multisourcecmdbcienabled: Captures data from CMDB classes (default: true).
      • glide.identificationengine.multisourcenoncmdbcienabled: Captures data from non-CMDB classes (default: false).
      • Query Limits: Properties set maximum limits for query results and recompute operations, affecting performance (e.g., glide.identificationengine.multisource.query.batch.limit).
      • Logging: Enable logging for CMDB 360 with varying levels (info, warn, error, etc.).
    • Tables: Key tables associated with CMDB 360 include:
      • CMDB 360 Data: Stores raw data from discovery sources.
      • CMDB Multisource Queries: User-created query definitions.
      • CMDB 360 denied classes: Excludes certain classes from data collection.
      • CMDB 360 Analytics Skipped Class: Records classes that exceed the defined threshold for multisource records.
    • Roles: Different user roles determine access levels:
      • cmdbmsread: Can run queries but not create them.
      • cmdbmseditor: Can create and run queries.
      • cmdbmsadmin: Full access to create queries and modify properties.

    Key Outcomes

    By effectively managing the properties, tables, and roles associated with CMDB 360, ServiceNow customers can enhance their data management capabilities. Optimizing these components allows for improved data accuracy, performance, and reporting in CMDB 360, leading to more informed decision-making and operational efficiency.

    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 Discovery sources 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.