NetApp: Show NetApp Serial Number with Command

The following command allows you to show the serial number of your NetApp storage:
sysconfig -a

Google: Autofill Numbers and Related Data in Google Spreadsheets

Google Spreadsheets can autofill cells with sequential numbers and other related data, like rivers and countries. It's still not an advanced Excel, but this feature can save you some time when you're numbering a column.

This feature works with both rows and columns. For example, start out by numbering your column with 1, 2, and 3 in three cells next to each other. Then select those three cells and move your cursor the the bottom right-hand corner of the selection. (You should see a blue dot.) Hold your Ctrl key (Alt/Opt on Mac), then click and hold the dot, and drag your cursor down—or across if you're filling in rows. (Note: This isn't strictly necessary with numbers, but with related data like countries, it is.)

It works for sequential numbers (1, 2, 3...), even numbers (2, 4, 6...), and more. Adding to the niftiness of it all, you can also autofill countries, car manufacturers, and other related sets of data. Try it out, and we'd love to hear about any other sets of data that you come across that this autofill works for.

BlueCoat: View Event Logs and Syslog of BlueCoat PacketShaper

To view the event logs and Syslog of your BlueCoat PacketShaper, please refer to the following steps:

1. Click the Info tab.

2. Click file browser.

< View Event Logs >

3. Go to the unit's data disk, 9.258/

4. Go to the LOG/ directory. The event logs are listed. The file named EVENTS is the current set of log entries. The EVENTS.n files, where n is a sequential number, contain archived event records.

5. To view the contents of the current log file, click EVENTS.

< View Syslog >

3. Go to the unit's data disk, 9.256/

4. Go to the LOG/ directory. Then, go to the SYSLOG/ directory. The files named pshaper and messages are the Syslog files that you can refer to.

5. To view the contents of the syslog file, click pshaper or messages.

Microsoft: Remove Extra Spaces in a Cell in Excel

The following formula allows you to remove the unwanted spaces in a cell:
Substitute(A1," ","")