How do we add the employee number to the ServiceNow User table?

[Ankur Bawiskar]

@LakshmiVenkata 

what's your actual business requirement?

1) employee number field is already available on sys_user table

2) if you are using LDAP to fetch user data then ensure you fetch employee number from AD and match it using field map in the Data Source with the target employee_number field

If my response helped please mark it correct and close the thread so that it benefits future readers.

[LakshmiVenkata]

Yes I need that details that where i need to map the filed by using LDAP can guide me briefly

[Dr Atul G- LNG]

Hi @LakshmiVenkata 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0961314

https://www.servicenow.com/docs/bundle/yokohama-platform-security/page/integrate/ldap/concept/c_LDAP...

[Dr Atul G- LNG]

Hi @LakshmiVenkata 

Is your issue resolved?

[Ankur Bawiskar]

@LakshmiVenkata 

check this link for detailed step

Adding an AD attribute to LDAP import set data 

High level steps:

1) Go to LDAP Servers in left nav

2) open that relevant LDAP server record, stop the listener

3) in the attributes field ensure whatever is there, append employeeNumber attribute to it, do check if the AD attribute name is correct

4) open the data source for Users OU and Test load 20 records, this creates the new import set staging field to hold data for the new AD attribute

5) then perform field mapping of this new employee number field on staging table with target field on sys_user

6) then start the listener again

If my response helped please mark it correct and close the thread so that it benefits future readers.