How to Edit "ASSET" in cmdb_ci_computer_list

[Brian Sorensen]

I am tying assets back to Purchase orders, and at somepoint when we did the initial load of ServiceNow we somehow ended up getting some data into the column for "asset", but the date is either wrong or incomplete, which is leading to some issues that I want to fix

When I do a search for Computers I am opening the link from Configuration > Base Items > Computers

Then in my columns I have the Asset column visible

When I try to manually update I get the security error (I logged in as Admin)

What I want to do is export all the machines, update and then import / update ServiceNow
But, when I do an Import > Update > Create Excel Template, this Asset column is not on the sheet.  

Any ideas where I can find it or where I can go to edit it?

[Brian Sorensen]

I think that might be the issues that there is a ACL or Read only policy .. i'll see what I can dig up

[Brian Sorensen]

Thank you @Dustin Watkins 

So here is what I have since discovered, but it didn't fix the issue

I went into tables

then opened the table for CMDB_CI_COMPUTERS

opened the value for Asset which told me this

Info Message

This cloned descendant element is read-only, Click here to open editable first element (cmdb.asset) in a new window.

opened that reference and saw that it is a reference field and read only

I can remove the read only - which i did

then i can click in the box, but it won't actually save anything

This is what I see on the field settings

I feel like it is putting data from a custom field I made on the ALM table into it, but still testing that theory.

[Community Alums]

Check this Business Rule:

https://<instance>.service-now.com/nav_to.do?uri=sys_script.do?sys_id=5814a034eb3321005ecfa9bcf106feb9

[Brian Sorensen]

OK, so found an oddity and seeing how it works.

We have a custom field on the ALM_HARDWARE table called MLSE Refresh, this is where we are noting when the hardware should be replaced.

What we have noticed is anything entered into this field, is then transposed into the Asset column

Any ideas what is causing that?

[Community Alums · Accepted solution]

This is because "Display" is checked.  You should only have one field with "Display" checked per table, and that is the field that gets displayed in reference fields, or the top of the form, or when using .getDisplayValue() in scripts.