• Home
  • About

SPK Tech Fit

Technology, Fitness & General Ramblings on Life

Category: Spiceworks

PowerShell, Spiceworks, Technology

Spiceworks: Unassigned tickets report with PowerShell

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→
Power BI, Spiceworks, Technology

Spiceworks Reports with Power BI(with Video tutorial)

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.

Continue Reading→
PowerShell, Spiceworks, Technology

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→

Sean Keenaghan

About

IT Professional by day, Fitness Trainer by night.

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

  • Managing DHCP Scopes with PowerShell
  • Exchange Online Migration error: “Target user already has a primary mailbox”
  • Sentinel: Become the Agent in Charge of Your Own Protection Detail
  • 5.4.14 Hop count exceeded – possible mail loop ATTR34
  • Movement Practice

Recent Comments

  • sean on Comptia Security+ (SY0-501) Study Notes
  • Tig on Comptia Security+ (SY0-501) Study Notes
  • sean on Comptia Security+ (SY0-501) Study Notes
  • Tig on Comptia Security+ (SY0-501) Study Notes
  • Keith on Spiceworks Reports with Power BI(with Video tutorial)

Archives

  • 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

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

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Copyright © All rights reserved.
Blog Way by Promenade Themes