Power BI Connector for ServiceNow

Build 25.0.9454

system_user

Stores user account details, including credentials, roles, and contact information.

Columns

Name Type ReadOnly References Description
SysId [KEY] String False

Provides the system identifier (sys_id) for the user record.

AccumulatedRoles String False

Lists all roles assigned to the user, including inherited or implied roles.

Active Bool False

Indicates whether the user account is currently active and allowed to access the system.

AgentStatus String False

Shows the current agent availability status, typically used for service desk or support users.

Avatar String False

Stores the image or avatar associated with the user's profile.

Building String False

References the building where the user is located or assigned to work.

BuildingLink String False

Provides a link to the record of the building associated with the user.

BusinessCriticality Int False

Represents the importance level of the user's role or function to business operations.

CalendarIntegration Int False

Specifies whether the user's calendar is integrated with external calendar systems.

City String False

Indicates the city associated with the user's work location or address.

Company String False

References the company the user is employed by or associated with.

CompanyLink String False

Provides a link to the company record related to the user.

CostCenter String False

Specifies the cost center responsible for the user's expenses or department budget.

CostCenterLink String False

Provides a link to the cost center record associated with the user.

Country String False

Indicates the country where the user is based or employed.

DateFormat String False

Defines the preferred date display format for the user's interface.

DefaultPerspective String False

Specifies the default perspective or dashboard the user sees upon logging in.

DefaultPerspectiveLink String False

Provides a link to the record defining the user's default perspective.

Department String False

References the department the user belongs to within the organization.

DepartmentLink String False

Provides a link to the department record related to the user.

EduStatus String False

Specifies the user's education or training status when relevant to internal learning modules.

Email String False

Stores the user's primary email address used for notifications and communication.

EmployeeNumber String False

Contains the employee number assigned to the user within the organization.

EnableMultifactorAuthn Bool False

Indicates whether multifactor authentication (MFA) is enabled for the user account.

FailedAttempts Int False

Tracks the number of consecutive failed login attempts by the user.

FederatedId String False

Stores the federated identity used for single sign-on (SSO) authentication.

FirstName String False

Contains the user's first name as displayed in the system.

Gender String False

Specifies the user's gender for profile or reporting purposes.

GeolocationTracked Bool False

Indicates whether the user's geographical location is being tracked for operational purposes.

HashedUserId String False

Stores a hashed version of the user identifier used for secure integrations.

HomePhone String False

Stores the user's home phone number for contact purposes.

InternalIntegrationUser Bool False

Indicates whether the user account is used for internal system or integration processes.

Introduction String False

Contains a brief introduction or biography for the user's profile.

LastLogin Date False

Records the date when the user last logged in to the system.

LastLoginDevice String False

Identifies the device used during the user's most recent login session.

LastLoginTime Datetime False

Records the exact date and time of the user's last successful login.

LastName String False

Contains the user's last name as stored in the system.

LastPassword String False

Stores the hash of the user's previous password for security tracking.

LastPositionUpdate Datetime False

Records when the user's position or role was last updated in the system.

Latitude Float False

Represents the latitude coordinate of the user's registered location.

LdapServer String False

References the Lightweight Directory Access Protocol (LDAP) server used for user authentication.

LdapServerLink String False

Provides a link to the LDAP server record associated with the user.

Location String False

Specifies the user's physical or work location within the organization.

LocationLink String False

Provides a link to the location record related to the user.

LockedOut Bool False

Indicates whether the user account is locked due to failed login attempts or administrative action.

Longitude Float False

Represents the longitude coordinate of the user's registered location.

Manager String False

References the manager or supervisor responsible for this user.

ManagerLink String False

Provides a link to the record of the manager associated with the user.

MiddleName String False

Contains the user's middle name, if available.

MobilePhone String False

Stores the user's mobile phone number for contact or notification purposes.

Name String False

Displays the user's full name as it appears throughout the system.

Notification Int False

Defines the user's notification preference settings, such as email or mobile alerts.

OnSchedule String False

References the on-call or work schedule assigned to the user.

PasswordNeedsReset Bool False

Indicates whether the user must reset their password at the next login.

Phone String False

Stores the user's primary work phone number.

Photo String False

References the user's profile photo stored in the system.

PreferredLanguage String False

Defines the user's preferred display language for the interface.

Roles String False

Lists the roles explicitly assigned to the user for access control and permissions.

Schedule String False

References the user's assigned work or shift schedule.

ScheduleLink String False

Provides a link to the schedule record related to the user.

Source String False

Indicates the source system or method through which the user record was created.

State String False

Specifies the administrative state or region where the user is located.

Street String False

Contains the user's street address.

SysClassName String False

Defines the system class for this user record, identifying its structure and behavior.

SysCreatedBy String False

Identifies the user who originally created this record.

SysCreatedOn Datetime False

Records the date and time when this user record was created.

SysDomain String False

Indicates the domain to which this user belongs in multi-domain environments.

SysDomainPath String False

Specifies the hierarchical domain path for the user in multi-domain setups.

SysModCount Int False

Tracks the total number of updates made to this user record.

SysTags String False

Lists tags associated with the user for categorization or quick filtering.

SysUpdatedBy String False

Identifies the user who last modified this user record.

SysUpdatedOn Datetime False

Records the date and time when the user record was last updated.

TimeFormat String False

Defines the preferred time display format for the user interface.

TimeZone String False

Specifies the time zone that determines how date and time values are displayed for the user.

Title String False

Indicates the user's job title or position within the organization.

UserName String False

Stores the unique username used by the user to log in to the system.

UserPassword String False

Contains the user's password in encrypted or hashed form for authentication purposes.

Vip Bool False

Indicates whether the user is marked as a VIP (very important person) for prioritized handling.

WebServiceAccessOnly Bool False

Specifies whether the user account is restricted to web service access only.

Zip String False

Stores the postal or ZIP code associated with the user's address.

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