Hi Guys,

I'm an IT guy who just joining newly establish company that have sports marketing industries background. I plan to install an application that will satisfied the small needs for this company such as Inventory System and Library/Support System.

Inventory system here means, system that only capture how many office laptop/hardware been assigned to which employees and its specification. And also how many PC/laptop we have left in inventory that free to used.

Library/Support System here means more like capture how many complains or support request been made at IT Department and also can become dictionary for them to answer frequently asked question.

IT Department in my company only consist 2 person and we have lots of thing need to do. So, any great help on which application should I install from you guys really help.

Thanks in advance.

Hello and welcome to LQ.


Might start at Turnkey linux. They have some pre-made distro's with included applications. However, it doesn't seem to be that you'd need much. Modern word processor programs like Libre/Openoffice have a database/spreadsheets. There are many distro's that have a package management system that offers a number of programs that can control inventory or create lists.

Other members may have some ideas too.

I'm not associated with this project, and I've never used it. But somewhere a question came up about how to deal with property management for a SMB environment (not samba) using open source, and http://www.openmaint.org/en came up. That front page talks about space and asset inventory.

At previous jobs, I've seen just a Access database used! Wasn't superb, but it got the job done. Frankly, the biggest deal is just ensuring everyone documents what they're supposed to, regardless of the tool you use. If that one employee cannot figure out the application, or always forgets, that's a lot of untracked assets which I'm sure causes headaches later.

Sounds like you could just use text files for what you say you are needing, these are searchable using grep for instance.
Or a small database such as sqlite3, maybe create some forms for data entry & the like.
The above need minimal resources.

Office suites have wordprocessors, spreadsheets, & usually a database, if you want a GUI.

You need to look at osTicket:
http://osticket.com/features

Has built-in knowledgebase/FAQ capabilities, help desk ticketing system with email follow-ups/reminders, which takes care of a lot of what you posted.

It's got built-in reporting, so you *COULD* create a 'ticket' for each laptop/system you have, and assign it to a person who's checking it out, along with an SLA/'due date'....it'll remind them to bring it back (or at least follow up) on that date, and since you know how many you have to start with, a simple report of 'open tickets' for systems would tell you how many are out/available. MySQL driven, easy to install/configure on any version of Linux, and web-based, so it works with any browser/phone/tablet.

As well as creating your own databases, there are quite a few specialised tools available free, like this
https://linuxappfinder.com/package/request-tracker3.4