If you are struggling with the new Location and Assigned users fields within Inventory, or if you are looking at implementing Asset Management Best Practice (BSI 55000/ ISO 55001) and Barcode scanning then you may find this blog helpful.

So with the introduction of the Barcode scanning capability in the Go App, came a number of table changes that reflect within the Inventory records of Devices.

The functionality of the Barcode scanner GoApp, for those of you who have not yet investigated, basically distils down to the following:

- Scan a single Asset (Device)
- Update a single Asset (Device)
- Associate a barcode with an Asset (Device)
- Associate a location with an Asset (Device)
- Associate a User with an Asset (Device)

When associating an Asset with a user or a location that data is now shown within the summary area of the inventory record, as well as within the Asset record.

y6DzxL.jpeg                                 lD3qae.jpeg

What KACE have also helpfully done, is rewrite the standard Asset and Inventory listing views, so that they now default to the new values. Therefore if you have been associating a location with an Asset, using the traditional method of adding the Asset Location field into the Asset type, then it may look as if all your data has disappeared.

Zmew55.jpeg

You can find your Asset Location data by clicking the blue cog and selecting the correct fields to display, but you would need to do that for every tech that logs on ......

As a workaround for customers using the Asset Location as their location fields and in particular our own BarKode customers, we have created the following workaround that we hope will be of help.

If we refer to the location shown in Inventory as the "Inventory Location" and
if we refer to the location shown in the Asset as the "Asset Location" the instructions below will allow customers using primarily the Asset Location for their location value, to duplicate the value into the Inventory location, so that the two locations synchronise. 

The benefit of this is that regardless of what location value you then select on an asset list or inventory list view, it should be the one set by your Asset Management best practice.

To do this we will use a Service desk ticket rule.

First we need to make sure that at least one device in our inventory has an Asset location value set as well as an Inventory Location value set. Choose any asset and within the Asset record add a value to both data fields, but make them different values, then save the asset record.

Next we must establish which data field within our Device Asset contains the Asset Location ID. To find this out, run the following SQL as a report on your K1000.

Select
  ASSET.ASSET_DATA_ID,
  ASSET.NAME,
  ASSET_ASSOCIATION.ASSET_FIELD_ID,
  ASSET.LOCATION_ID,
  ASSET_ASSOCIATION.ASSOCIATED_ASSET_ID,
  ASSET_FIELD_DEFINITION.FIELD_NAME,
  ASSET.ID,
  ASSET.ASSET_TYPE_ID
From
  ASSET Inner Join
  ASSET_ASSOCIATION
    On ASSET.ID = ASSET_ASSOCIATION.ASSET_ID Inner Join
  ASSET_FIELD_DEFINITION
    On ASSET_ASSOCIATION.ASSET_FIELD_ID = ASSET_FIELD_DEFINITION.ID
Where
  ASSET.ASSET_TYPE_ID = '5'

The resulting report will look like the following image

2u3HiG.jpeg

Note the highlighted line shows a location value (column 7) and an Asset ID of 5 (column 9) i.e. a Device; on any line showing these details we can see the Asset Data field reference, in this case 10041. Make a note of the number shown on your report.

Next we will create the ticket rule that will take the Asset Location Value and Synchronise the ID into the Inventory location field

In your K1000 go to ServiceDesk > Configuration - Rules and create a new (SQL) ticket rule in any available queue.

Give the rule a suitable name and description.

Paste the following SQL code into the Select Statement box:

Select
  ASSET.ASSET_DATA_ID,
  ASSET.NAME,
  ASSET_ASSOCIATION.ASSET_FIELD_ID,
  ASSET.LOCATION_ID,
  ASSET_ASSOCIATION.ASSOCIATED_ASSET_ID
From
  ASSET Inner Join
  ASSET_ASSOCIATION
    On ASSET.ID = ASSET_ASSOCIATION.ASSET_ID
Where
  ASSET_ASSOCIATION.ASSET_FIELD_ID = '10041'

Then update the number in yellow with the number taken from your earlier report.

Now paste the following text into the update statement box:

update
ASSET Inner Join ASSET_ASSOCIATION On ASSET.ID = ASSET_ASSOCIATION.ASSET_ID
set
ASSET.LOCATION_ID = ASSET_ASSOCIATION.ASSOCIATED_ASSET_ID
Where
  ASSET_ASSOCIATION.ASSET_FIELD_ID = '10041'

And again update the number highlighted in yellow with the same value taken from your earlier report.

Save the ticket rule and use the Run Now button to run the rule.

If there are no errors, the rule should have at least updated a single record, the asset you set the values for earlier in this process.

If you now check that asset record, the Asset Location value should be replicated into the Inventory Location field.

Now set your ticket rule to run every day or every hour and make sure the rule is enabled before saving.

If you would like to know more about Asset management Best Practice, how to use your KACE box to become ISO 55001 compliant or how you can cut your losses and save money by using our feature rich BarKode scanning product then feel free to contact us:

e: theindigoteam@indigomountain.co.uk
w: www.IndigoMountain.co.uk