Monitoring and analyzing connections added for Service Graph Connectors in SGC Central

  • Release version: Washingtondc
  • Updated May 1, 2025
  • 9 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 Monitoring and Analyzing Connections Added for Service Graph Connectors in SGC Central

    The Overview page in Service Graph Connector Central (SGC Central) within the CMDB Workspace offers administrators a centralized dashboard to monitor the installation, performance, and error handling of Service Graph Connectors. Access this dashboard by navigating to CMDB Workspace > SGC Central, and ensure you have the required roles: admin or cmdbinstadmin.

    Show full answer Show less

    Key Features

    • Connections Overview: Displays the current state of Service Graph Connector connections, including status and error summaries.
    • Ingested and Processed Data: Provides metrics related to data imported and processed from third-party applications.
    • Data Processing Performance: Shows how many configuration items (CIs) were added or updated and the number of processing errors over time.
    • Filters: Allows users to narrow down data shown in graphs and metrics based on connector type, connection, data source, or date range.
    • Indicators: Highlights metrics reflecting the volume and quality of imported data, helping to identify issues.
    • Reports: Offers real-time visualizations for insights into data ingestion, processing trends, and error categorization.

    Key Outcomes

    Utilizing the SGC Central dashboard enables administrators to proactively monitor and optimize data imports, effectively troubleshoot issues, and enhance overall performance of Service Graph Connectors. This results in improved data integrity and reduced operational disruptions, allowing for more efficient IT service management.

    The Overview page in the Service Graph Connector Central (SGC Central) view of the CMDB Workspace provides a centralized dashboard view for administrators to monitor the installation, performance, and error handling of Service Graph Connectors.

    SGC Central overview page.

    Access the SGC Central Overview page

    To open the dashboard, navigate to CMDB Workspace > SGC Central.

    Required roles

    • admin
    • cmdb_inst_admin

    Use cases

    For examples of how different people in your organization would use this dashboard, see these use cases.
    User Dashboard use

    Administrators or CMDB installation administrator

    Proactively monitor, analyze, and optimize data imports to identify issues and track performance.

    Overview page features

    Use the Overview page to monitor and troubleshoot your Service Graph Connectors connections through dedicated sections, filters, indicators, and visual reports and gain insights on the performance of Service Graph Connectors.

    Table 1. Feature description
    Feature Description
    Connections overview Displays the current state of your configured Service Graph Connector connections, including status, execution results, and error summaries.
    Ingested and processed data Displays key metrics related to the data imported and processed from third-party applications.
    Data processing performance Displays how many configuration items (CIs) were added or updated over time, in addition to the number of processing errors.
    Filters Enables narrowing the data shown in graphs and metrics based on connector type, connection, data source, or date range.
    Indicators Enables viewing of high-level metrics that reflect the volume and quality of imported data and help identify issues such as incomplete or failed import set processing.
    Reports Enables real-time visualizations that provide insights into data ingestion, processing trends, and error categorization across your Service Graph Connector connections.

    Connections overview

    Displays the current state of your configured Service Graph Connector connections, including status, execution results, and error summaries.

    Table 2. Connections overview section
    Card Description Card summary table
    Connection status Percentage of connections tested successfully based on connection status, with the count of success, error, and unknown statuses. The connection status summary table displays the following details:
    Connection
    Displays the name of the configured Service Graph Connector. Each entry links to more details about the connection.
    Connector type
    Displays the Service Graph Connector type as the integration source or platform for the connection.
    Connection status
    Displays the current state of each connection. Valid values include:
    Success
    All connections were configured and tested without errors.
    Error
    Connection configuration issues encountered during setup.
    Error summary
    Provides a short description of the most recent connection error, if any.
    Updated on
    Displays the timestamp of the last connection status update for each connection in the following format: YYYY-MM-DD HH:MM:SS.
    Processing status Percentage of connections for which all data import runs in the last import execution were successful, with the count of success and error statuses.
    Note:

    Only import sets that encountered errors during their last execution are counted as processing errors and shown on the card.

    		 The processing status summary table displays the following details:
    Connection
    Displays the name of the configured Service Graph Connector. Each entry links to more details about the connection.
    Last processing status
    Indicates the result of the most recent processing run. Valid values include:
    Success
    All scheduled jobs completed without errors.
    Error
    One or more jobs encountered issues during processing.
    Activated schedules
    Indicates the number of scheduled jobs that are activated for importing the data using the connection.
    Processed
    Indicates the total number of import set runs that were executed for the connection.
    Success
    Indicates how many of the processed import set runs completed successfully.
    Error
    Displays the number of import set runs that ended in an error, including those import sets that were canceled.
    Error summary
    Provides a short description of the most recent error, if any. The summary includes error type and cause.
    Last processed on
    Displays the timestamp of the last processing activity for the import set of the connection, including both successful and failed runs in the following format: YYYY-MM-DD HH:MM:SS.
    Ongoing executions Number of connections where data import execution is in progress. The ongoing execution status summary table displays the following details:
    Connection
    Displays the name of the configured Service Graph Connector. Each entry links to more details about the connection.
    Activated schedules
    Indicates the number of scheduled jobs that are activated for importing the data using the connection.
    In progress
    Displays how many scheduled jobs are currently running for the connection.
    Processed
    Displays the number of completed executions, where data has been collected and processed according to the configured scheduled job.
    Processing time
    Indicates the total duration taken by the most recent completed import set execution in the following format YYYY-MM-DD HH:MM:SS.

    Ingested and processed data

    Displays key metrics related to the data imported and processed from third-party applications.
    Table 3. Ingested and processed data section
    Card Description Indicators
    Import sets Number of import sets processed by data sources based on the selected filters, with the count of success, partial, and error statuses.

    Select the View all import sets link to view a complete list of processed import sets.

    SGC.Integrations.ImportSet

    SGC.Fully.successful.ImportSet

    SGC.Part.success.ImportSet

    SGC.Fully.error.ImportSet
    Imported rows Count of rows imported across all import sets based on the selected filters.

    Select the View all latest import set rows ingested link to view a complete list of import set rows ingested.

    		 SGC.Integrations.Importset.rows.ingested
    CIs Total CIs processed based on the selected filters, with the count of added and updated CIs.

    Select the View all inserted and updated records link to view a complete list of inserted and updated CIs.

    		 None
    Partial or incomplete CIs Total CIs that are partial payloads based on the selected filters, with the count of partial and incomplete categories.

    Select the View all partial and incomplete records link to view a complete list of partial and incomplete CIs.

    		 None

    Data processing performance

    Displays how many configuration items (CIs) were added or updated over time, in addition to the number of processing errors.
    Table 4. Data processing performance section
    Card Description Indicators
    CIs and errors trends Daily trends for CIs that were added, updated, and any data processing errors occurred during data import process based on the selected filters.

    Records added

    Records updated

    Errors
    Processing time Top 10 connections by the latest import set processing time.

    Select the View all latest import sets link to view a complete list of import sets.

    		 None
    Processing errors Top 10 connections with the highest number of data processing errors, with a breakup by data source, connection, and credential issues.

    Select the View all latest errors link to view a complete list of processing errors.

    		 None

    Filters

    Enables narrowing the data shown in graphs and metrics based on connector type, connection, data source, or date range.
    Name Type Description
    Connector type List Filters a list of installed Service Graph Connectors.
    Connection List Filters a list of connection records for the Service Graph Connectors.
    Data source List Filters a list of data sources for the Service Graph Connectors.
    Date range Date Filters the SGC Central dashboard data based on the date range selected.

    Indicators

    Enables viewing of high-level metrics that reflect the volume and quality of imported data and help identify issues such as incomplete or failed import set processing.
    Records added
    Total number of records that were inserted into the system on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_audit table. The score is calculated by counting the number of records updated on the specified day, based on operations that were marked as inserted in the audit log.
    Records updated
    Total number of records that were updated in the system on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_audit table. The score is calculated by counting the number of records updated on the specified day, based on operations that were marked as Updated in the audit log.
    Records added or updated
    Total number of records that were added or updated in the system on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_audit table. The score is calculated by counting the number of records inserted or updated on the specified day, based on operations that were marked as Inserted or Updated in the audit log.
    Errors
    Total number of errors categorized under credentials, data source, or connection issues that occurred during integration executions on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_error table. The score is calculated by counting the number of errors on the specified day.
    SGC.processing.errors
    Number of processing errors categorized under data source issues that occurred during integration executions on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_error table. The score is calculated by counting the number of errors on the specified day.
    SGC.connection.errors
    Total number of errors categorized under credentials or connection issues that occurred during integration executions on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_error table. The score is calculated by counting the number of errors on the specified day.
    SGC.Integrations.ImportSet
    Total number of import sets that were either completed successfully or encountered errors during their transformation process on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_import_set table. The score is calculated by counting the total number of import sets on the specified day.
    SGC.Fully.successful.ImportSet
    Total number of import sets that were completed successfully during their transformation process on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_import_set table. The score is calculated according to this formula: Count of import sets with Errors = 0.
    SGC.Fully.error.ImportSet
    Total number of import sets that completed with errors during their transformation process on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_import_set table. The score is calculated according to this formula: Count of import sets with Errors ≠ 0 and Rows = Errors.
    SGC.Part.success.ImportSet
    Total number of import sets that completed with some errors where the number of rows processed differs from the number of errors reported on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution_import_set table. The score is calculated according to this formula: Count of import sets with Errors ≠ 0 and Rows ≠ Errors.
    SGC.Integrations.Importset.rows.ingested
    Total number of rows ingested for the import sets on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution table. The score is calculated according to this formula: Sum of rows ingested.
    SGC.Integrations.Processing Rate
    Average processing rate of import sets based on the total number of rows processed and the total processing time (in hours) for the import sets that either completed successfully or encountered errors on the previous day, as recorded in the sn_cmdb_int_util_cmdb_integration_execution table. The score is calculated according to this formula: Sum of rows processed​/Total time (in hours).

    Reports

    Enables real-time visualizations that provide insights into data ingestion, processing trends, and error categorization across your Service Graph Connector connections.
    Title Type Source table Description
    Affected CIs and errors Relative compare (Relative compare) CMDB Integration Execution Error [sn_cmdb_int_util_cmdb_integration_execution_error] Displays configuration items (CIs) added, CIs updated, and cumulative errors occurred during data import over time.
    Error breakdown Column (Column icon) CMDB Integration Execution Error [sn_cmdb_int_util_cmdb_integration_execution_error] Displays the count of errors grouped over time.
    Import set rows ingested Single score (Single score icon) CMDB Integration Execution Import Set [sn_cmdb_int_util_cmdb_integration_execution_import_set] Displays the number of import set rows ingested in a day.

    Import set processing rate

    		 Single score (Single score icon) CMDB Integration Execution [sn_cmdb_int_util_cmdb_integration_execution]

    Displays the average rate at which an import set processes data within an hour.
    Records added or updated Single score (Single score icon) CMDB Integration Execution Audit [sn_cmdb_int_util_cmdb_integration_execution_audit] Displays the number of records that were updated or added for CI classes.
    Total import sets Single score (Single score icon) CMDB Integration Execution Import Set [sn_cmdb_int_util_cmdb_integration_execution_import_set] Displays the number of import sets initialized by data sources in the given time frame and the count of import sets categorized by their status.
    Updated classes Column (Column icon) CMDB Integration Execution Audit [sn_cmdb_int_util_cmdb_integration_execution_audit] Displays the breakdown of updated and inserted CIs for a class.