The Journey

Where I work, we decided to use Google Chromebooks eight years ago. When we looked at all of the factors for our situation, it seemed like the best choice and, it worked out well for us. We are a Google reference school, and during the COVID-19 shutdowns, technology wasn’t an issue for us. This week,… Read More »

2N® SIP Speaker Auto Provisioning

We’re rolling out a new public address system at work and have opted to install it ourselves because the cost of outsourcing it would have blown our budget. The upside was this enabled us to go for a full IP based system with the savings and still be well under budget. The system we selected… Read More »

Install Unifi in Docker

Containerizing Unifi has the benefit of OS updates not impacting you. Gone are “oh shoot, I updated Java and now UniFi won’t start because it wants some other version” problems. When you want to upgrade to new version, type: You’ll likely want to clean up unused images. docker images to see. You’re likely going to remove images… Read More »

Reset User Passwords and Add Missing Users to Active Directory via PowerShell from Google Accounts

MySQL SQL Code SELECT SUBSTRING_INDEX(Google.primaryEmail , ‘@’ , 1) AS ‘SamAccountName’ , AS ‘GivenName’ , AS ‘Surname’ , AS ‘DisplayName’ , CASE CONVERT(SUBSTRING_INDEX(SUBSTRING_INDEX(Google.orgUnitPath , ‘/’ , – 1), ‘ ‘, -1),UNSIGNED INTEGER) WHEN 6 THEN “OU=7,OU=Middle,OU=Students,OU=Users,OU=Thornlie Accounts,DC=tcc,DC=wa,DC=edu,DC=au” WHEN 7 THEN “OU=8,OU=Middle,OU=Students,OU=Users,OU=Thornlie Accounts,DC=tcc,DC=wa,DC=edu,DC=au” WHEN 8 THEN “OU=9,OU=Middle,OU=Students,OU=Users,OU=Thornlie Accounts,DC=tcc,DC=wa,DC=edu,DC=au” WHEN 9 THEN “OU=10,OU=Senior,OU=Students,OU=Users,OU=Thornlie Accounts,DC=tcc,DC=wa,DC=edu,DC=au”… Read More »