KACE Product Support

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. - amatsyplyuk 9 years ago

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? - Hobbsy 9 years ago

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. - bstutz 8 years ago