Export a device software list from Spiceworks to Excel

Posted by: David

Here is how how you can export the software list for a specific device to excel in Spiceworks.

1. On the Spiceworks menu, go to the reporting tab.

2. On that reporting tab,  in the reports window click on "New Report".

3.  On the new report screen, click the image below to see how you should select the information on that screen.

You will need to build the report using SQL.  Just replace 'devicename' with the name of the device you want the report for.  The code for the SQL is below

SELECT software.name as Name, software_installations.version as Version, software_installations.install_date as Install_Date
FROM devices, software_installations, software
WHERE software_installations.computer_id = devices.id
AND software.id = software_installations.software_id
AND devices.name = 'devicename'
ORDER BY software.name ASC

4.  After you have built the report the way you have needed, hit "save and run".

5.  After running the report you should see a list of the software from the device below.  However to export the report to excel all you have to do is hit the export button and choose XLS next to the excel icon and save it or open the file as you see fit!

ENJOY