Power BI Connector for ServiceNow

Build 25.0.9454

cmdb_ci

Stores configuration item (CI) records representing hardware, software, and services managed in the Configuration Management Database (CMDB).

Columns

Name Type ReadOnly References Description
name String False

Lists the CI's name used to identify it within the CMDB.

serial_number String False

Stores the unique serial number assigned to the CI.

delivery_date Datetime False

Records the delivery date of the CI to the organization or user.

lease_id String False

Lists the lease identifier that links the CI to its leasing contract.

checked_out Datetime False

Displays the date and time when the CI was checked out for use.

sys_domain_path String False

Defines the hierarchical domain path representing the CI's location in the domain structure.

sys_created_by String False

Shows the user or process that originally created the CI record in ServiceNow.

purchase_date Datetime False

Records the date when the CI was purchased.

location String False

Lists the physical or logical location associated with the CI.

cost_cc String False

Specifies the cost center code associated with the CI for financial tracking.

managed_by String False

Identifies the user or group responsible for managing the CI.

sys_updated_by String False

Shows the user or process that last updated the CI record.

assignment_group String False

Lists the assignment group responsible for maintaining or servicing the CI.

model_id String False

References the model record associated with the CI.

gl_account String False

Specifies the general ledger (GL) account code used for accounting the CI.

supported_by String False

Lists the user or team providing support for the CI.

unverified String False

Indicates whether the CI data has not yet been verified.

company String False

Lists the company or organization that owns or uses the CI.

manufacturer String False

Lists the manufacturer of the CI.

po_number String False

Records the purchase order (PO) number associated with the CI.

due_in String False

Specifies the number of items expected to arrive or be received for the CI.

asset String False

Links the CI to its corresponding asset record for inventory tracking.

sys_mod_count String False

Tracks the total number of times the CI record has been modified.

asset_tag String False

Stores the asset tag identifier physically attached to the CI.

sys_class_name String False

Specifies the system class name defining the CI record type within ServiceNow.

order_date Datetime False

Lists the date when the CI order was placed.

department String False

Identifies the department responsible for or using the CI.

checked_in Datetime False

Displays the date and time when the CI was checked back into inventory or returned.

sys_domain String False

Specifies the domain to which the CI belongs in multi-domain environments.

sys_updated_on Datetime False

Displays the date and time when the CI record was last updated.

install_status String False

Lists the installation status of the CI, such as installed, pending, or retired.

justification String False

Provides a justification or reason for creating or updating the CI record.

cost String False

Lists the cost associated with purchasing or maintaining the CI.

owned_by String False

Identifies the user or department that owns the CI.

assigned Datetime False

Displays the date and time when the CI was assigned to a user or department.

vendor String False

Lists the vendor or supplier of the CI.

invoice_number String False

Records the invoice number related to the CI purchase or lease.

support_group String False

Lists the group responsible for providing technical or operational support for the CI.

skip_sync String False

Indicates whether synchronization of the CI record should be skipped during updates.

assigned_to String False

Identifies the user currently assigned to the CI.

install_date Datetime False

Displays the date when the CI was installed in the environment.

warranty_expiration Datetime False

Lists the warranty expiration date for the CI.

due Datetime False

Displays the due date for maintenance, renewal, or replacement of the CI.

cost_center String False

Lists the cost center associated with the CI for accounting and budgeting.

sys_created_on Datetime False

Displays the date and time when the CI record was created.

short_description String False

Provides a brief description summarizing the CI and its purpose.

attributes String False

Lists key attributes that describe technical or operational properties of the CI.

fault_count String False

Tracks the number of faults or incidents reported against the CI.

change_control String False

Specifies the change control record or process governing modifications to the CI.

fqdn String False

Lists the Fully Qualified Domain Name (FQDN) assigned to the CI, if applicable.

subcategory String False

Lists the subcategory classification of the CI for reporting or grouping.

last_discovered Datetime False

Displays the date and time when the CI was last discovered by an automated discovery process.

correlation_id String False

Stores a correlation identifier used to link the CI to related external records or processes.

discovery_source String False

Specifies the discovery source that identified or imported the CI.

mac_address String False

Lists the Media Access Control (MAC) address associated with the CI, if it is a networked device.

maintenance_schedule String False

References the maintenance schedule that applies to the CI.

model_number String False

Lists the manufacturer's model number assigned to the CI.

monitor String False

Indicates whether the CI is monitored for performance or availability.

sys_id [KEY] String False

Lists the system identifier (sys_id) that uniquely identifies the CI record in ServiceNow.

operational_status String False

Specifies the operational status of the CI, such as operational or down.

start_date Datetime False

Lists the start date of the CI's lifecycle or operational period.

dns_domain String False

Lists the Domain Name System (DNS) domain to which the CI belongs.

category String False

Lists the category used to classify the CI within the CMDB.

first_discovered Datetime False

Displays the date and time when the CI was first discovered by an automated process.

can_print String False

Indicates whether the CI is capable of printing, applicable for printer devices.

comments String False

Stores comments or notes added to the CI record.

ip_address String False

Lists the IP address assigned to the CI, if applicable.

schedule String False

References the operational or maintenance schedule associated with the CI.

ItemURL String True

Lists the URL that represents the item accessible from the ServiceNow user interface (UI).

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