Power BI Connector for ServiceNow

Build 25.0.9454

ast_license_base

Maintains software license information such as license types, entitlements, and usage limits.

Columns

Name Type ReadOnly References Description
number String False

Lists the unique license record number used to identify each license entry in ServiceNow.

vendor_account String False

Specifies the vendor account associated with the license, linking it to the supplier or reseller providing the software.

license_count String False

Displays the total number of licenses covered under the current license record.

option String False

Lists any specific license options or configurations applied to the product, such as upgrade rights or add-ons.

sys_created_on Datetime False

Shows the date and time when the license record was first created in ServiceNow.

vendor String False

Lists the name of the vendor providing or managing the licensed software.

license_key String False

Stores the unique alphanumeric key assigned to the licensed product for activation and validation purposes.

upgraded_from String False

Indicates the source license or product version from which the current license was upgraded.

sys_updated_on Datetime False

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

sys_class_name String False

Identifies the system class name assigned to the license record within the ServiceNow data model.

short_description String False

Provides a concise summary of the licensed software or agreement details.

license_cost String False

Specifies the total cost of the software license as defined in the purchase or agreement.

sys_id [KEY] String False

Defines the system identifier (sys_id) that uniquely identifies the license record in ServiceNow.

invoice_number String False

Lists the invoice number associated with the license purchase or renewal.

location String False

Specifies the location or business unit responsible for managing the licensed software.

percent_used String False

Displays the percentage of licenses currently in use compared to the total available quantity.

vendor_contract String False

References the vendor contract associated with the license record to establish the purchase link.

install_count String False

Shows the number of active installations using the licensed software.

manual String False

Indicates whether the license entry was created or updated manually rather than through automated discovery.

sys_created_by String False

Shows the user or process that originally created the license record.

department String False

Lists the department responsible for managing or utilizing the licensed software.

description String False

Provides detailed notes or documentation about the license, such as coverage, terms, or restrictions.

maintenance_cost String False

Specifies the recurring maintenance or support cost associated with the license.

sys_updated_by String False

Shows the user or process that last modified the license record.

parent String False

Defines the parent license record, if the current license is part of a multi-tier or hierarchical agreement.

purchased Datetime False

Lists the date and time when the license was purchased or activated.

total_cost String False

Displays the total cost incurred for the license, including maintenance and support charges.

compliance_level String False

Indicates the compliance level of the license, showing whether usage meets entitlement limits.

po_number String False

Specifies the purchase order (PO) number linked to the license transaction.

license_available String False

Displays the number of licenses still available for assignment or deployment.

discoverable_key String False

Stores the software discovery key used to detect and reconcile installed products with licensed assets.

sys_mod_count String False

Tracks the number of modifications made to the license record since its creation.

ItemURL String True

Provides the URL linking directly to the license record in the ServiceNow user interface (UI).

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