KACE Product Support Question

Is it possible to connect database via Web page?

07/21/2016 1150 views

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:
0 Comments   [ + ] Show comments


Answer Chosen by the Author

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 :)

Don't be a Stranger!

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

Sign up! or login


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