Driver Inventory To Excel

An inventory control spreadsheet is vital for a business because it is a recorded history of products purchased. Get it free here.

Consider a scenario, where you need to take an inventory of all the Device drivers installed on your machine. This information will be very essential to identify the vendor details, Driver files and other important stats. Driverquery command will exactly help us in this purpose.

Running the Driverquery command in the Command Prompt will list out all the drivers installed on the machine. Run the Command Prompt in Administrator Context

If you want a compact record of installed drivers in a reporting format, use this command with appropriate switches. As we saw above, DriverQuery command gives all the information; You can modify the output of the command with a variety of switches, and you can redirect the output of the command to a file so that you can load it in another program.

You can use the /v switch to produce a detailed verbose information, and add the /Fo switch with the CSV parameter to generate the output in the csv Comma Seperated Value format. – driverquery /v /fo csv drvlist.csv

Further, Opening this file Driverlist.csv in Excel will give you a highly detailed list of all your hardware. as shown below – Click the image for ful size

Similarly, using the /SI switch to get all the information on the signed drivers installed on the machine.

DriverStore is a new and a central location in Windows Vista and Windows 7 where all the driver files will be stored., before they are copied to their final destination during the device driver installation. – Read more to Understand better

For a full list of the switches available for the Driverquery command., run the driverquery with a /. switch.

You would also be interested in reading –.

Apr 17, 2013  Printers Inventory This script build to collect Printer details from local, remote or Printer server.Which gives us - Print Server,Printer Name,Port Name.

May 14, 2015  Use System Center 2012 Configuration Manager hardware inventory to collect detailed information about the hardware of client devices in your enterprise.

• Drive Inventory makes an Excel spreadsheet of all the files on your hard drive. Or put the list into a web page, a text file, a rich text file, or an image file JPG.
• Getting information from all installed printers on a print server can be an impossible task without third-party tooling or scripts. PowerShell can make this really easy.

For companies looking to determine their inventory holding costs, here is a sample excel sheet calculating inventory holding costs.

For those companies that rely upon manual inventory processes, here is a sample inventory costing excel sheet with a graph pie-chart of expenditures.