I am currently studying for my AZ-104: Microsoft Azure Administrator exam. I am studying the content using Scott Duffy’s course on Udemy, which I highly recommend: https://www.udemy.com/share/101WoMAEYdcl5bRn0F/ On the following posts I will be uploading some of my study notes. This keeps me honest with making sure I keep have decent notes and hopefully they will be of help to…
Category: Technology
Managing DHCP Scopes with PowerShell
Introduction We recently restructured our whole IP addressing schema. This was a mammoth job. The management of DHCP scopes was one part of this. We had to create around 20 new DHCP scopes and create reservations for all the devices that reservations in the old scopes. I thought to myself that this is the perfect time to learn about using…
Exchange Online Migration error: “Target user already has a primary mailbox”
Issue When migrating mailboxes from Exchange On Premise to Exchange Online, it fails with the following error: Target user ‘Users Name’ already has a primary mailbox. Cause Long before we had ever thought about migrating to Exchange Online we had manually created some students in our Office 365 tenant (not using the Azure AD Connect) to give them access to…
Comptia Security+ (SY0-501) Study Notes
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…
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.
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…
How to (Easily) backup MS SQL Databases using Powershell
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…
5.4.14 Hop count exceeded – possible mail loop ATTR34
Issue: We recently configured our Exchange Hybrid setup and were experiencing this error when sending mail from our mailboxes migrated to Exchange Online to the mailboxes still on Premise that had the alias: @ourdomain.mail.onmicrosoft.com (On Premise Mailboxes had this alias setup in preparation for migrating to Exchange Online). Cause: We use Mimecast for our email filtering. The mail loop was…
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…
Powershell: Automating Exiting Users
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…