What simple storage system would you recommend?

Question

CRM

There are already a lot of similar questions, but the previous answers did not suit me ...
There is a large enterprise in which PCs, monitors, UPS, etc. are placed. An excel file is used to track the placement of equipment. The file is inconvenient in that its type is defined at the start, and there is no history there.
I would like to have the simplest accounting system, which:
a) will be simple for a beginner (system administrators will not indicate contractors and expenses - it should be enough to put the cabinet number).
b) is able to mark inventories, serials, date of installation.
c) will allow you to filter both appliances by room/user, and display a list of appliances of only a certain type (monitor/system unit/UPS).
d) Ideally - has a web face to run on a local server.
e) Unit movement history - not needed.

Here, someone's self-written project is even better than a well-known product, because. extra functions such as API, mobile application, barcode printing, a bunch of columns, menus, and so on only get in the way.
Of course, you can write something of your own in python, but now I'm studying and a little not up to it.

That is, ideally, there should be several tabs:
0) Select by type of equipment (system unit / monitor / UPS / keyboard / mouse / printer) - just a large table where you can select a filter
1) Select by room
2) Select by user
3) Selection by number (inventory or serial)
4) Again, ideally - tracking kits. If all inventories match, mark it in the additional column "completeness" (something like macros).
The fewer extra features, the better.

Answer 1

For system administration, it is worth focusing on active inventories. That is, programs that will scan the network and show equipment that can already be "decomposed" into offices / responsible. Bonus - proactive protection against substitution / theft: the cunning clerk changed the disk in the system unit - the system reported this.
seed: Total Network Inventory, OCS, etc.

Answer 2

There is a large enterprise where PCs, monitors, UPS, etc. are placed.

Oh, I do not believe that the company does not have any kind of accounting system.
Yes, the transition from Excel to the "simple warehouse system" is a local patching of holes.
Go to the authorities, this is his headache and let them look towards MRO.
https://soware.ru/categories/maintenance-managemen...

Answer 3

In order to avoid unnecessary functions, try to assemble such a plate yourself or through an integrator on a low-code erp system designer and nothing more. It doesn't sound difficult at all.
That way you can only see what you need. Filters are also easy to set up.
For example, this is how the filters look in our systems (the top line, where “available now” and “type”, you can still add / remove):
https://x.ozma.org/views/production/goods_table
Everything is simply cut out, except for the table you described and you can use. The system is configured as you like, the menu is rewritten, the fields you need are added, the ones that are not boring are removed.
You can also try just using Google Sheets with filters. Maybe they are enough too.

Answer 4

take odoo and do what you need based on it. there is a python, everything is simple. and maybe even you will find a ready-made odoo-module for your task, the task is typical.
the server is deployed locally there, everything is simple and accessible. I made and implemented five different accounting systems for customers based on it, from the call center to the workflow - everything is just there, any developer will quickly figure it out.