We need to change the max length of the sys_created_by field in the sys_attachment table.

[edouardholliste]

We are using Fuji in our on premise instance.   We use LDAP to populate our User table and use our email address for our user_id.   The sys_created_by field in the sys_attachment table has a max length of 40.   We have some user_ids that are longer.   We need to enlarge the size to 100, to be on the safe side.   The field is grayed out even though I have Admin role.   I have tried to change it in the Global domain, as well as, our domain and I have activated the elevated privilege of security_admin.   Does anyone know how I can enlarge the field?

[Bharath40]

Hi Edouard,

You may have to disable ACL first create a new one , here it is clearly explained Ways to expand sys_created_by length . Tested and it is working.

Let me know if you have any questions. Don't forget to activate them after you make changes.

[edouardholliste]

Bharath,

I read the article in the link you provided. At the end, George stated he did not expand the field due to possible repercussions. He also stated that he had opened the issue with Hi. I had already opened a ticket with Hi and, the answer that I received was that it should not cause an issue. Do you have any further information that would stop me from expanding the field?

Respectfully,

Edouard T. Hollister Sr

DC1 SNOW Administrator

CSRA

Department of Homeland Security / DC1

9324 Cypress Loop Rd | Stennis Space Center, Ms 39529

Office: 228-813-3380

Edouard.Hollister@associates.hq.dhs.gov<mailto:Edouard.Hollister@associates.hq.dhs.gov>

[Bharath40]

Hi,

I don't see any issue in changing the field value unless you are doing it in thousands. I do accept that we hesitate to change OOTB fields unless it is important. We can confirm with our ServiceNow guru ctomasi . Chuck can you please confirm .

[Chuck Tomasi]

I don't know of any repercussions of extending this particular field from 40 to 80 or 100. Remember, once you go up, you cannot go back. Enlist the help of the customer support team to change the max length.

I'm curious why this is a specific issue. For example, are you reporting against it? Scripting against it? Matching on it? It's one of those fields that's nice to know every so often, but I can usually infer who created the record by looking at visually even if it is truncated.