Power BI Connector for ServiceNow

Build 25.0.9454

query_based_service_mapping

Maps query-based services to their related components or dependencies.

Columns

Name Type References Description
comp_sys_id String Provides the system identifier (sys_id) for the component Configuration Item (CI) included in the service mapping.
comp_ip_address String Displays the IP address associated with the component CI.
comp_name String Shows the name of the component CI, typically its hostname or descriptive label.
comp_os String Indicates the operating system installed on the component CI.
comp_os_version String Specifies the version of the operating system running on the component CI.
comp_sys_class_name String Defines the system class name of the component CI, identifying its record type within the system.
ciassoc_ci_id String References the CI that is part of the association between a configuration item and a service.
ciassoc_ci_id_link String Provides a link to the CI record referenced in the configuration item association.
ciassoc_service_id String References the service associated with the configuration item, linking it to the overall service map.
ciassoc_service_id_link String Provides a link to the service record connected to the configuration item association.
compvirt_sys_id String Provides the sys_id for the virtual component CI in the mapping.
compvirt_name String Displays the name of the virtual component CI involved in the service mapping.
compvirt_sys_class_name String Defines the system class name for the virtual component CI.
rel_child String References the child CI in a relationship, representing a dependent component within the service structure.
rel_child_link String Provides a link to the child CI record in the relationship.
rel_parent String References the parent CI in a relationship, representing a higher-level or hosting component.
rel_parent_link String Provides a link to the parent CI record in the relationship.
rel_type String Specifies the type of relationship between configuration items, such as 'depends on' or 'runs on'.
rel_type_link String Provides a link to the record defining the relationship type.
relvirt_child String References the child CI in a virtual relationship, typically representing a virtual dependency or logical mapping.
relvirt_child_link String Provides a link to the child CI record within the virtual relationship.
relvirt_parent String References the parent CI in a virtual relationship, representing the main or controlling element.
relvirt_parent_link String Provides a link to the parent CI record in the virtual relationship.
relvirt_type String Specifies the type of virtual relationship between configuration items in the service mapping.
relvirt_type_link String Provides a link to the record that defines the virtual relationship type.
ci_sys_id String Provides the sys_id for the primary CI represented in the query-based service mapping.
ci_name String Displays the name of the CI included in the query-based service mapping.
ci_sys_class_name String Defines the system class name of the CI, identifying its type within the Configuration Management Database (CMDB).

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454