JDBC Driver for ServiceNow

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462