Monitoring and analyzing connections added for Service Graph Connectors in SGC Central
The Overview page in the Service Graph Connector Central (SGC Central) view of the Service Graph Workspace or 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 either Service Graph Workspace > SGC Central or CMDB Workspace > SGC Central.
Required roles
- SGC-admin
- 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 SGC-admin | 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.
| 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.
| 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.
Displays the Service Graph Connector type as the integration source or platform for the connection.
Displays the current state of each connection. Valid values include:
All connections were configured and tested without errors.
Connection configuration issues encountered during setup.
Provides a short description of the most recent connection error, if any.
Displays the timestamp of the last connection status update for each connection in the following format: |
| 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.
Indicates the result of the most recent processing run. Valid values include:
All scheduled jobs completed without errors.
One or more jobs encountered issues during processing.
Indicates the number of scheduled jobs that are activated for importing the data using the connection.
Indicates the total number of import set runs that were executed for the connection.
Indicates how many of the processed import set runs completed successfully.
Displays the number of import set runs that ended in an error, including those import sets that were canceled.
Provides a short description of the most recent error, if any. The summary includes error type and cause. A View details link may be available for diagnosing a processing error. To learn more, see Diagnose a processing error in SGC Central.
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: |
| 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.
Indicates the number of scheduled jobs that are activated for importing the data using the connection.
Displays how many scheduled jobs are currently running for the connection.
Displays the number of completed executions, where data has been collected and processed according to the configured scheduled job.
Indicates the total duration taken by the most recent completed import set execution in the following format |
Ingested and processed data
Displays key metrics related to the data imported and processed from third-party applications.
| 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.
| 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 \( Image omitted: relative-compare-icon.png 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 \( Image omitted: column-icon.png 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 \( Image omitted: icon-single-score-report-p.png 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 \( Image omitted: icon-single-score-report-p.png 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 \( Image omitted: icon-single-score-report-p.png 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 \( Image omitted: icon-single-score-report-p.png 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 \( Image omitted: column-icon.png 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. |