I am in need of a hardware audit solution that will be able to provide me fast and accurate information of the computers I audit
I am inventorying approximately 2000 computers a month. What I am doing is booting up each system. I scan the serial number of each chassis and add it into my database. I then add the following attributes that I take from the bios. I type this in manually and it is very tedious. The attributes that I record are, Computer Manufacture, Model, CPU type, Cpu Speed, Hard Drive Size, Optical drive type, Total Memory size, and form factory type.
For hard drive size, I need the total unformatted hard drive size. For example I have a 750gb hard drive in my computer. I will need to know that it is a 750gb drive not the formatted size which is smaller. The same goes for the memory. If I have 4gb of memory, I will need to know that it is 4096mb.
What I am trying to do is boot these computers up and pxe boot the auditing software and have it run through command line so there is no user intervention. I would like it to do a hardware audit of the system and then send the information it reports to a sql database. I will then have my other database query the SQL database and check to see if it can find the serial numbers of the chassis that I manually inventoried. IF it finds a serial number match, it will pull over the hardware audit information and append it into the database.
1. If my programmer has his database pull from the sql database, will the categories always be the same. For example, if he pulls the processor manufacture, will it be the same for any computer that gets audited?
2. If an upgrade happens, does the structure of the database change?
3. The attributes titles of what I need are DMI Chassis Serial Number, DMI Chassis Type, DMI Chassis Manufacturer, CPU Manufacture, (What would the name of total unformatted hard drive size), (Where would total memory installed).
4. Do these titles change when I audit a Notebook, Server, or a desktop?
Please let me know if this is something that can be done or customized.