How to Edit "ASSET" in cmdb_ci_computer_list

Brian Sorensen
Giga Guru

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)
find_real_file.png

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?

1 ACCEPTED SOLUTION

Community Alums
Not applicable

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. 

View solution in original post

15 REPLIES 15

Thanks, still sorting this out

I unchecked "Display"

Now I have an odd string of random characters in that "Asset" column, and security still prevents me from writing to it

So I went back into ALM_HARDWARE table and checked the "Display" box on the Display column, I know have the results I was looking for, which was probably something I did when I assumed "Display" meant show this in the table...

 

Rookie moves...

Thanks @Dustin Watkins !