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.<\/p>\n
Information may be uploaded using curl: So far: Upload, view of single system and database schema. <\/p>\n The database is designed like<\/p>\n System (computers) -< header -< item -< subitem<\/p>\n where header is e.g. <\/p>\n Handle 0x0100, DMI type 1, 25 bytes An item may be:<\/p>\n Runtime Size: 64 kB <\/p>\n Where “Runtime Size” and “64 kB” are split and stored in different fields<\/p>\n and subitems are what typically is listed under Characteristics eg<\/p>\n PCI is supported<\/p>\n TODO: <\/p>\n Note: There is a wrong schema.sql in v 0.2, the correct one can be found here<\/a> (please do not bookmark this link, it will soon change).<\/p>\n Version 0.2<\/a> Using Collapsible lists<\/a> to make the list more readable. Changed name to dmistore.<\/p>\n Version 0.1<\/a> – 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.<\/p>\n If anyone can use anything from here, I would appreciate feedback.<\/p>\n","protected":false},"excerpt":{"rendered":" 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 … Continue reading
\n
\ndmidecode > dmidecode.dat
\ncurl --form Datafil=@dmidecode.dat --form system=$HOSTNAME http:\/\/<host>\/dmistore\/upload.php
\n<\/code><\/p>\n
\nSystem Information<\/p>\n\n
\n