Questions about asset management on Service Manager

[billster]

1. is it possible to mass update a lot of assets in Service Manager? I have 562 assets on there and want to update them all using CSV, or should I just wipe them off and start again? there's no requests associated to any of them.

 

2. is it possible to add custom fields to the prebuilt asset types? On Laptop and Desktop asset type under Computer System, I want to add another field called "Express Service Code"

 

Thanks

[Steve Giller]

4 minutes ago, billster said:

is it possible to mass update a lot of assets in Service Manager?

Absolutely, yes.
Asset Import Tool Documentation

 

5 minutes ago, billster said:

is it possible to add custom fields to the prebuilt asset types?

No, however if you have a field that would be useful to the majority of our User base these can be added to the Asset Class.
Can you describe what the field you want to add is, and how it is used?

Just to set expectations, is there any reason you can't use an existing field that you are not using for anything else and rename it using a translation?

[billster]

29 minutes ago, Steve Giller said:

No, however if you have a field that would be useful to the majority of our User base these can be added to the Asset Class.
Can you describe what the field you want to add is, and how it is used?

It is a 11 digit number that helps identify Dell products.

 

32 minutes ago, Steve Giller said:

Just to set expectations, is there any reason you can't use an existing field that you are not using for anything else and rename it using a translation?

I've not thought of this. I will try it.

 

Thanks

[Steve Giller]

As well as the h_serial_number (Serial Number) value there are h_psu1_serial (PSU1 Serial) and h_psu2_serial (PSU2 Serial) values, all 128-character fields.
If you're not storing/intending to use the PSU Serial Numbers these may well be suitable.

[billster]

 

24 minutes ago, Steve Giller said:

As well as the h_serial_number (Serial Number) value there are h_psu1_serial (PSU1 Serial) and h_psu2_serial (PSU2 Serial) values, all 128-character fields.
If you're not storing/intending to use the PSU Serial Numbers these may well be suitable.

I've managed to use PSU 1 S/N and translated it to what I require.
Thank you.

[billster]

@Steve Giller

I've configured the asset import tool.

{
    "LogSizeBytes": 1000000,
    "HornbillUserIDColumn": "h_user_id",
    "SourceConfig": {
        "Source": "csv",
        "CSV": {
            "CarriageReturnRemoval": false,
            "CommaCharacter": ",",
            "FieldsPerRecord": 0,
            "LazyQuotes": false
        }
    },
    "AssetTypes": [{
        "AssetType": "Desktop",
        "OperationType": "Both",
        "CSVFile": "billy.csv",
        "PreserveShared": false,
        "PreserveState": false,
        "PreserveSubState": false,
        "PreserveOperationalState": false,
        "AssetIdentifier": {
            "SourceColumn": "SerialNumber",
            "Entity": "AssetsComputer",
            "EntityColumn": "h_serial_number",
            "SourceContractColumn": "",
            "SourceSupplierColumn": ""
        }
    }],
    "AssetGenericFieldMapping": {
        "h_name": "{{.Name}}",
        "h_asset_tag": "{{ (split \"/\" .AssetTag)._0 }}",
        "h_description": "{{.Description}}\n\n{{.Manufacturer}} {{.Model}}",
        "h_operational_state": "{{.OperationalState}}",
        "h_record_state": "{{.State}}"
    },
    "AssetTypeFieldMapping": {
        "h_name": "{{.Name}}",
        "h_model": "{{.Model}}",
        "h_manufacturer": "{{.Manufacturer}}",
        "h_description": "{{.Description}}\n\n{{.Manufacturer}} {{.Model}}",
        "h_serial_number": "{{.SerialNumber}}"
    }
}

but it isn't updating any assets.

 

C:\Users\bill\Downloads\asset_import-windows-amd64>asset_import.exe -file=conf.json
---- Hornbill Asset Import Utility v4.10.0 ----
[DEBUG] Flag - Config File conf.json
[DEBUG] Flag - Dry Run false
[DEBUG] Flag - Concurrent 1
[MESSAGE] Successfully decrypted Hornbill instance authentication information
[MESSAGE] You're running the latest version of this utility: 4.10.0
Caching Application Records from Hornbill...
Running CSV query for Desktop assets. Please wait...
562 of 562 returned assets successfully retrieved ready for processing.
Caching Desktop Asset Records from Hornbill...
 222 / 222 [===============================================================================================] 100.00% 0s
Hornbill Desktop Asset Records Cached

Processing 1 of Desktop Type Assets...
 1 / 1 [===================================================================================================] 100.00% 0s
Desktop Asset Type Processing Complete!

-=-=-= Summary =-=-=-

-=- New Assets -=-
 * Created: 1
 * Skipped: 0
 * Failures: 0

-=- Updated Assets -=-
 * Updated: 0
 * Skipped: 0
 * Failed: 0
 * Extended Record Skipped: 0
 * Extended Record Failed: 0

-=- Software Inventory Records -=-
 * Created: 0
 * Skipped: 0
 * Failed: 0
 * Removed: 0
 * Removal Failed: 0

-=- Asset Supplier Associations -=-
 * Created: 0
 * Skipped: 0
 * Failed: 0

-=- Asset Supplier Contract Associations -=-
 * Created: 0
 * Skipped: 0
 * Failed: 0

-=- Shared Asset User Records -=-
 * Created: 0
 * Skipped: 0
 * Failed: 0
 * Removed: 0
 * Removed Failed: 0

Total Time Taken: 3s

---- Hornbill Asset Import Complete ----

 

[billster]

Wow this tool...... finally I get it to work... but it can't differentiate in the columns the hardware type??

Seriously, I have consolidated all asset types in once csv and its just uploaded everything as a laptop. And duplicated assets. 

It is just easier for me to wipe all the assets and re upload them at this point. just wasted my time.