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→
I am working my way through the online course “Cert Prep: CompTIA Security+” by Michael Chapple. This is available on Lynda and LinkedIn Learning. These are my study notes- Section 1 – Threats, Attacks and Vulnerabilities 1.1 Malware 1.2 Understanding Attackers 1.3 Understanding Attack Types 1.4 Application Attacks 1.5 Vulnerability Scanning and Penetration Testing 1.6 Impact of Vulnerabilities Section…
Continue Reading→Who couldn’t do with a confidence boost? Take 3 and a half minutes of your day and watch Jocko give his advice on how to increase your confidence.
Continue Reading→
In this video Dr Rhonda Patrick and Dr. Satchin Panda discuss what ‘Time Restricted Feeding’ is and the benefits it has for the body. The video goes for 90 minutes but there is some great information in there. If you don’t have the time to watch the video, check out my notes below What is the circadian clock? Every…
Continue Reading→
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→
We all know what its like trying to deal with that ever growing list of tasks. You get stressed just looking at the tasks and spend more time worrying about the list then actually working and dealing with any of the tasks. The following is some sound advice taken from the book ‘Extreme Ownership’ “Even the most competent of leaders…
Continue Reading→Backing up SQL databases with Powershell is quite useful and is probably easier than you think. This can be used in situations where you only have the SQL Server Express edition installed and can’t manage backups through the SQL Management Studio, or if you just want to do some one off backups Install SQLServer Powershell module 1. Open a Powershell…
Continue Reading→
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→
Introduction I have being playing around with Powershell a lot more lately and trying to learn and utilise it as much as possible. One of the repetitive tasks we deal with is when a student exits the school. There are a number of steps in AD that have to be undertaken each time a student leaves. These include: Disable the…
Continue Reading→
As a Sys Admin, I am probably a bit late to the party with how useful PowerShell can be. I have lately completed a couple of online courses about PowerShell and am trying to use it as much as I can in my day to day work. I am finding it incredibly useful in work and relatively easy to pick…
Continue Reading→