Change the -To parameter of Send-MailMessage to your own email address. Test it with dummy addresses or similar before putting it into production.I created one that will run it at 8AM every work day. Create a scheduled task to run the script.Modify the script to suit your environment.I normally create a folder like c:scripts Place the script in a location on the server.Install the SQLite PowerShell Provider into %systemroot%System32WindowsPowerShellv1.0Modules.To get it working, you need to do the following on the machine that’s running Spiceworks: Note (): I’ve updated the script to include some basic SLA support, and to split the email into multiple sections covering low, medium, and high priority tickets. The email that the helpdesk operator receives looks like this: The script gets the list of admin users in Spiceworks, and then emails them each a HTML-formatted email containing details about their open tickets. I believe that PowerShell is a great option for this sort of functionality as it’s easy to make changes to the functionality of the script, compared to a compiled executable.Īfter some strange issues, I managed to get it all working using hand-built SQL queries – for which I used this great little piece of software: SQLiteStudio.

This works out perfectly as I can access Spiceworks’ SQLite database using PowerShell. I toyed with the idea of creating a standalone application that could be customised to run certain reports, but then I came across the SQLite PowerShell Provider on CodePlex. I also have several other requirements to do with SLAs, but I’m yet to implement solutions to those. While they’re great, there was nothing that suited my requirement of emailing each helpdesk operator their open tickets on a schedule. We’ve been using Spiceworks as our helpdesk ticketing solution for years, as it was way better than any commercial options back then, and it’s still doing the job well.Īs we’re currently attempting to put more emphasis on support through the helpdesk, I thought I’d have a look at the built-in reports.

Install spiceworks sql server