User_name missing in sys_user table?

[rhysbrennan]

Hi wondering how this happened in our production environment. I was modifying the sys_user table dictionary option to allow searching against a user ID instead of our current name and email address for the requester field in incidents.

In our Dev environment i was able to change the reference collection fine however the user_name is not included as an available table column in the production environment. When I tried to add a new table column it prefixes the attribute with u_user_name so I know I'm going in the wrong direction.

I know the data is there because it's colease in the SSO and available to view against users. I just don't know how to add the column in the dictionary. There are a lot of other columns missing as well.

I'll grab some screenshots if needed.

[lSurya 24]

Hello Rhyms,

Refer to below links:

Reference Fields - ServiceNow Wiki

[rhysbrennan]

I'm going to track down this lead, I right clicked requestor, show u_requestor and I can see the problem in the attributes. I just need to find that attribute as it's not the same attribute settings as the sys_user table.

[rhysbrennan]

Back to where I started. I can't find the refference attribute to modify

[lSurya 24]

Hello,

Click on that field and you will find this:

[rhysbrennan]

Thats right but it doesn't match this:

So confused!