Hello,

I am planing to make a web page that will list Name and IP Adress from Inventory also a few custom assets(which i can change values manually). My aim is listing important informations for us in a compact form and editing it. I want to do basically a login page, then list the all fields that i choose and editing 1 or 2 field(custom assets) on this list. Of course web page will be use internal network.
Has anyone already did such web page and is it possible to connect Database like this? If yes, what steps should i take?

Thank you.
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0
The database is only available for readonly access using the reporting user. You can enable to reporting user under Settings, Security Settings.

Answered 07/21/2016 by: chucksteel
Red Belt

  • But i can edit my custom asset values after clicking on one of my devices then Asset Subtype: None [edit] under Inventory, Devices.
    What i want to do is skipping these steps.
    • They don't give write access to the MySQL tables directly, so you can't write your own interface to skip those steps. You can try contacting KACE professional services to see if they will write something for you but that would incur extra fees.
      • thank you
      • hi, sorry to disturb you again. Is it possible to just list elements on such page then?(no edit option). It seems kind of possibe cause of readonly access but i couldn't find anything about it.
        Also there is an option about "Enable inventory API access" nad it says; API inventory access enables you to upload inventory data using the API.
        I know you already said that they don't give me access to the MySQL tables:) but this aproach works somehow. Any ideas?
      • Read only access is available by enabling the reporting user. Once you enable the user I suggest using a tool like MySql Workbench to connect to the tables and develop your SQL queries.

        Yes, there is an API for uploading inventory data but I don't believe it gives access to the asset data. It is designed for uploading data from devices that there isn't a native client.
      • Thank you for your answer. Do i need to pay for mySQL Workbench? I will use it for the company(absolute internal use and maybe there will be like 3 people use and see the website). Otherwise can you suggest some other free tool to do that?
      • MySQL Workbench is free.
      • Thanks, you are the best :)
Please log in to comment

Answers

Answer this question or Comment on this question for clarity
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share