I am working on creating an inventory webpage for my company, for tracking all of our IT assets.
I chose to do this using the fog database because 90% of the devices we need to track are laptops and PCs which already exist in fog.
I have already added a couple of fields to the inventory table in fog, and created a page to view the inventory, add a new record (for items which fog doesn’t manage, like switches and servers) and edit existing records. It’s all working very nicely.
There are two things I’m having an issue with.
when I go to host management, ALL hosts are being showed (including the hosts not being managed by fog.) I would like to add a WHERE iSystype = Desktop or iSystype = Laptop or iSystype = VM clause in the SQL that the host node uses to only show laptops and desktops and VMs. Items that we enter manually have different iSystype’s set (like switch, phone, router, etc).
I would like to add an icon to the menu which will either display the inventory page in space below the menu bar (like how the built in node icons work in FOG) or just redirect to the inventory page.
I know that if/when we update our FOG, we’ll likely need to update the schema and any changes we make to the FOG proper files. I am creating very thorough documentation to make an upgrade easier.
My FOG version is 1.3.4 running on Debian 8
Any help you can provide would be greatly appreciated!