Custom fields in User table

atlauren
Kilo Explorer

We have several org-specific fields stored in LDAP that we'd like to bring into ServiceNow.   They are likely to be commonly references in Incident Management. What do folks typically do in this situation?   Add fields to sys_user?   Extend sys_user?   Add an additional table and reference it specifically as needed?

 

(Note: The LDAP in this case is not Active Directory.)

 

Thanks,

Andrew

5 REPLIES 5

Chandan23
Tera Expert

Ideally U need top update the sys_user tabel.


march
Kilo Guru

Hi Andrew,



We had the same kind of requirements and just added new fields to the sys_user table.



The only case i may imagine to do differently is if you have different user source were some of them don't contain those additional field, then in this case i would maybe extend the table, but even then, i would probably rather work with views.



If you want them to be referenced in the Incident Management Process, then i advise to not extend the table.


Community Alums
Not applicable

i believe adding new custom fields to User Table will be easier as in this case you dont have to do much changes in your LADP import as well ...just adding new attributes and correctly mapping them through Transform Map will work for you.



Bharat


MGanon
Tera Guru
We have the same requirement and it is causing issues with our import. Has the recommended guidance changed in the last five years? Is it better to add fields to the sys_user table or add a new table that references the sys_user table?