Asset import - SCCM config file

[Giuseppe Iannacone]

can you please clarify which is the purpose of the "SoftwareInventory" portion of the configuration file provided for the SCCM Asset import?

I'm running with success the latest version and it's not clear to me which is the impact against our instance.... is expecting to associate software asset to computer asset for example?

I just see from the log the the software number retrieved for each asset is different...
would it be nice to have the software information stored or linked with an asset computer

 

[Steve G]

Hi @Giuseppe Iannacone,

The utility will import these records as software inventory records against the assets, and not as software assets as these are two different things.

Please see the Software Asset Management documentation for more information.

Cheers,

Steve

[Giuseppe Iannacone]

@Steve G thanks for the clarification, very useful indeed

[Giuseppe Iannacone]

@Steve G I'm receiving this error in the log file:
 

Error creating software record:Unable to create software inventory record: A database or query error occurred while inserting the primary record data into the database. (table=h_cmdb_assets_installed_software, pk=)

but this happens only for specific Computer Asset with the inventory execution

[Steve Giller]

As far as I'm aware, that normally occurs when there's an error in the data, probably passing a string value into a numeric field.

For example, h_record_state will show in the UI as current, active, or archived but requires a value (as shown in the Entity Explorer) of 0, 1, or 2

[Giuseppe Iannacone]

@Steve Giller thanks for the feedback, how I can understand it better? is there a way to enable the debug mode for the log of the asset import?

[Steve Giller]

You're already using debug mode, without that the [DEBUG] entries would not be in the log.

For understanding the input requirements the best method is to review the Entity Explorer in Service Manager (https://live.hornbill.com/[INSTANCE_ID]/admin/app/com.hornbill.servicemanager/advanced/entity-explorer) which lists the data types for all columns under the Database Schema Viewer dropdown, and where the values are representative numbers these are specified.

For example:

[Giuseppe Iannacone]

@Steve Giller I appreciate this insight, but as far as I understand it seems that the import tool is trying to add a record without collecting the right data for a small subset of software discovered, or am I wrong?