Software

Quick Tip: Gather Windows system information into Excel

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.

Command line

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.

Figure A

Screenshot by Mark Kaelin for TechRepublic

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.

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.csv
The 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.

Figure C

View the system information in Excel.
Using other switches, you can gather system information about other computers on your network and add them to your CSV file. Just think, you can get system information about all your PCs in a central location —all it takes is some command-line typing. Figure D shows you the available switches and syntax for systeminfo.exe.

Figure D

These are the switches and syntax that are available for you to use.

About

Mark W. Kaelin has been writing and editing stories about the IT industry, gadgets, finance, accounting, and tech-life for more than 25 years. Most recently, he has been a regular contributor to BreakingModern.com, aNewDomain.net, and TechRepublic.

Editor's Picks