A database to store dmidecode information. Upload through a php-script, store in a postgres database. This is intended to be a tool for those who, like me, has quite a few PCs at home, and most of them are received second hand.
Information may be uploaded using curl:
dmidecode > dmidecode.dat
curl --form Datafilemail@example.com --form system=$HOSTNAME http://<host>/dmistore/upload.php
So far: Upload, view of single system and database schema.
The database is designed like
System (computers) -< header -< item -< subitem
where header is e.g.
Handle 0x0100, DMI type 1, 25 bytes
An item may be:
Runtime Size: 64 kB
Where “Runtime Size” and “64 kB” are split and stored in different fields
and subitems are what typically is listed under Characteristics eg
PCI is supported
- Make reports of all systems,
- CPU + RAM + max ram
- mysql compatible (although postgres is, and will be my main data base system)
Note: There is a wrong schema.sql in v 0.2, the correct one can be found here (please do not bookmark this link, it will soon change).
Version 0.1 – upload should work. Needs postgresql (i’m running on 8.4, but most reasonably recent version should work) php 5.x and the smarty templating library.
If anyone can use anything from here, I would appreciate feedback.