Category Archives: Scripts

Daily Admin Notification Email For Office365 Spam

One feature that stands out with Office365 Exchange is the great native spam protection it offers. My only complaint is that there is no administrative email you can configure that will show you what has been getting caught in the Quarantine. Microsoft offers ‘End user spam notifications” that will send an email to the user showing what has been quarantined for their account, but it also gives them access to release that message. Given that I still have a relatively small number of end users (160), I wanted to be the one deciding whether or not the message was actually spam.

Continue reading

Configuring Email Alerts For New PPTP Connections On Raspberry Pi

I recently bought myself a Raspberry Pi B+ (picture semi-related). I had no initial plans on what I was going to with it, but I ended up installing Raspbian and setting up a PPTP VPN in my home’s DMZ (There are plenty of guides online if you are looking to do this). The reason I went with PPTP over IPSEC or L2TP is because PPTP is so easy to set up. It took about 15 minutes to get it up and running. Even though PPTP is no longer considered a “secure” VPN, I wanted to be able to have an encrypted connection anytime I was on a public WiFi.

Continue reading

Uploading User Photos over 10KB to Office 365

I was recently faced with a very frustrating problem in regards to uploading user photos over 10KB into Office 365. Their online documentation states that “The “native” size of user photos is around 100×100 pixels, with a file size of 10 KB”. First of all, that is an extremely small and grainy photo, and shrinking my original 2 MB photo down to 10 KB left the picture very distorted. Regardless, using the Set-UserPhoto cmdlet, I was only able to upload a 4KB photo at about a 60×60 resolution. Anything over that would give me “The remote server returned an error: (413) Request Entity Too Large…” I opened a ticket with their online support and after weeks of back and forth emails and phone calls, their support technician told me that this was an issue and there was nothing to do about it except wait for Microsoft to release a fix.

Continue reading

Useful PowerShell Scripts for Office 365 Migration

I recently took my company of about 140 off of our current POP/SMTP email system (yes, companies still use POP for email) and onto Microsoft’s Office 365 Hosted Exchange. They give you PowerShell access to your Exchange 2013 server so there is a lot you can do to help reduce the time it takes to get your environment ready. Here are some quick and easy PowerShell scripts I wrote to assist with my transition.

Continue reading

Script To Reboot Cisco Wireless Access Points Daily

I recently faced a problem with our Cisco AP541N-A-K9 Dual Band Access Points. We have 5 in the office and users would complain that they were getting the “Limited Access” error or would not be able to connect at all. The problem would only happen in certain areas of the office with certain users. If the user would go to another area (switching access points), the error would go away and they would be fine. After troubleshooting the issue, I found that the only fix was to reboot the access point that was giving problems and everything would be fine. This wasn’t the perfect solution though because not all users on that access point would be having issues, and rebooting would kick everyone off for a short period of time.

I found that the best thing to do would be to write a script that would reboot all of the access points early in the morning before the users would get to work. That way all of the access points would have a clean slate to start with. Here’s how I did it:

Continue reading