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?

[Community Alums]

Go to the alm_asset table, then apply the filter Configuration Item=>Class is Computer (ci.sys_class_name=cmdb_ci_computer) This will give you the same list, but from the asset side where you can edit the asset fields.

[Brian Sorensen]

Hi @Dustin Watkins 

I just want to make sure I am doing this right, as I might have missed something?

I changed the filter in the ALM table to be 

Model Category CI Class = cmdb_ci_computer

and have the same list, but in the alm_hardware table, that Asset column doesn't exist, and I can't seem to add it?

[Community Alums]

Try this link:
https://<instance-name>.service-now.com/alm_asset_list.do?sysparm_query=ci.sys_class_name%3Dcmdb_ci_computer&sysparm_view=

[Brian Sorensen]

the link works, but the column for Asset is still not available.