Gather and track Windows system information in Excel for all your PCs with the systeminfo command and a few switches.
Whether you are the system administrator for a large enterprise or just the person responsible for keeping your home network up and running, sometimes you just have to know some specific Windows system information. Like its predecessors, Microsoft Windows 7 has a command-line tool called systeminfo that can gather this information for you.
What's more, with a few switches, the gathered information can be placed in an Excel worksheet for tracking and comparison purposes.
The command-line utility systeminfo.exe displays information such as Windows version, BIOS specifications, installed processor, memory configuration, and network information.To access this utility, navigate to the Start menu and type command in the search box to start a Command Prompt window, as shown in Figure A.
Open the Command Prompt window.Type systeminfo at the prompt and press Enter to run the application. You will get an information dump similar to the one shown in Figure B.
Systeminfo tells you what you want to know.
While all that information is great, it is not really useful or in a condition that can be stored. However, with a few switches, you can gather it into Excel. For example, type this command at the prompt:
systeminfo /fo csv > PC_one.csvThe utility will create a file in the CSV format that contains all the system information and that can then be loaded into Excel. You'll probably want to do a little formatting to make it more readable, as shown in Figure C.