• Home
  • About

SPK Tech Fit

Technology, Fitness & General Ramblings on Life

Category: Spiceworks

Power BI, Spiceworks, Technology

Spiceworks Reports with Power BI(with Video tutorial)

sean / September 8, 2017

Power BI is a fantastic, and relatively easy, way of getting some great reports and analytics out of your Spiceworks database. UPDATE: I have added this video tutorial to hopefully make this clearer and easier to follow.

PowerShell, Spiceworks, Technology

Spiceworks: Unassigned tickets report with PowerShell

sean / May 19, 2020

An “Unassigned Tickets” report is very useful for making sure everyday that all tickets are being picked up and not left sitting unassigned. Spiceworks has the built in report functionality which are great, but the only issue I have with them is that you cant put report content directly in an email, it sends it as an attachment. So I…

Continue Reading→

PowerShell, Spiceworks, Technology

How To Export Spiceworks Reports to HTML Using Powershell

sean / September 29, 2018

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→

Sean Keenaghan

About

Father, Husband, Sys Admin, Fitness Addict, Combat Sports Fan and K9 Enthusiast. Always trying to learn, challenge myself and improve. Hopefully I can teach a bit along the way too!

Email: sean[at]spktechfit.com

  • twitter
  • linkedin

Recent Posts

  • 14. AOS-CX Management Tools
  • 13. Secure Management and Maintenance
  • 12. Stacking
  • Aruba Certified Switching Associate – Study Notes
  • 11. OSPFv2 Single Area

Recent Comments

  • sean on Jocko Willink: Life is All Based On The Decisions That YOU Make. So Live a Good One
  • Don Davies on Jocko Willink: Life is All Based On The Decisions That YOU Make. So Live a Good One
  • Vinod Kumar S on 1. AZ-104 Study Guide
  • sean on Jocko Willink Podcast Q And A
  • Randy on Jocko Willink Podcast Q And A

Archives

  • June 2024
  • May 2024
  • June 2023
  • September 2022
  • July 2022
  • May 2022
  • April 2022
  • February 2022
  • January 2022
  • November 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • December 2019
  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • March 2019
  • October 2018
  • September 2018
  • June 2018
  • March 2018
  • September 2017
  • August 2017

Categories

  • Aruba Switching
  • Azure
  • Comptia Security+
  • Health & Fitness
  • Life
  • Office 365
  • Power BI
  • PowerShell
  • Security
  • Spiceworks
  • SQL Server
  • Technology
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © All rights reserved.
Blog Way by ProDesigns