Our company would like to have a small script or application (EXE) written that will enable our technical staff to go on site, and programmatically gather PC information quickly, and then have that data append to a CSV or similar format. The end goal is to have a CSV that can he imported into Excel, with headings (Name, Service Tag, CPU type, CPU speed, size of the c:\ drive, Installed RAM, OS name, OS Product Key, Office Version, and Office Product Key) and then the gathered data would be placed automatically beneath the proper headings for easy viewing and sorting.
This app/script would only run on Windows PCs, and needs to have the ability to run either as a script (Batch File that is executed on user login, which will put collected data in central location on the server) from a server, or from USB thumb drive. The information we would want to garner is as follows: PC Name, Service Tag, CPU type, CPU speed, size of the c:\ drive, Installed RAM, OS name, OS Product Key, Office Version, and Office Product Key.
So to sum it up:
-App to collect certain information about a PC or Server
-App grabs data from PC and stores in CSV format, 1 PCs worth of info per line or row
-CSV can be opened in Excel and headings/data all auto-magically apprear
-Data in Excel is clean and sortable.
Thanks for reading!