ServiceNow Tables

Tables

ServiceNowAuditRelations

Contains relationship-level audit records from the sys_audit_relation table, capturing insert and delete operations on related list fields across ServiceNow records.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the audit relation record in the sys_audit_relation table.
Tablename	string	Name of the ServiceNow table on which the audited relationship change was made.
Documentkey	string	`sys_id` of the record whose relationship was changed.
Fieldname	string	Name of the relationship field that was changed in the audited record.
Operation	string	Type of relationship operation that was audited (e.g., `insert`, `delete`).
RelatedRecordID	string	`sys_id` of the related record that was added or removed in the relationship change.
RelatedRecordLink	string	ServiceNow API link to the related record.
SysCreatedOn	datetime	Timestamp when the audit relation record was created, representing when the relationship change occurred.
SysCreatedBy	string	Username of the user or process that created the audit relation record.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowAudits

Stores field-level audit trail records from the sys_audit table, capturing before and after values for every tracked field change across ServiceNow tables.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the audit record in the sys_audit table.
Tablename	string	Name of the ServiceNow table on which the audited change was made (e.g., `incident`, `sys_user`, `change_request`).
Documentkey	string	`sys_id` of the record that was modified, identifying the specific row that was changed.
Fieldname	string	Name of the field that was changed in the audited record.
Oldvalue	string	Value of the field before the change was applied.
Newvalue	string	Value of the field after the change was applied.
UserID	string	`sys_id` of the user who made the audited change.
UserLink	string	ServiceNow API link to the user's `sys_user` record.
SysCreatedOn	datetime	Timestamp when the audit record was created, representing when the change occurred.
SysCreatedBy	string	Username of the user or process that created the audit record.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowChangeRequestAffectedCMDBCIs

Records the configuration items (CIs) affected by change requests from the task_ci table, including the type and level of impact for each CI.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the affected CI association record in the task_ci table.
ChangeID	string	`sys_id` of the change request this affected CI association belongs to.
ChangeLink	string	ServiceNow API link to the parent change request record.
CmdbCiID	string	`sys_id` of the configuration item (CI) affected by the change request.
CmdbCiLink	string	ServiceNow API link to the affected CI's cmdb_ci record.
ImpactType	string	Type of impact the change will have on the CI (e.g., `direct`, `indirect`).
ImpactLevel	string	Level of impact the change will have on the CI (e.g., `1` = High, `2` = Medium, `3` = Low).
SysCreatedOn	datetime	Timestamp when the affected CI association record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the affected CI association record was last updated in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowChangeRequestChangeTemplates

Contains change template records that define pre-configured settings for standard or recurring change requests, including type, risk, approval requirements, and associated change flow.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the change template record.
Name	string	Display name of the change template.
Type	string	Type of change the template is designed for (e.g., `standard`, `normal`, `emergency`).
Category	string	Category of changes this template applies to.
Active	string	Indicates whether the change template is active and available for use (e.g., `true`, `false`).
Description	string	Description of the change template and the scenarios it is intended to support.
ApprovalRequired	string	Indicates whether changes created from this template require approval before implementation (e.g., `true`, `false`).
Risk	string	Default risk level pre-populated by this template (e.g., `1` = Critical, `2` = High, `3` = Moderate, `4` = Low).
ChangeFlowID	string	`sys_id` of the change flow (workflow) associated with this template.
ChangeFlowLink	string	ServiceNow API link to the associated change flow record.
SysCreatedOn	datetime	Timestamp when the change template record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the change template record was last updated in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowChangeRequestImpactedCMDBCIService

Stores business service CIs impacted by change requests, including impact type, impact level, and whether a planned outage is expected for each service.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the impacted CI service association record.
ChangeID	string	`sys_id` of the change request this impacted service association belongs to.
ChangeLink	string	ServiceNow API link to the parent change request record.
CmdbCiServiceID	string	`sys_id` of the business service CI impacted by the change request.
CmdbCiServiceLink	string	ServiceNow API link to the impacted service CI's `cmdb_ci_service` record.
ImpactType	string	Type of impact the change will have on the service (e.g., `direct`, `indirect`).
ImpactLevel	string	Level of impact the change will have on the service (e.g., `1` = High, `2` = Medium, `3` = Low).
PlannedOutage	string	Indicates whether the change will cause a planned outage for this service (e.g., `true`, `false`).
SysCreatedOn	datetime	Timestamp when the impacted service association record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the impacted service association record was last updated in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowChangeRequests

Contains change request records from the change_request table, including change type, risk, approval state, assignment, and scheduled implementation dates.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the change request record in the `change_request` table.
Number	string	Human-readable change request number assigned by ServiceNow (e.g., `CHG0001234`).
ShortDescription	string	Brief one-line description of the change request.
Description	string	Detailed description of the change request, including purpose, scope, and implementation plan.
State	string	Current state of the change request (e.g., `Draft`, `Assess`, `Authorize`, `Scheduled`, `Implement`, `Review`, `Closed`).
Type	string	Type of change request (e.g., `standard`, `normal`, `emergency`).
Priority	string	Priority level of the change request (e.g., `1` = Critical, `2` = High, `3` = Moderate, `4` = Low, `5` = Planning).
Risk	string	Risk level assessed for the change request (e.g., `1` = Critical, `2` = High, `3` = Moderate, `4` = Low).
Category	string	Category classifying the type or area of change being requested.
RequestedBy	string	Display value of the user who requested the change.
AssignmentGroup	string	Display value of the group assigned to implement the change.
AssignedTo	string	Display value of the agent assigned to implement the change.

ServiceNowChangeRequestTasks

Stores change task records from the change_task table representing individual implementation steps within a parent change request, including assignment and planned dates.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the change task record in the change_task table.
Number	string	Human-readable change task number assigned by ServiceNow (e.g., `CTASK0001234`).
ShortDescription	string	Brief one-line description of the change task.
Description	string	Detailed description of the change task, including steps and objectives.
State	string	Current state of the change task (e.g., `1` = Open, `2` = Work In Progress, `3` = Closed Complete, `4` = Closed Incomplete).
Type	string	Type classification of the change task (e.g., `implementation`, `testing`, `review`).
Priority	string	Priority level of the change task (e.g., `1` = Critical, `2` = High, `3` = Moderate, `4` = Low).
ChangeID	string	`sys_id` of the parent change request this task is associated with.
ChangeLink	string	ServiceNow API link to the parent change request record.
AssignmentGroupID	string	`sys_id` of the group assigned to complete this change task.
AssignmentGroupLink	string	ServiceNow API link to the assigned group's `sys_user_group` record.
AssignedToID	string	`sys_id` of the agent assigned to complete this change task.

ServiceNowCMDBCIBusinessApps

Contains business application CI records from the cmdb_ci_business_app table, capturing application type, ownership, data classification, operational status, and platform details for applications tracked in the CMDB.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the business application CI record in the `cmdb_ci_business_app` table.
Name	string	Display name of the business application CI.
ApplicationType	string	Type classification of the business application (e.g., `SaaS`, `On-Premise`, `Mobile`, `Web`).
InstallStatus	string	Installation status of the business application CI (e.g., `1` = Installed, `2` = On Order, `6` = Retired).
Platform	string	Platform or operating environment on which the business application runs (e.g., `Windows`, `Linux`, `Cloud`).
ItApplicationOwner	string	Display value of the IT owner responsible for managing the business application.
OwnedBy	string	Display value of the business owner responsible for the business application.
ShortDescription	string	Brief one-line description of the business application CI.
OperationalStatus	string	Operational status of the business application CI (e.g., `1` = Operational, `2` = Non-Operational, `3` = Repair In Progress).
DataClassification	string	Data sensitivity classification of information handled by the application (e.g., `Public`, `Internal`, `Confidential`, `Restricted`).
SysCreatedOn	datetime	Timestamp when the business application CI record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the business application CI record was last updated in ServiceNow.
(unmapped columns)	--	Any column not listed above is written to ServiceNowCMDBCICustomFields instead of discarded.

ServiceNowCMDBCICustomFields

Stores custom field values associated with CMDB CI records, enabling capture of organization-specific attributes defined outside the standard ServiceNow schema.

Name	Type	Description
CIID	string	`sys_id` of the CI record this custom field value is associated with.
TableName	string	Name of the ServiceNow CMDB table the CI record belongs to (e.g., `cmdb_ci_server`, `cmdb_ci_business_app`).
FieldName	string	Name of the custom field defined on the CI record.
FieldValue	string	Value stored in the custom field for the associated CI record.
BusinessAppID	string	`sys_id` of the business application CI this custom field is associated with, if applicable.
ServiceAutoID	string	`sys_id` of the service automation CI this custom field is associated with, if applicable.

ServiceNowCMDBCIRelationships

Records CI-to-CI relationship entries from the cmdb_rel_ci table, defining the directional connections between parent and child configuration items along with the relationship type.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the CI relationship record in the `cmdb_rel_ci` table.
ParentID	string	`sys_id` of the parent CI in the relationship.
ParentLink	string	ServiceNow API link to the parent CI's record.
ChildID	string	`sys_id` of the child CI in the relationship.
ChildLink	string	ServiceNow API link to the child CI's record.
TypeID	string	`sys_id` of the relationship type defining the nature of the connection between the parent and child CIs.
TypeLink	string	ServiceNow API link to the relationship type record in the `cmdb_rel_type` table.
ParentBusinessAppID	string	`sys_id` of the business application CI that is the parent in this relationship, if applicable.
ParentServiceAutoID	string	`sys_id` of the service automation CI that is the parent in this relationship, if applicable.
ChildServiceAutoID	string	`sys_id` of the service automation CI that is the child in this relationship, if applicable.
ChildServerID	string	`sys_id` of the server CI that is the child in this relationship, if applicable.
SysCreatedOn	datetime	Timestamp when the CI relationship record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the CI relationship record was last updated in ServiceNow.

ServiceNowCMDBCIs

Contains configuration item (CI) records from the cmdb_ci table representing all hardware, software, and virtual assets tracked in the ServiceNow CMDB, including full asset and network details.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the configuration item (CI) record in the `cmdb_ci` table.
SysClassName	string	ServiceNow class name indicating the type of CI (e.g., `cmdb_ci_computer`, `cmdb_ci_server`, `cmdb_ci_application`).
SerialNumber	string	Serial number of the hardware CI.
AssetTag	string	Asset tag identifier assigned to the CI for asset management purposes.
Manufacturer	string	Manufacturer or vendor of the CI hardware or software.
ModelNumber	string	Model number of the CI hardware.
ModelID	string	Reference to the product model record for the CI.
Location	string	Display value of the physical or logical location of the CI.
Company	string	Company or organization that owns the CI.
Department	string	Department responsible for or associated with the CI.
AssignedTo	string	Display value of the user to whom the CI is assigned.
Status	string	Operational status of the CI (e.g., `1` = Operational, `2` = Non-Operational, `3` = Repair In Progress).

ServiceNowCMDBCIServers

Stores server CI records from the cmdb_ci_server table, capturing hardware specifications, OS details, network identity, and operational and installation status for physical and virtual servers.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the server CI record in the `cmdb_ci_server` table.
Fqdn	string	Fully qualified domain name (FQDN) of the server.
IpAddress	string	Primary IP address of the server.
OperationalStatus	string	Operational status of the server CI (e.g., `1` = Operational, `2` = Non-Operational, `3` = Repair In Progress).
InstallStatus	string	Installation status of the server CI (e.g., `1` = Installed, `2` = On Order, `3` = In Maintenance, `6` = Retired).
Os	string	Operating system running on the server (e.g., `Windows Server 2019`, `Ubuntu 22.04 LTS`).
CpuCount	string	Number of physical CPUs installed in the server.
Ram	string	Amount of RAM installed in the server, typically in megabytes.
DiskSpace	string	Total disk space of the server, typically in gigabytes.
Manufacturer	string	Manufacturer of the server hardware (e.g., `Dell`, `HP`, `Lenovo`).
ModelID	string	Reference to the product model record for the server hardware.
Location	string	Display value of the physical location or data center where the server is hosted.

ServiceNowCMDBCIService

Contains business service CI records from the cmdb_ci_service table, capturing service classification, operational status, ownership, criticality, and usage context.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the business service CI record in the `cmdb_ci_service` table.
Name	string	Display name of the business service CI.
ServiceClassification	string	Classification of the service type (e.g., `Business Service`, `Technical Service`, `Application Service`).
OperationalStatus	string	Operational status of the service CI (e.g., `1` = Operational, `2` = Non-Operational, `3` = Repair In Progress).
InstallStatus	string	Installation status of the service CI (e.g., `1` = Installed, `6` = Retired).
OwnedBy	string	Display value of the user or team that owns the business service.
ManagedByGroup	string	Group responsible for managing and maintaining the business service.
Criticality	string	Technical criticality of the service (e.g., `1` = Critical, `2` = High, `3` = Medium, `4` = Low).
BusinessCriticality	string	Business criticality of the service (e.g., `1` = Most Critical, `2` = Somewhat Critical, `3` = Less Critical`,` 4 `= Not Critical`).
UsedFor	string	Purpose for which the service is used (e.g., `Production`, `Staging`, `Development`, `Test`, `Disaster Recovery`).
SysCreatedOn	datetime	Timestamp when the service CI record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the service CI record was last updated in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowCMDBCIServiceAutos

Contains service automation CI records from the cmdb_ci_service_auto table, representing automated services tracked in the CMDB with their environment and managing group.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the service automation CI record in the `cmdb_ci_service_auto` table.
Name	string	Display name of the service automation CI.
Environment	string	Environment the service automation CI is deployed in (e.g., `production`, `staging`, `development`, `test`).
ManagedByGroup	string	Display value of the group responsible for managing the service automation CI.
SysCreatedOn	datetime	Timestamp when the service automation CI record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the service automation CI record was last updated in ServiceNow.
(unmapped columns)	--	Written to ServiceNowCMDBCICustomFields, as with business applications.

ServiceNowConsumers

Stores consumer profile records used in ServiceNow CSM (Customer Service Management), capturing personal details, contact information, household association, and notification preferences.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the consumer record.
Country	string	Country of the consumer's address.
Notes	string	Free-text notes or additional information about the consumer.
Gender	string	Gender of the consumer as recorded in their profile.
City	string	City of the consumer's address.
Prefix	string	Name prefix or honorific for the consumer (e.g., `Mr.`, `Ms.`, `Dr.`).
SysUpdatedOn	datetime	Timestamp when the consumer record was last updated in ServiceNow.
Suffix	string	Name suffix for the consumer (e.g., `Jr.`, `Sr.`, `III`).
Title	string	Job title or role of the consumer.
Number	string	Unique consumer number assigned by ServiceNow for identification.
Notification	string	Notification preference for the consumer (e.g., `Email`, `No Notification`, `SMS`).
BusinessPhone	string	Business phone number of the consumer.

ServiceNowContacts

Contains contact records from the ServiceNow sys_user table representing external contacts in CSM, including full profile details, authentication settings, geolocation, and organizational assignment.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the contact record in the `sys_user` table (contacts are stored as user records).
Country	string	Country of the contact's address.
CalendarIntegration	string	Calendar integration type configured for the contact (e.g., `0` = none, `1` = Outlook).
LastPositionUpdate	string	Timestamp of the most recent geolocation position update for the contact.
LastLoginTime	datetime	Timestamp of the contact's most recent login to ServiceNow.
LastLoginDevice	string	Device type or identifier used during the contact's last login.
Source	string	Source system from which the contact record was imported or synchronized (e.g., `LDAP`, `SAML`).
SysUpdatedOn	datetime	Timestamp when the contact record was last updated in ServiceNow.
Building	string	Building name or identifier of the contact's physical work location.
WebServiceAccessOnly	string	Indicates whether the contact is restricted to web service (API) access only and cannot log in interactively (e.g., `true`, `false`).
Notification	string	Notification preference for the contact (e.g., `Email`, `No Notification`, `SMS`).
SysUpdatedBy	string	Username of the user or process that last updated the contact record.

ServiceNowGroupRoles

Records role assignments for groups from the sys_group_has_role table, indicating which roles are granted to each group and whether they are inherited.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the group role assignment record in the `sys_group_has_role` table.
GroupId	string	`sys_id` of the group to which this role is assigned.
GroupLink	string	ServiceNow API link to the group's `sys_user_group` record.
RoleID	string	`sys_id` of the role assigned to the group.
RoleLink	string	ServiceNow API link to the role's `sys_user_role` record.
Inherited	string	Indicates whether the role was inherited from a parent group rather than directly assigned (e.g., `true`, `false`).
SysCreatedOn	datetime	Timestamp when the group role assignment record was created in ServiceNow.
SysCreatedBy	string	Username of the user or process that created the group role assignment record.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowGroups

Contains ServiceNow group records from the sys_user_group table, including group type, manager, parent group hierarchy, and contact email.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the group record in the `sys_user_group` table.
Name	string	Display name of the ServiceNow group.
Description	string	Description of the group's purpose and responsibilities.
Type	string	Type classification of the group (e.g., `itil`, `service_desk`, `change_management`).
Active	string	Indicates whether the group is currently active (e.g., `true`, `false`).
Manager	string	Display value of the user designated as the manager of this group.
ManagerLink	string	ServiceNow API link to the group manager's `sys_user` record.
Email	string	Email address associated with the group, used for group-level notifications.
Parent	string	Display value of the parent group in a hierarchical group structure.
ParentLink	string	ServiceNow API link to the parent group's `sys_user_group` record.
SysCreatedOn	datetime	Timestamp when the group record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the group record was last updated in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowIncidents

Stores incident records from the ServiceNow incident table, capturing state, priority, assignment, and opening timestamps for IT service disruption events.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the incident record in the incident table.
Number	string	Human-readable incident number assigned by ServiceNow (e.g., `INC0001234`).
ShortDescription	string	Brief one-line description of the incident.
State	string	Current state of the incident (e.g., `1` = New, `2` = In Progress, `3` = On Hold, `6` = Resolved, `7` = Closed).
Priority	string	Priority level of the incident based on impact and urgency (e.g., `1` = Critical, `2` = High, `3` = Moderate, `4` = Low, `5` = Planning).
AssignedTo	string	Display value of the agent currently assigned to the incident.
AssignmentGroup	string	Display value of the group currently assigned to resolve the incident.
OpenedAt	datetime	Timestamp when the incident was opened.
SysCreatedOn	datetime	Timestamp when the incident record was created in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowRequestedItems

Stores requested item records from the sc_req_item table representing individual catalog items ordered within a service request, including fulfillment state, approval, assignment, and quantity.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the requested item record in the `sc_req_item` table.
Number	string	Human-readable requested item number assigned by ServiceNow (e.g., `RITM0001234`).
ShortDescription	string	Brief one-line description of the requested item.
Description	string	Detailed description of the requested item, including any additional instructions or context.
State	string	Current state of the requested item (e.g., `1` = Pending Approval, `2` = Approved, `3` = In Process, `4` = Closed Complete, `7` = Cancelled).
Stage	string	Current processing stage of the requested item (e.g., `Request`, `Fulfillment`, `Delivery`, `Completed`).
Approval	string	Current approval status of the requested item (e.g., `requested`, `approved`, `rejected`, `not requested`).
Priority	string	Priority level of the requested item (e.g., `1` = Critical, `2` = High, `3` = Moderate, `4` = Low).
RequestID	string	`sys_id` of the parent service request this item belongs to.
RequestLink	string	ServiceNow API link to the parent service request record.
CatItemID	string	`sys_id` of the catalog item this requested item was ordered from.
CatItemLink	string	ServiceNow API link to the catalog item record in the `sc_cat_item` table.

ServiceNowRequests

Contains service request records from the sc_request table representing user-submitted requests for goods or services, including approval state, priority, assignment, and lifecycle timestamps.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the service request record in the sc_request table.
Number	string	Human-readable service request number assigned by ServiceNow (e.g., `REQ0001234`).
ShortDescription	string	Brief one-line description of the service request.
Description	string	Detailed description of the service request, including additional context or justification.
State	string	Current state of the service request (e.g., `1` = Pending Approval, `2` = Approved, `3` = In Process, `4` = Closed Complete, `7` = Cancelled).
RequestState	string	Workflow processing state of the service request (e.g., `pending`, `in_process`, `closed_complete`, `closed_incomplete`, `closed_cancelled`).
Stage	string	Current processing stage of the service request (e.g., `Request`, `Waiting for Approval`, `Fulfillment`, `Delivery`, `Completed`).
Approval	string	Current approval status of the service request (e.g., `requested`, `approved`, `rejected`, `not requested`).
Priority	string	Priority level of the service request (e.g., `1` = Critical, `2` = High, `3` = Moderate, `4` = Low).
RequestedFor	string	Display value of the user for whom the service request was submitted.
OpenedBy	string	Display value of the user who opened or submitted the service request.
AssignmentGroup	string	Display value of the group assigned to fulfill the service request.

ServiceNowRoles

Stores ServiceNow role definitions from the sys_user_role table, including role name, owning application, admin override behavior, and elevated privilege status.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the role record in the `sys_user_role` table.
Name	string	Unique name of the role used to reference it in ServiceNow scripts and policies (e.g., `itil`, `admin`, `snc_internal`).
Description	string	Description of the role's access scope and intended use.
ApplicationID	string	`sys_id` of the application (scoped app) that owns or defines this role.
ApplicationLink	string	ServiceNow API link to the owning application record.
AdminOverrides	string	Indicates whether the admin role overrides this role's restrictions (e.g., `true`, `false`).
ElevatedPrivilege	string	Indicates whether this role grants elevated privilege requiring explicit activation (e.g., `true`, `false`).
SysCreatedOn	datetime	Timestamp when the role record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the role record was last updated in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowUserGroupMembers

Records user-to-group membership associations from the sys_user_grmember table, linking each user to the groups they belong to.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the group membership record in the `sys_user_grmember` table.
UserID	string	`sys_id` of the user who is a member of the group.
UserLink	string	ServiceNow API link to the member's `sys_user` record.
GroupID	string	`sys_id` of the group the user belongs to.
GroupLink	string	ServiceNow API link to the group's `sys_user_group` record.
State	string	State of the group membership (e.g., `active`, `inactive`).
SysCreatedOn	datetime	Timestamp when the group membership record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the group membership record was last updated in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowUserRoles

Records direct and inherited role assignments for users from the sys_user_has_role table, including the granting group reference for inherited roles.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the user role assignment record in the `sys_user_has_role` table.
UserId	string	`sys_id` of the user to whom this role is assigned.
UserLink	string	ServiceNow API link to the user's `sys_user` record.
RoleId	string	`sys_id` of the role assigned to the user.
RoleLink	string	ServiceNow API link to the role's `sys_user_role` record.
Inherited	string	Indicates whether the role was inherited from a group membership rather than directly assigned (e.g., `true`, `false`).
GrantedByID	string	`sys_id` of the group role assignment that granted this inherited role, if applicable.
GrantedByLink	string	ServiceNow API link to the granting group role record.
SysCreatedOn	datetime	Timestamp when the user role assignment record was created in ServiceNow.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ServiceNowUsers

Stores ServiceNow user records from the sys_user table, including identity, contact details, department, location, and manager information for all platform users.

Name	Type	Description
ID	string	Unique ServiceNow `sys_id` (GUID) identifying the user record in the `sys_user` table.
UserName	string	Unique login username used by the user to authenticate into ServiceNow.
Name	string	Full display name of the user, typically formatted as first and last name.
Email	string	Primary email address of the user.
Active	string	Indicates whether the user account is active and able to log in (e.g., `true`, `false`).
Title	string	Job title of the user as recorded in the ServiceNow user profile.
Manager	string	Display value of the user's direct manager.
ManagerLink	string	ServiceNow API link to the manager's `sys_user` record.
Location	string	Display value of the user's assigned office or site location.
LocationLink	string	ServiceNow API link to the user's location record in the `cmn_location` table.
SysCreatedOn	datetime	Timestamp when the user record was created in ServiceNow.
SysUpdatedOn	datetime	Timestamp when the user record was last updated in ServiceNow.
Department	string	Display value of the department the user belongs to.
DepartmentLink	string	ServiceNow API link to the user's department record in the `cmn_department` table.
ConfigID	integer	Unique identifier linking the record to a specific ServiceNow integration configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.