Sorting Gmail Inbox by Size

Of all the weird functionality that has been left out by Google in the current version of Gmail, this one struck me as very funny. For some reason, Google didn’t think to implement any way for you to easily sort your entire inbox by size. Sadly, the amount of space that you can store in your Gmail inbox is limited – SCU student accounts only get 30 gigabytes total. This means that when you’re about to run out of data due to a relatively small number of large emails, Google hasn’t implemented an easy way for you to solve this problem.

Luckily, there are a few options that have been added by some great people to help solve this issue.

The first, less functional solution has recently been added by Google to filter emails that are above a certain size (although this method doesn’t allow you to see the actual size of each email, so it isn’t all that helpful right up front). In order to filter your Gmail inbox messages and see only those messages above a certain size, simply type size:#m into the search box at the top of the window – replacing ‘#’ by the number of megabytes you want to set as the low-end cap on your filter. For example, size:5m will show you all of your messages that are over five megabytes in size.

For a complete list of Gmail filter commands, see:

https://support.google.com/mail/answer/7190?hl=en

Luckily there is another method to filter your Gmail inbox by size which creates a list of all large (over one megabyte) emails that you currently have. This fantastic method involves a quick script that scans your inbox and imports information about all large emails into a spreadsheet that is stored on your own Google docs, making it safe and easy to use.

Detailed information on this method can be found at:

http://www.labnol.org/internet/sort-gmail-by-size/21191/

Basically, copy this formatted spreadsheet into your docs by following this link:

https://docs.google.com/spreadsheet/ccc?key=0Aofk8L6brI_edDJMeXBoRTNTdzA4RVE4MzUtTlV0cmc&newcopy=true

Then in the menu tabs across the top of the page, click on ‘Gmail(click here)’ and press ‘Reset Canvas’. Wait a moment for the canvas to reset and then you will recieve a popup asking for authorization to access your inbox. Hit accept, since this is simply YOUR Google Docs asking to read YOUR Gmail information with no information from either getting into anyone else’s hands. Finally, choose ‘Scan Mailbox’ from the same ‘Gmail(click here)’ menu and, after a brief pause, all of your large emails will appear in the spreadsheet displaying sizes and other information! The last step is to click on the letter D above the column labeled ‘Size (in MB)’ and choose ‘Sort Z -> A’ which will sort your emails largest to smallest and allow you to follow a link back to those emails rather than searching through your inbox for them.

New Deal for Microsoft Word

Microsoft HUP is no more, but fear not! Although it’s no longer a ten dollar steal, CollegeBuys still offers a nice forty dollar deal on Microsoft Office at the following link:

http://www.foundationccc.org/CollegeBuys/ForStudents/tabid/468/Default.aspx

It is important to remember that when purchasing Microsoft Office through this site, after choosing your school and getting through the initial forms, you have to make sure that you use an SCU email address for the link to be sent to so that it will work for sure.

At this time, this is the best deal that we can get for students, faculty and staff. A ‘dot’ edu email address is required for this to work, so if you are talking to visitors or guests about this, just tell them that all they need is an @(someschool).edu address.

 

OS X Mavericks and Anti-Virus

With the recent release of OS X Mavericks we have a whole new array of fun issues to take care of. Although we don’t support Mavericks yet, we have been working to better understand it in relation with our network compliance policies. The main issue so far has been that many anti-virus suites still don’t support Mavericks at this point (or at best they’re in beta and still buggy).

Symantec is currently working on getting something together to support Mavericks, but probably wont be ready until mid to late November. Sophos is also working on getting something together here in the next few weeks. At the moment, Avast! is the only anti-virus provider who claims to support Mavericks.

The Avast! version that is rumored to work best (note: some bugs still being reported) is the beta2 version, which can only be found on the Avast! forums. Download at:

http://files.avast.com/files/beta/avast_free_antivirus_mac_setup-beta2.dmg

Rather than waiting for all of these companies to come out with support for Mavericks we’ve found that with the new OS there is a work-around to keep Symantec. If a mac with a working and up to date Symantec suite is upgraded to OS X Mavericks then Symantec should continue to work fine, at least with what we’ve seen so far.

This is a screen shot of what a compliant mac running OS X Mavericks and Symantec will look like.

This is a screen shot of what a compliant mac running OS X Mavericks and Symantec will look like on our network.

This Symantec work-around only seems to work if the Mac in question already had Symantec installed, running, and up-to-date prior to upgrading to Mavericks. If someone does want to upgrade, try and advise them to at least use time machine before so that in the case of falling out of compliance with out network they can roll back to a working system.

Using Windows 8 Refresh Tool

Windows 8 has a very helpful built in refresh tool which re-installs windows without destroying your personal files and windows settings. Any apps that were not originally installed with the OS or downloaded from the Windows Store will be deleted and an HTML file will be created on the desktop detailing what software has been removed.

This tool is extremely helpful in many cases. If the computer is missing certain drivers or the OS is incorrectly installed, using refresh can make for an easy quick-fix.

For a step by step walk through on using Windows Refresh:

http://windows.microsoft.com/en-us/windows-8/restore-refresh-reset-pc

For more information on what Refresh does and how it works:

http://www.pcworld.com/article/251527/windows_8_refresh_feature_makes_it_easy_to_start_with_a_clean_slate.html