Does anyone knows how do I track Custom Inventory informations on an Asset Field?
For example, I have a Custom Inventory Rule that gives me Hard Drive informations and I would like to create an Asset Field to get this information.
3 Comments   [ + ] Show Comments

Comments

  • Same here trying to figure out how to add SNMP properties for OID to Inventory Field Mappings I saw it in video they had more options but can't find it any where in dell kace where i can add more properties.
  • What exactly are you trying to achieve, do you want to use an OID to retrieve data from an Agentless scan, or do you want to copy Inventory from an agent scan into an Asset field?
  • I have custom items copied from the Inventory to the Assets. Here is an example of the SQL to copy the data:
    Select
    ASSET_DATA_5.FIELD_10121,
    MACHINE.BIOS_SERIAL_NUMBER
    From
    ASSET Inner Join
    MACHINE On MACHINE.ID = ASSET.MAPPED_ID Inner Join
    ASSET_DATA_5 On ASSET.ASSET_DATA_ID = ASSET_DATA_5.ID

    UPDATE
    ASSET_DATA_5.FIELD_10121,
    MACHINE.BIOS_SERIAL_NUMBER
    SET
    ASSET_DATA_5.FIELD_10121 = MACHINE.BIOS_SERIAL_NUMBER

    *NOTE*
    Note that you will need to identify the DB value for the fields you create in your Asset, so that the SQL can be updated with the data.
Please log in to comment

Answers

0
So as a combination of the comments above, if you have a custom inventory field that populates the data you require into the inventory tables.

Create the asset field within the Asset type, I am assuming it is a Device Asset

Next take note of the Asset field name (shown below in Yellow) and the custom inventory name (shown below in Orange)

Then use the code provided above by bstutz to copy the data across, within a scheduled ticket rule if you want it to be regularly updated or just run it once to populate the asset table once.

Select
ASSET_DATA_5.FIELD_10121,
MACHINE.BIOS_SERIAL_NUMBER
From
ASSET Inner Join
MACHINE On MACHINE.ID = ASSET.MAPPED_ID Inner Join
ASSET_DATA_5 On ASSET.ASSET_DATA_ID = ASSET_DATA_5.ID

UPDATE 
ASSET_DATA_5.FIELD_10121, 
MACHINE.BIOS_SERIAL_NUMBER
SET 
ASSET_DATA_5.FIELD_10121 = MACHINE.BIOS_SERIAL_NUMBER
Answered 01/12/2016 by: Hobbsy
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity