AutoIT - WMI and Excel DB file

Cancelled Posted Jul 11, 2012 Paid on delivery
Cancelled Paid on delivery

Hi,

I have the requirement for someone to write a fairly simple and shot autoit script for me. I just don't have the time at the moment. I need this fairly urgently. I need the .au3 script, not a compiled exe.

The script will be used to install drivers for specific models of computers. It will extract the model of the PC from WMI and then compare it to a list of supported models in a spreadsheet which contains the installation location. See the attached.

Furthermore, it must install the relevant drivers for Windows XP or Windows 7. I would like the installation sources defined as:

For Windows XP: \\server\share$\drivers\WINXP\ (I will update with my relevant paths when ready, for testing use C:\)

For Windows 7 : \\server\share$\drivers\WIN7\

The script should then check if the device is XP or Win7 and set that installation source accordingly. Then it should do a WMI query to obtain the model of the device and look up the installation location in a spreadsheet.

In the spreadsheet you would have, for example:

MODEL ¦ DRIVERS

HP ProBook 6460b ¦ HP\ProBook\6460b

4178B5M ¦ Lenovo\ThinkPad\T420

Which, when combined with the installation source forms \\server\share$\drivers\WIN7\HP\ProBook\6460b or XP. All drivers are installed post OS installation.

PLEASE NOTE: The script should be written for HP and Lenovo models, using only the two above for now. The idea is we will add more models below those as we go on.

PLEASE PLEASE NOTE: While WMI get model works fine for HP, for LENOVO devices the model is actually defined in the version field. However, if you pull out model I'll map it using the spreadsheet to the relevant folder for installation.

Each installation folder will contain a "[url removed, login to view]" which we create to silently install all the drivers. So all installations must point to "[url removed, login to view]" if you need to include this.

If you feel you can come up with a better way to do this, the idea is this: I'm looking for a way to install drivers from a network location onto any PC / laptop using a database that can be edited by my helpdesk. They will add the model, copy the drivers to the share and then map it to the share in the spreadsheet. It must be a universal script that can be compiled to an executable and to which I can add any model of computer under the sun.

I'm looking to spend around £30. And I need it done by the end of the week.

Thanks

Script Install

Project ID: #2320613

About the project

Remote project Active Jul 24, 2012