Updating Existing Assets

[DC-BEN]

Hi,

We have around 160 devices that have been added into the Service Manager asset database automatically via SCCM.

We have other information to add to all of these assets that SCCM doesn't populate such as; order number, supplier ID, room, order date, received date, warranty expires.

Just wondering if anyone can help advise if there is an easy way to add this information into existing records without going into each asset and manually changing it?

I'm guessing the asset upload feature is for new assets only and can't be used to add more information to existing assets?

Thanks

[ArmandoDM]

Hi @DC-BEN,

yes the asset upload feature is for new assets only, not for update.

Unfortunately I cannot see any shorter way to update the asset details one by one.
If you have an updated CSV file and if the assets are not currently linked to any entity, you may delete the existing assets and import them again.

Regards,

 

Armando

 

[DC-BEN]

Hi @armandoDM

Thanks for your prompt response.

I'll be sure to bear this in mind going forward.

Thanks

[Steven Boardman]

Hi @DC-BEN

The Asset Import Utility which was used to import assets from SCCM can also be used to update existing assets in Hornbill, it can import / update from different sources (you will of course need to create the configs / queries for each data source). 

If the information you mention is not held in SCCM, but is in another data source you can create another script to update the existing assets in Hornbill.

As long as the identifier set in the config and returned by the query matches an asset in Hornbill, then the record will be updated rather than creating a new one

Hope that helps 

Steve

[Steve Giller]

@Steven Boardman Would that "another data source" include a csv file? And if so is the connection documented?
If not I'm sure we can get a CSV into a MSSQL table and import/update from there.

[Steve G]

Hi @DeadMeatGF @DC-BEN,

No, the tool will only connect to MySQL, MariaDB or MSSQL data sources.

Steve

[dwalby]

Have there been any further developments on capability for updating assets?

I also have a number of assets imported from SCCM, which I have purchase information, etc. as well as images for each device model. Is there any way to bulk update them from CSV or similar?

[Steve G]

Hi @dwalby @DeadMeatGF @DC-BEN,

Yes, the CSV Asset Import tool can import new or update existing asset records from a CSV, and can be scheduled. Please see the wiki & github pages for more information:

https://wiki.hornbill.com/index.php/CSV_Asset_Import

https://github.com/hornbill/goCSVAssetImport

Kind regards,

Steve

[dwalby]

@Steve G Thanks! On the reverse, is there a way to export the current list of assets from Hornbill in csv?

[Victor]

@dwalby

12 hours ago, dwalby said:

is there a way to export the current list of assets from Hornbill in csv

on a quick thought, a report on assets will do just that...

[Steve G]

@dwalby,

As @Victor has suggested, you could do this with a report. We do have a story planned to add export functionality to the assets lists, so I'll add you as an interested customer to the story.

Kind regards,

Steve

[dwalby]

@Victor @Steve G - Thanks both

[dwalby]

@Victor @Steve G - Just had another thought... Historically we've maintained our assets within an Excel document, if I formatted this as per the relevant template then imported, would the information be merged with the already existing asset info from SCCM?

[Steve G]

@dwalby,

Yes, if the imports are configured correctly then existing asset records will be updated rather than duplicates created.

Kind regards,

Steve