Hornbill Asset Import - Can the utility purge the data in Hornbill prior to an import

[Izu]

In order to ensure that the [Asset Management] function reflects the current state of assets and the user-asset relationships; Is it possible for the utility clear the existing data prior to an import?

[Steve G]

Hi @Izu,

The asset import tool will perform updates on existing asset records when run - so if the owner/last used values change in your asset database between scheduled import executions, then the existing values will be overwritten with the new values  in the Hornbill asset records.

If this doesn't cover your use-case, then we do have another tool which allows you to delete asset records en-masse: https://wiki.hornbill.com/index.php/Hornbill_Clean_Utility

But if you do decide to use the cleaner tool for this, then please do so with the utmost care, as this can be configured to delete ALL asset AND request data from your Hornbill instance!

Steve

[Izu]

@Steve G,

Thanks for the feedback. We will have a look once again.

Furthermore, Please, could you let us know:

1. The parameters/Query to use in order to extract printers/scanners.

2. How to remove Assets that no longer exists in our database during the Asset import run.

 

Rgds,,

Izu

[Steve G]

Hi @Izu,

With regards to 1, do you mean parameters that the cleaner tool should use to identify and remove printers and/or scanner assets? If so, then this is be specific to your instance, information about how to configure this can be found in the cleaner tool documentation on the wiki: https://wiki.hornbill.com/index.php/Hornbill_Clean_Utility

With regards to 2, the asset import tool has no way of identifying assets that no longer exist. If the CMDB that you’re importing the assets from has the ability to retire or archive assets, then you could always configure the import tool to reflect that in the status field of Hornbill assets:

Cheers,

Steve

[Izu]

@Steve G,

1. It's the Asset Import parameter/query to extract printers and scanners from our database into Hornbill.

Rgds,

Izu

[Steve G]

@Izu,

I can't help with that I'm afraid - it's your database, which we have no access to or visibility of, so you need to build the query accordingly. You probably need to speak to someone in your organisation who knows your database.

Steve