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]

At that link, you won't see a column for Asset, because that is the list of Assets.  You can, however, add a column for Configuration Item to see the corresponding CI.  It might help to have the list of Computers open with the Asset column displayed, and have the list of Assets open with the Configuration Item column displayed so you can see the corresponding records. 

For example, lets say for Computer (CI) "ABC" your Asset shows the wrong information.  You would go to the link above, then filter to CI=ABC, to find the corresponding Asset record for that CI.  Open the Asset record and then make your changes to the Asset.

[Brian Sorensen]

OK, I might not be following 100%

I used the link you sent over

I get my full list

Under Configuration Item I see an asset I want to modify

I click on that asset, but the option to edit Asset is still locked

I opened that record, but have no where to edit the Asset name

The bigger issue is there is 1200 assets I need to do this with, so there has to be a way to export and import?

[Community Alums]

I think you are close.  

Here is where you got re-directed away from the Asset and back to the Configuration Item: 

"Under Configuration Item I see an asset I want to modify"  - In this column (Configuration Item) these are not Assets, these are Configuration Items.  To open the Asset record, click on the first column, or click on the information icon at the start of the row.   

You can check the URL to see where you are as well.  If you see cmdb_ci_computer, or cmdb_ci... you are not on the asset record, you are on the CI record.  If you see alm_asset, or alm_hardware, or alm_.... then you are on the Asset record.

[Brian Sorensen]

This is the URL
I am currently at

https://mlse.service-now.com/alm_asset_list.do?sysparm_query=ci.sys_class_name%3Dcmdb_ci_computer&sysparm_view=

When I click on the first column, in my case Asset Tag is my first column

the URL changes to 

https://mlse.service-now.com/alm_hardware.do?sys_id=0ce93211db27a8101445450b13961998&sysparm_record_target=alm_asset&sysparm_record_row=1&sysparm_record_rows=1442&sysparm_record_list=ci.sys_class_name%3Dcmdb_ci_computer

The only spot that I can see the "Asset" name that I want to change is at the top shows Hardware

This Q1F23 is what I want to change

I just feel like there should be a table somewhere that I can download, fix and import

[Community Alums]

In my instance, that is the Display Name, which is visible in your screenshot.  You could add it to the form, or update it from the list view, or export/import updates to that field, unless there is an ACL or read-only policy on it.