/build/static/layout/Breadcrumb_cap_w.png

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


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: KevinG 1 month ago
Red Belt
1

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


Comments:
  • I saw data in the ASSET_DATA_5 table but it was missing some of the SNMP data I was expecting to see. I am grabbing serial numbers from printers but they are not in that table. I can see them in the asset detail screen inside of Kace.

    Is there anywhere else the data may be stored? - dsekely79 1 month ago
Posted by: Hobbsy 1 month ago
Red Belt
1

Top Answer

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


Comments:
  • Thank you for the explanation. - dsekely79 1 month ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ