I need help with ideas on doing software audit in our work. in ms.access. sort of automated process.
currently we are doing the following:
- using "winaudit" on shared folder in network, have each client run it and taking software inventory and saving it as a csv file.
- I collect all csv's and merge to one master excel sheet.
- import that excel to ms.access.
- run query of required fields from the access tables
- export back to excel
The problem with this one is, the end user's have to run the software audit , send it to me, I have to merge to one master sheet and all above steps are time consuming,
Instead I like to pull user's software inventory from my computer and send it directly to access database and run the query back and export to excel, how can I do this? any ideas. please. Thanks so much.