Power BI is a fantastic, and relatively easy, way of getting some great reports and analytics out of your Spiceworks database.
Continue Reading→
Category: Spiceworks
How To Export Spiceworks Reports to HTML Using Powershell
Introduction This allows you to query the Spiceworks database and save the results as a HTML report. It uses the PSSQLite Powerhsell module and then the ‘ConvertTo-HTML’ command to output it to HTML. Step 1: Create your SQL Query It is best to run your test query’s against a copy of your Spiceworks database, not your live database. There are…
Continue Reading→