user_has_license_role
The ServiceNow view user_has_license_role.
Columns
| Name | Type | References | Description |
| u_sys_id | String | ||
| u_accumulated_roles | String | ||
| u_active | Bool | ||
| u_avatar | String | ||
| u_building | String | ||
| u_building_link | String | ||
| u_calendar_integration | Int | ||
| u_city | String | ||
| u_company | String | ||
| u_company_link | String | ||
| u_cost_center | String | ||
| u_cost_center_link | String | ||
| u_country | String | ||
| u_date_format | String | ||
| u_default_perspective | String | ||
| u_default_perspective_link | String | ||
| u_department | String | ||
| u_department_link | String | ||
| u_edu_status | String | ||
| u_email | String | ||
| u_employee_number | String | ||
| u_enable_multifactor_authn | Bool | ||
| u_failed_attempts | Int | ||
| u_first_name | String | ||
| u_gender | String | ||
| u_home_phone | String | ||
| u_internal_integration_user | Bool | ||
| u_introduction | String | ||
| u_last_login | Date | ||
| u_last_login_device | String | ||
| u_last_login_time | Datetime | ||
| u_last_name | String | ||
| u_last_password | String | ||
| u_ldap_server | String | ||
| u_ldap_server_link | String | ||
| u_location | String | ||
| u_location_link | String | ||
| u_locked_out | Bool | ||
| u_manager | String | ||
| u_manager_link | String | ||
| u_middle_name | String | ||
| u_mobile_phone | String | ||
| u_name | String | ||
| u_notification | Int | ||
| u_password_needs_reset | Bool | ||
| u_phone | String | ||
| u_photo | String | ||
| u_preferred_language | String | ||
| u_roles | String | ||
| u_schedule | String | ||
| u_schedule_link | String | ||
| u_source | String | ||
| u_sso_source | String | ||
| u_state | String | ||
| u_street | String | ||
| u_sys_class_name | String | ||
| u_sys_created_by | String | ||
| u_sys_created_on | Datetime | ||
| u_sys_domain | String | ||
| u_sys_domain_path | String | ||
| u_sys_mod_count | Int | ||
| u_sys_tags | String | ||
| u_sys_updated_by | String | ||
| u_sys_updated_on | Datetime | ||
| u_time_format | String | ||
| u_time_zone | String | ||
| u_title | String | ||
| u_u_user_name | String | ||
| u_user_name | String | ||
| u_user_password | String | ||
| u_vip | Bool | ||
| u_web_service_access_only | Bool | ||
| u_zip | String | ||
| ur_sys_id | String | ||
| ur_assignable_by | String | ||
| ur_assignable_by_link | String | ||
| ur_can_delegate | Bool | ||
| ur_description | String | ||
| ur_elevated_privilege | Bool | ||
| ur_grantable | Bool | ||
| ur_includes_roles | String | ||
| ur_name | String | ||
| ur_requires_subscription | String | ||
| ur_scoped_admin | Bool | ||
| ur_suffix | String | ||
| ur_sys_class_name | String | ||
| ur_sys_created_by | String | ||
| ur_sys_created_on | Datetime | ||
| ur_sys_mod_count | Int | ||
| ur_sys_name | String | ||
| ur_sys_package | String | ||
| ur_sys_package_link | String | ||
| ur_sys_policy | String | ||
| ur_sys_scope | String | ||
| ur_sys_scope_link | String | ||
| ur_sys_tags | String | ||
| ur_sys_update_name | String | ||
| ur_sys_updated_by | String | ||
| ur_sys_updated_on | Datetime | ||
| lr_application | String | ||
| lr_application_link | String | ||
| lr_sys_user_role | String | ||
| lr_sys_user_role_link | String | ||
| uhr_role | String | ||
| uhr_role_link | String | ||
| uhr_user | String | ||
| uhr_user_link | String |