SNMP Data Location
Where does the Kace appliance store the SNMP data in the database. I'm trying to create a report to pull snmp data that we have gathered from our printers.
using a K1000 version 12.1.168
The table is in the DB ORGx, the DB table is ASSET_DATA_5 the column name is FIELD_????
See table ORG1.SNMP_INVENTORY_OIDS for more info.
You will most likely want to select from ORG?. MACHINE and join ASSET_DATA_5
So if you are using agentless to capture data via snmp, the KACE SMA will first create an inventory record, just as the agent would for a device. You map the data into those fields in the inventory. Just as with the agent, when the inventory record is created an associated asset record, of asset type device is created and linked to the inventory item.
So to answer your question, if you mapped the serial number into the inventory then you will find that data in the MACHINE table of the database. Any data you created or stored in the associated asset will be found in the ASSET_DATA_5 table