ServiceNow Dot Walking

The ServiceNow's sys_user table includes columns like manager, department, location, cost_center, company, building, etc. These columns are referenced by or from other tables in ServiceNow. By default, SailPoint aggregates user display names for these references.

Dot walking provides access to fields on related tables. If the current table contains a reference to another table, any field on the referenced table can be accessed using dot walking. For example, to get the user_name of a user's manager use manager.user_name.

If you are interested in aggregating specific fields on a reference table, you add those attributes in the account schema/group schema/role schema. For example:

manager.name

manager.user_name

manager.email

cost_center.name

cost_center.code

company.city

building.name

location.name

The source then aggregates the data for the reference field once available in the respective schema. The fields are useful for attribute sync feature. For example, To sync an attribute if an Identity’s manager field has an email, then on the target ServiceNow application should be mapped to manager.email instead of manager.