Computer And Software Inventory!! HELP!
Hello, im wonder if someone has got some advice for me one of my jobs here at the school is to do a hardware and software inventory, now ive got all this information in excel and stuff which i have written down as well and i want to put it in an easy to access format where I can pull up any information that management wants when ever they want it, microsoft excel with visual basic is amazing except i dont know visual basic and the time it would take me to play around with it is a waste of time, I also have thought of access but of course im not too familiar with it, when i have looked on google as you do, its all companies wanting you to install software which will scan your network and do an audit, which is all well and good if it actually tells me what I want to know and is either open source or freeware.
to give you an idea of the information i have got, we use a logging system here where we provide allocation numbers to equipment, so we have seton labels and have our company name and then a number like 100512 and then in excel that will have 100512 Video Seven Monitor, Model Number, Serial Number, Location and Previous location. which is all well and good, however I want to put in a technical specification for the machines and things i need it to be really indepth as they have got a thing on at the moment and i want to provide them with more information than they can shake a stick at but at the same time in an easy way.
For example if I wanted to say x amount of machines are failing this is the technical specification, doing a simple ram upgrade may increase the speed of the machine but of course this is not the way forward when your doing an upgrade hirachy, new at the top rolling the older machines down the chain to get rid of the obselete equipment on a shoe string budget. before you laugh we have shuttle x machines here, and the power supply has a fault if it is off for a long period of time it fails, shuttle know about this only suggest to buy a new part £50 a psu, times 3-4 maybe even 5 machines a week failing its not cost effect just replacing psus i could provide a chart or graph.
yes thats off on a tangent a little bit but im trying to give as much information as i can to get the best possible help :)
i just need to know how to go forward before i waste a stupid amount of time.
Thank You! -Josh Jacklin-