Power BI Connector for ServiceNow

Build 25.0.9454

assoc_roles

Displays associations between users and roles to support access management and role-based permissions analysis.

Columns

Name Type References Description
pkg_sys_id String Defines the system identifier (sys_id) of the associated package that contains the role definition.
pkg_active Bool Indicates whether the associated package is currently active and available in ServiceNow.
pkg_enforce_license String Specifies the license enforcement policy applied to the package to control access or usage.
pkg_licensable Bool Indicates whether the package requires licensing for use within the ServiceNow instance.
pkg_license_category String Lists the license category assigned to the package, such as subscription type or product classification.
pkg_license_model String Specifies the license model used by the package, defining how access or usage is measured.
pkg_name String Lists the name of the package that groups related modules, applications, or functionality.
pkg_source String Identifies the origin or provider of the package, such as ServiceNow Store or a custom-developed source.
pkg_sys_class_name String Specifies the system class name of the package record as defined in the ServiceNow Configuration Management Database (CMDB).
pkg_sys_created_by String Shows the user or process that originally created the package record.
pkg_sys_created_on Datetime Displays the date and time when the package record was first created in ServiceNow.
pkg_sys_mod_count Int Tracks the number of times the package record has been modified.
pkg_sys_tags String Lists any system tags assigned to the package record for categorization or tracking.
pkg_sys_updated_by String Shows the user or process that last modified the package record.
pkg_sys_updated_on Datetime Displays the date and time when the package record was last updated.
pkg_trackable Bool Indicates whether the package is configured to be tracked for licensing or audit purposes.
pkg_version String Lists the version number of the package to help identify its release or update level.
role_sys_id String Defines the sys_id of the role associated with the package or licensing information.
role_assignable_by String Specifies the user or role that has permission to assign the given role to others.
role_assignable_by_link String Provides the hyperlink reference to the record of the role or user who can assign this role.
role_can_delegate Bool Indicates whether users with this role can delegate it to others within the ServiceNow environment.
role_description String Provides a description of the role, outlining its purpose and the permissions it grants.
role_elevated_privilege Bool Indicates whether the role provides elevated privileges, such as administrative access.
role_grantable Bool Indicates whether the role can be granted directly to a user or must be inherited through another role.
role_includes_roles String Lists any additional roles included as part of this role's access bundle.
role_name String Displays the name of the role as defined in the system.
role_requires_subscription String Specifies whether the role requires an active subscription to be assigned.
role_scoped_admin Bool Indicates whether the role provides scoped administrative rights within an application.
role_suffix String Lists the suffix used to distinguish the role name from others within the same scope.
role_sys_class_name String Specifies the system class name of the role record stored in the CMDB.
role_sys_created_by String Shows the user or process that created the role record.
role_sys_created_on Datetime Displays the date and time when the role record was initially created.
role_sys_mod_count Int Tracks the number of times the role record has been modified since creation.
role_sys_name String Specifies the system name of the role record for internal identification.
role_sys_package String Defines the sys_id of the package containing the role record.
role_sys_package_link String Provides the hyperlink reference to the package record that includes the role.
role_sys_policy String Specifies any system policy associated with the role to enforce access control or licensing rules.
role_sys_scope String Defines the scope of the role, indicating which application or module it applies to.
role_sys_scope_link String Provides the hyperlink reference to the scope record associated with the role.
role_sys_tags String Lists any system tags linked to the role record for classification or audit purposes.
role_sys_update_name String Displays the update set name or record identifier related to the most recent update of the role.
role_sys_updated_by String Shows the user or process that last updated the role record.
role_sys_updated_on Datetime Displays the date and time when the role record was last modified.
fmly_sys_id String Defines the sys_id of the family record grouping related applications or modules.
fmly_app_id String Specifies the unique application identifier within the family record.
fmly_app_name String Lists the name of the application that belongs to the associated family.
fmly_cust_visible Bool Indicates whether the family record is visible to customers in the ServiceNow instance.
fmly_for_fee Bool Specifies whether the family application or module requires a paid license or fee.
fmly_last_valid_rel String Displays the last valid release version for the associated application family.
fmly_level Int Specifies the hierarchy level of the application within the family structure.
fmly_license_check_required Bool Indicates whether the family requires a license validation check before activation.
fmly_lineage_id String Stores the lineage identifier that connects related versions of the family application.
fmly_lineage_name String Lists the name associated with the family lineage for version tracking.
fmly_lob_id String Defines the line-of-business (LOB) identifier associated with the family application.
fmly_lob_name String Lists the name of the LOB linked to the family application.
fmly_primary Bool Indicates whether the application is marked as the primary module within its family.
fmly_scope String Specifies the scope under which the family application operates in ServiceNow.
fmly_skip_custom_role_eval Bool Indicates whether the family should skip custom role evaluation during license or access validation.
fmly_sys_created_by String Shows the user or process that created the family record.
fmly_sys_created_on Datetime Displays the date and time when the family record was created in ServiceNow.
fmly_sys_mod_count Int Tracks the number of modifications made to the family record.
fmly_sys_tags String Lists any system tags associated with the family record for categorization.
fmly_sys_updated_by String Shows the user or process that last updated the family record.
fmly_sys_updated_on Datetime Displays the date and time when the family record was last updated in ServiceNow.

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