Is it possible to connect database via Web page?
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.
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.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
7 years ago
Top Answer
The database is only available for readonly access using the reporting user. You can enable to reporting user under Settings, Security Settings.
Comments:
-
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. - altank52 7 years ago-
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. - chucksteel 7 years ago
-
thank you - altank52 7 years ago
-
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? - altank52 7 years ago -
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. - chucksteel 7 years ago -
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? - altank52 7 years ago
-
MySQL Workbench is free. - chucksteel 7 years ago
-
Thanks, you are the best :) - altank52 7 years ago
