2010/08/26 Daily tasks

1. Send out two little thing email
2. Setup testing xmail server for Fe team
3. Prepare and upload image to S3 for newsletter
4. Discuss two little thing in room 4

2010/08/25 Daily tasks

1. Bi-weekly update meeting (without VP )
2. Out for H3C for workshop in afternoon.
3. Restart Rsync due to reboot of web1 and web2 yesterday

2010/08/24 Daily tasks

1. YA AMM
2. update website performance data from 1 to 24 for review
3. update email address for backend team
4. confirm with FE and catalog that we will change the YA image server at 03 Sep 2010
5. reboot web1 and web2 for patching
6. reboot dc4 for patching

2010/08/23 Daily tasks

1. Setup notebook for Kevin for SH office training
2. YS AMM
3. Check Rsync progress , web2 is much faster than web1 ...
4. Check with catalog team for ftp setting update
5. Arrange SH designer to fix scale in png problem .
6. Draft two little thing to discuss
7. Claim July expense.

2010/08/20 Daily tasks

1. Check with Dell for new pc quotation and configuration.
2. Check for account team for 2010 Jan - Jun budget usage for Capex
3. Confirm rsync time ( 5rd batch ) for YA image which is around 6 hours ..
4. Estimate the 2nd half year Capex usage
5. Confirm Drinks delivery date and amount from CocaCoca.
6. Modify rsync command for file permission.

2010/08/19 Daily tasks

1. Check Tom's wireless problem
2. Check old pc inventory data
3. Update Dell server inventory for warranty renewal
4. Give a barcode scanner to CS for shipping list scanning
5. Ship out a barcode label printer to Taiwan
6. Order Drinks for colleagues
7. Draft old PC replacement plan
8. Check with PacNet sale for MetroNet service details , relocation cost
9. Continue to check for rsync status and check the linux image server disk usage
10. Remove some non-useful service from linux image server
11. Copy remove 20-29 folder from assets.

2010/08/18 Daily tasks

1. Change F5 monitor setting for secure sites
2. Install new Ricoh printer for Account team to print cheque. The old HP is EOL
3. Meeting with PCCW Engineer for Phone system requirements
4. Fix Tom's laptop ( Norton vs Mcafee combat ) using teamviewer..
5. Draft 2011 IT budget plan

2010/08/17 Daily tasks

1. Check F5 CPU usage and find that logging of all ys image traffic will consume 25% of CPU resource . Stop the logging
2. Continue to test rsync for image transfer. YS => 1 day = 12%, YA=> 1 day = 80%
3. upload image to S3 for newsletter and update html for new links
4. MBK meeting in our office

Rsync - From Window to Linux

1. Download cwrsync server from http://www.itefix.no/i2/node/10650.
2. Install it as service
3. edit the configuration file and manually start-up it

Here is the sample

uid = 0
gid = 0
use chroot = false
strict modes = false
hosts allow = *
log file = rsyncd.log

[test]
path = /cygdrive/d/backup
read only = false
transfer logging = yes

4. in linux , yum install rsync if you don't have it.
5. run the command

rsync -av --delete --progress Window_IP::test /local_path/

To set the file permission with rsync
rsync -av --delete --chmod=a+rw,g+r,o+r remote_IP::remote_directory /local_directory/

2010/08/16 Daily tasks

1. Fix KR PC virus problem.
2. Orientation for new staff
3. Setup rsync for image server and test sync to new linux image server
4. prepare 2010 budget worksheet

2010/08/13 Daily tasks

1. Prepare PC quotation for general staff and new designer
2. Setup PC for CN office
3. ASM

2010/08/12 Daily tasks

1. Q3 monthly AMM
2. Reover harddisk data for Joyance

2010/08/11 Daily tasks

1. Check and test Rsync server syntax
2.

2010/08/10 Daily tasks

1. Record for Aug invoice ( PACNET, WT&T, NWT, NEW TECH )
2. Photo for Tom's damaged laptop case and box
3. Monthly IT team update meeting
4. Check Rsync options
5. update 15 min order number check script to include ys.au and ys.hk site

2010/08/09 Daily tasks

1. Recovery email for Raina
2. Burn CD for KH
3. Check F5 strange CPU/RAM utilization
4. Check Tom's old laptop harddisk ... Certified ..two laptop shipped from US office are heavily damaged due to no package .... 0_0 .....

2010/08/06 Daily tasks

1. Meeting for future development roadmap
2. Upload office setup file for US store
3. Prepare label printer for TW agent
4. Cut some CD for material of the label printer roller
5. Discuss about the MBK site email bounce back handling and verification

2010/08/05 Daily tasks

1. Chase Ricoh to get the Hitachi leasing breakdown schedule
2. Ask Alcatel engineer for system information and suggestion.
3. Move some web1 and web2 ya images to external storage
4. Setup Gmail account and email forwarding for Tom so that he can work at home with company emails
5. troubleshooting for Aman' pc

2010/08/04 Daily tasks

1. Check Image storage and plan to move them
2. Check MBK site bounce back email list
3. Send Update offline member report to HMB
4. Update DNS for YSSTYLIST domain and update F5 to take care it with YS site
5. Lookup DB for Wang about the bounceback email list info.

2010/08/03 Daily tasks

1. Review July system performance and update data to xls file
2. Install Office 2007 format converter for US office PC
3. Out of 8 Tel for phone system demo in afternoon
4. Upload YS newsletter image for S3 for testing

CentOS - non-English support

yum groupinstall "Chinese Support"

2010/08/02 Daily tasks

1. Report for MBK new member
2. Check f4u site information . No information shows that they have crawled our site for data.
3. Talk to marketing team for new domain of associates arrangement. They requests up to 6 months of graceful period .. but I have suggested the 3 months work flow for them .
4. IT team manager meeting for last month
5. Explain to Pauline about the new phone system's quotation and ask her to confirm the user requirements with CS team .
6. Fix some email list undelivery problem due to del of old email address ...

2010/07/28 Daily tasks

1. Setup subdomain for associates to separate their image traffic from our normal traffic.
2. Update F5 and irules for checking referrer

2010/07/26 Daily tasks

1. PMP filling
2. renew YS secure cert . I miss all the notification email ....
3. Setup new copier for JP office
4. Again, troubleshooting YS blog xml problem.

2010/07/24 Daily tasks

1. Trouble shooting ys blog rss feed issues with F5. All other page are ok .. just the rss feed page is not reachable .

2010/07/23 Daily tasks

1. Morning ( 3:00am ) support for US store PCs
2. Go to datacenter to troubleshoot the HGC line
3. Meeting with WT&T for phone system quotation and solution overview.

2010/07/22 Daily tasks

1. Checking facebook like button error. Facebook cannot call the blog link and return error. Remove facebook from all allow crawler agent data group from F5 but still no progress .
2. Meeting with phone sale ( Tech2 Value )

2010/07/21 Daily tasks

1. HGC sale meeting ( For Phone system and line information )
2. EMC sale meeting ( For VM information )
3. NWT sale meeting ( For MetroNet service to KR, JP and CN )
4. Check Akamai access pattern by logging in F5 for all Akamai requests. Review after 3 days or next monday.

2010/07/20 Daily tasks

1. YA AMM
2. Check DC bandwidth consumption for YA and YS image
3. MBK onsite Meeting
4. Kill "Yeti, navar.com and YouDaoBot to reduce 2Mbps traffic

2010/07/19 Daily tasks

1. Check YS.hk site cookie persistence problem with frontend team. Problem is caused by wrong cookie handling by fe code ..
2. Fix Linux VNC server issue ( reinstall X11 and Gnome desktop )
3. Renew VISA PCI scanning service contract
4. Renew application for dell credit
5. Check bandwidth usage for DC, Akamai for last week
6. YS AMM

2010/07/16 Daily tasks

1. Update F5 rules for ys.hk site
2. Check cookie persistence problem
3. Go to DC to collect NWT modem
4. Go to DC to check HGC new line problem .

Setup Linux VNC server

1. yum install vncserver.i386 ( x86_64 )
2. yum groupinstall "Desktop Environment "
3. cd
4. cd .vnc
5. vi xtartup

Here is the sample configuration
#!/bin/sh

xrdb $HOME/.Xresources
xsetroot -solid grey
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
gnome-session & (==> for GNOME)
startkde & (==> for KDE)

6. service vncserver start
7. You can vnc from your pc to it by 5901 port

2010/07/14 Daily tasks

1. copy files for web1 and web2, space 8.16G , 8.43G
2. Setup Linux Vnc server for Wing testing machine

2010/07/13 Daily tasks

1. Upload image to S3
2. Setup new massemail server for ys.hk project
3. Move traffic from NWT line to HGC line to datacenter

2010/07/12 Daily tasks

Alex takes leave today ..full day support work

1. Create login, email and backend account for new joiners in warehouse
2. Rebuild testing environment due to Sat's construction work
3. Fix PC power issue for Pauline
4. Fix China staff email problem
5. Setup 2 new PC for new joiners today and move a PC for part time
6. clean up noreply-permanent mail box for YA
7. Add some email to spam white list
8. Add Danielle to the facebook whitelist
9. Update firewall rules for monitor server agent access
10. Prepare June claim form
11. Prepare quotation for new mail server
12. Check with Ricoh sale for scan unit monthly maintenance charge , to waive it .

2010/07/09 Daily tasks

1. Meeting with HKC phone sale
2. Meeting with Infa phone sale
3. Reply emails from staff about disable USB storage

2010/07/08 Daily tasks

1. Process application for DC bandwidth upgrade
2. Ask sale for server quotation
3. Record for Pacnet, WT&T and Webmetrics July invoice
4. Check for JP new printer requirement and find the model for them to buy
5. Create new share disk for Design team
6. Recharge ipipi.com account credit

2010/07/07 Daily tasks

1. Fix Adobe reader problem for Aman and install AIO messager
2. Fix Tom printer problem
3. Fix strange email problem. A mailproc.tab is in the domain root and cause some email account not able to receive email .. after del the strange mailproc.tab. it is back to normal

2010/07/06 Daily tasks

1. Finding way to do Network switch burst testing
2. Send out email about usb virus spreading.
3. Clean virus for few PCs
4. Bi-weekly IT update meeting
5. meeting with Network box sale for product information updates
6. Mail2 is death ... switch to mail1 and plan to buy a new server to replace mail2

2010/07/05 Daily tasks

1. Load test of new switch setting ( Dual switch with dual link working as one )
2. Setup NFS and test performance... strange behavior .. why speed can over 1G while there is only 1 cable ? NFS cache ? let me take some D9 disc to try tomorrow ..

2010/07/02 Daily tasks

1. Go to datacenter to add ram for catalog server
2. Calculate MBK site production cost
3. Setup Switches for testing environment

2010/06/30 Daily tasks

1. Configuration of bonding for testing environment.
2. Take RAM from spare server and install them to catalog on Friday lunch
3. Tidy up some drawer
4. Find that store room has wet box .. report to Admin team to ask CF to come to check

2010/06/29 Daily tasks

1. Discuss with Tom about his laptop issue. We gave him new laptop about 1 year ago and he just has heart to replace it now. But his old one is crashed before we transfer data.
2. Configuration of ATS switches
3. Reinstallation of System team laptop from Win7 testing environment back to WinXP
4. Setup the rest of new switches for testing environment.

2010/06/26 Daily tasks

1. Setup laptop for Jacky
2. Fix Angel network share issue
3. Meeting with 8 Telecom for phone system requirements
4. Discuss with JP office for network cabling and new PC/copier purchasing
5. Start to test ATS for server

2010/06/25 Daily tasks

Full Day AL .... very busy at home ..

2010/06/24 Daily tasks

1. setup 2 x R710

2010/06/23 Daily tasks

1. Move my seat to new location .
2. Check MBK new arrival update requests and display logic for new arrival ball balll and discount ball ball
3. Bi-Weekly IT team update
4. Continue to tidy up the maintenance area

2010/06/22 Daily tasks

1. YA YBC meeting
2. Put LAN cable to truck for YS CN team
3. Calculate network bandwidth usage distribution for different site ( For AC team )
4. MBK meeting

2010/06/21 Daily tasks

1. YS YBC
2. Fix KR printer problem
3. Fix Catalog server disk problem ( Input / output error , try to fsck ) .. Fail, RAID memory module has problem and we have taken the RAID memory from spare server in office and travel to DC by taxi to fix it ...OS is corrupted after memory is ok ... reinstall the OS and keep /SDB data ..
( full team arrived DC and so no one working in office in afternoon )

2010/06/18 Daily tasks

1. Support for China office PC ( outlook express - Giselle , Virus ( IE default page has been hijacked - Shirly )
2. Fix Jacvin Outlook express loss email

2010/06/17 Daily tasks

1. Continue to tidy up new area and throw away rubbish in the morning
2. bi-monthly it team meeting
3. application for passport ( prepare for JP trip ) . Got confirmation to get it at 6 July .

2010/06/15 Daily tasks

1. Check and start to use ys.com.au domain to send email
2. Check 201 server network issue
3. Connect phone ext for relocated staff
4. Clean up some old stuff.

2010/06/14 Daily tasks

Whole day doing non-IT related activities

1. Move computer for YS HK team
2. Connect LAN cable
3. Move stuff
4. adjust air-con winflow direction

Some IT related stuff
1. Check 201 server for strange network behavior. Alex will to DC to check tomorrow and replace two Cat6 Cable ..

2010/06/11 Daily tasks

EMC whole day seminar ...

2010/06/10 Daily tasks

1. Install keyboard drawer for 2 x KR teammates
2. Talk to JP team for new floor requirements
3. Data loss ... due to login timeout

2010/06/09 Daily tasks

1. Record for WT&T bill
2. Move for CH Video/Music & Inventory team seats and move phone ext location
3. Personal update meeting
4. Meeting with WT&T phone sale

2010/06/08 Daily tasks

1. Proposal for Network camera for US store
2. Instruction for update whitelist of router for US store
3. Instruction for update registry for US store PC to disable the USB storage
4. team update meeting
5. Update May website performance data

2010/06/07 Daily tasks

1. Fix Maggie PC problem hardware problem
2. Record for Ricoh meter charge
3. Record for PacNet monthly charge
4. Update F5 for YS HK site configuration and irules
5. Claim expense for May ( POS server, writing pad and taxi )
6 . CF wrongly come to install 9/F cabling today ... Need to monitor their work and do other thing later .

2010/06/03 Daily tasks

1. Discuss with CF about the 9/F cabling arrangement .
2. Take leave tomorrow
3. Meeting with new CDN service sale
4. Move Racks away from wall

2010/06/02 Daily tasks

1. Sync F5-1 configuration to F5-2 due to update of new SSL cert.
2. Draw floorplan for new system team working area
3. Ask MBK to process the payment for MBK SSL
4. Check internet slowness problem ..
5. Call Ricoh for printer issues in HR room
6. Fix KR office excel problem
7. Fix CH music team product ( USB storage ) question

2010/06/01 Daily tasks

1. Recover damaged harddisk data
2. Continue to setup the US POS server
3. Check 9/F warehouse area decoration work . Should be ready on Thu for LAN cabling work
4. Update CyberSource keys for backend
5. Talk to sale for termination of NWT MetroNet line , confirm termination date as 11 July 2010
6. Send 1st payment to Ricoh for new contract ..
7. Make payment for 8/F cabling and 7 x pc order

2010/05/31 Daily tasks

1. Setup POS server for US store. ( Asrock ION330Pro's raid is very chicken ... It claims in website that it cannot support xp but in Nvidia website, there is RAID driver for XP .. ) It really takes a lot of time to keep trying with different drivers ....

Finaly Result ...WinXP SP3 + 15.46 Nforce driver are ok to boot up.

2010/05/28 Daily tasks

1. Continue to prepare the loan form
2. Move Rack away from wall for 9/F decoration work
3. Receive/install 2 x C2030 copiers from Ricoh. 3 x free printers will be delivered at middle of June
4. Process Secure Site Pro EV payment
5. Review SPF setting and using ys.com.hk for testing with our own DNS server
6. Arrange conduit work to start at next Thu

2010/05/27Daily tasks

1. HM onsite meeting
2. Review the equipment load form and modify it to suit the needs by external parties
3. Check mydomain , linux starter package content and verify MKT team requirements
4. Arrange KR office to change to fiber connection in lunch time and update IP setting in HK
5. Confirm order for 9/F cabling
6. Buy AsRock ION330Pro for US POS server

2010/05/26 Daily tasks

1. Talking to Fed Ex exchange support to understand why our email ip is blacklist while we cannot see the same record from the same website ... but it seems ok already now ... there is no bounce back after I send a email to ask them why ..
2. Ricoh printer training
3. Review how to setup SPF setting for earthlink , using ys.com.hk to test
4. Finalized the 9/F cabling quotation
5. Setup Amazon S3 service and test with demo images .. (DONE ) ...S3 is great ...

2010/05/25 Daily tasks

1. YA YBC meeting
2. Ricoh copiers training at tomorrow 10:00am
3. Fix Fedex.com stupid MX record problem ... they set their internal MX server with higher priority than the public mx server .. and they ask us to change our mx record order so as to send email to them ...( Accordind to RFC 2821 section five, they said that it is our fault that our email server don't retry if the first mx record is fail .. however, we are able to connect to their first mx record. We are able to connect but they just disconnect us immediately. How can our server know that their 1st mx server is not working in such situation ? .. ) ( reference : http://tools.ietf.org/html/rfc2821#section-5 )
4. Update April system performance data
5. Site visit by C-FULL for 9/F cabling
6. Arrange new copiers for 8/F and 9/F
7. Meet Ricoh sale for update and additional document
8. Phone verification from Verisign for EV cert application ( s.ys.com.hk)

2010/05/24 Daily tasks

1. Generate report 7 data for MBK Mar and Apr.
2. Review and remove VPN users
3. Remove the last AP from 9/F and install it to 8/F
4. buy SMS credit for ipipi.com
5. Copy web1 and web2 image 75 to 79 folder to external drive
6. Check/Create ftp account for TW agent

2010/05/20 Daily tasks

1. add discount ball ball to mbk newsletter image due to no resource from design team
2. Process application for SSL cert. (s.ys.hk, *.ys.hk , s.mbk, w.mbk )

2010/05/19 Daily tasks

1. Install and setup 2 x new Ricoh copiers
2. Rearrange some copiers location
3. Continue to setup the HR SQL server
4. Replace a DHL thermal printer with 2844-z for afternoon demo

MS window - block USB store

To prevent users from connecting to USB storage devices, use one or more of the following procedures, as appropriate for your situation.

If a USB storage device is not already installed on the computer

If a USB storage device is not already installed on the computer, assign the user or the group and the local SYSTEM account Deny permissions to the following files:

• %SystemRoot%\Inf\Usbstor.pnf
• %SystemRoot%\Inf\Usbstor.inf

When you do this, users cannot install a USB storage device on the computer. To assign a user or group Deny permissions to the Usbstor.pnf and Usbstor.inf files, follow these steps:

1. Start Windows Explorer, and then locate the %SystemRoot%\Inf folder.
2. Right-click the Usbstor.pnf file, and then click Properties.
3. Click the Security tab.
4. In the Group or user names list, add the user or group that you want to set Deny permissions for.
5. In the Permissions for UserName or GroupName list, click to select the Deny check box next to Full Control.
   
   Note Also add the System account to the Deny list.
6. In the Group or user names list, select the SYSTEM account.
7. In the Permissions for UserName or GroupName list, click to select the Deny check box next to Full Control, and then click OK.
8. Right-click the Usbstor.inf file, and then click Properties.
9. Click the Security tab.
10. In the Group or user names list, add the user or group that you want to set Deny permissions for.
11. In the Permissions for UserName or GroupName list, click to select the Deny check box next to Full Control.
12. In the Group or user names list, select the SYSTEM account.
13. In the Permissions for UserName or GroupName list, click to select the Deny check box next to Full Control, and then click OK.

If a USB storage device is already installed on the computer

If a USB storage device is already installed on the computer, you can change the registry to make sure that the device does not work when the user connects to the computer. To have us fix this problem for you, go to the “Fix it for me” section. If you would rather fix this problem yourself, go to the “Let me fix it myself” section.

Fix it for me

To fix this problem automatically, click the Fix this problem link. Then, click Run in the File Download dialog box, and follow the steps in this wizard.

Fix this problem
Microsoft Fix it 50061

Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

Note if you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Now go to the "Did this fix the problem?" section.

Let me fix it myself

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows

If a USB storage device is already installed on the computer, set the Start value in the following registry key to 4:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\UsbStor

When you do this, the USB storage device does not work when the user connects the device to the computer. To set the Start value, follow these steps:

1. Click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.
3. Locate and then click the following registry key:
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\UsbStor
4. In the details pane, double-click Start.
5. In the Value data box, type 4, click Hexadecimal (if it is not already selected), and then click OK.
6. Exit Registry Editor.

Source from : http://support.microsoft.com/kb/823732

2010/05/18 Daily tasks

1. Setup of new HRIS MSSQL server
2. Update F5 irules for Wing to block some public access to some internal testing pages
3. Look into blocking of USB storage device
4. Meeting for internal update meeting
5. Meeting for YS store security issues.
6. Short team update meeting

2010/05/17 Daily tasks

1. Support Erin* for iphone and printer issues
2. Check PT AC software issue
3. Solve 迅雷 program problem for Serena
4. physical measure of new 9/F area and discuss with those 2 teams for actually arrangement

2010/05/14 Daily tasks

1. Drawing the 9/F new floor plan
2. Find free tools to edit .ai file without Adobe software ( P.S. GIMP2 can edit .psd files )
3. Count new socket(LAN/Phone) needs and arrange location for new sockets.
4. Arrange NB2 and NB3 to reboot due to request from NB headquater
5. Reboot DC2 due to locking of files ..

2010/05/13 Daily tasks

1. Receive two new Epson LQ300+ II and replace one for warehouse
2. Fix bug for HMB my account loyalty program display for different level of membership
3. Discuss the new browsing page update for HMB .. we will discuss with them for final decision in next meeting for details
4. Generate the cabling cost of 9/F new seats.
5. Remind HR about the air-con machine connection in the newly setup area
6. Check the newly setup area for potential problems ..
7. Find that the 8/F seating plan has just last less than 1 week. They have changed their mind again
8. Reserve two old printers for Ricoh to collect

2010/05/12 Daily tasks

d1. Record for NB and Ricoh invoice
2. Check NWT invoice for April
3. Personal update meeting ( ask for massemail hardware, spare hardare, store virus issue and new seating plan for 9/F )
4. Check new V3400 notebook. It is really cheap and has good performance .. highly recommended..
5. check email bounce back from HM domain ...
6. Prepare quotation requirement for 9/F D+V port expansion

P.S. really feel disappointed about the new seat plan which don't consider our needs and actual situation of our working model. Only consider the appearance but not other real life requirements.

2010/05/11 Daily tasks

1. Fix US Store POS problem in mid-night til 4:30am ( morning off to sleep )
2. Check and count 9/F new seat plan arrange and cabling
3. IT Update meeting
4. China Unicom Sale meeting for their services ( B/W, Co-location, DIA )

2010/05/10 Daily tasks

1. Check with Ricoh for contract and autopay progress
2. Check 8/F moving status
3. Move the last AP from 9/F to 8/F
4. Record for PacNet and WT&T charges
5. Meeting for infrastructure
6. Reconnect phone line ext for 8/F
7. Arrange NB to be rebooted at Fri 17:00
8. Fix Ricoh 222SF printer

2010/05/07 Daily tasks

1. Check the rest of 8/F cabling ( AP tested OK )
2. Confirm HMB sale page update details
3. Check two new R710 servers and introduce to the team
4. Discuss/confirm Ricoh proposal with AC/Admin team and ask the sale for further information
5. Out for WT&T seminar in afternoon

P.S. Leung' last day

2010/05/06 Daily tasks

1. Check and install 8/F switches
2. Install AP for 8/F
3. Check CA domain issues for Cherry
4. Discuss HMB sale page update details
5. Arrange copiers moving arrangement at Sat morning with Ricoh
6. Talk to Phone system sale for new phone system quotation with Admin/Cs team

2010/05/05 Daily tasks

1. Follow up ricoh copier proposal. Check the May payment day to see if we need to pay May's leasing money or not .
2. Check YA abnormal bandwidth usage
3. Discuss to add more B/W for crawler activities
4. Production for Label printer small ribbon holder (step 1 )
5. Find link checker tool for Alice
6. Lower Google crawler rate to 3.x

2010/05/04 Daily tasks

1. Ask Erina for China PC purchase approval
2. Ask HR team for copier requirements and explain to them our new plan
3. Arrange to take down MBK 1 May leave notice
4. Explore the 9/F expansion possibility with HR.
5. Setup phone line for new joiner and Amy. ( no phone set for Amy yet )
6. Process order for China new PC. Dell changes the sale and need to submit some document again
7. Order for 2 x new Epson LQ300+ II
8. Talk to Henry about the new Ricoh proposal

2010/05/03 Daily tasks

Morning AL

1. Calculate MBK April Production charge
2. Add YS CN testing domain and update F5 irules
3. Talk to Ricoh sale about their new proposal 's calculation which is wrong ..

2010/04/30 Daily tasks

1. Reply questions on the YS blog project
2. Analyze Ricoh copiers proposal (extra maintenance fee for 4th and 5th years vs new plan )
3. Moving some images for image server from D to USB , to save space for YS
4. Arrange holiday message for MBK
5. Arrange MBK Photo gallery demo with extra product related photo.

2010/04/29 Daily tasks

1. Test IP camera function and quality
2. Meeting with Ricoh sale for new copier offer
3. Reply/check AOL spam complaint against our payment reminder email to Pacnet to avoid IP banned.

2010/04/28 Daily tasks

1. Meet PacNet sale for CDN service information
2. Discuss internal about the HMB comments of MBK photos taking
3. Talk to Ricoh sale for extra printer requirements
4. Quote MD for update background of MBK site

2010/04/27 Daily tasks

1. Check HM Ftp issue
2. Suggest HM to change their practice
3. reply YS autoreply email issues
4. Check Web site alert for slowness, may related to Google crawler
5. Out to HMB for meeting

2010/04/26 Daily tasks

1. YA monthly meeting
2. talk the initial 9/F expansion plan
3. Check 9/F HGC fiber connection with HGC engineers
4. Ask PacNet to check the datacenter HGC internal connection
5. Ask NWT for March invoice
6. Check with Cheung about their extra equipment requests.
- 4 x barcode scanner
- 4 x PCs
- 2 x Epson LQ300+ II
- 1 x light usage copier
7. Arrange to setup two wordpress testing environment

2010/04/24 Daily tasks

1. Clean up all new server boxes ( Find 3 keyboards and 2 mouses )
2. Clean up all game stations ( tidy up the cable and move them to a specific location , RIP ) ...
3. Add email address to spam whitelist for Tom ..

2010/04/22 Daily tasks

*** Total Support date 2/2 ( Due to Alex is on leave for 2 days ) ***

1. Look into the wordpress setup document ( basic system requirement )
2. Check report/query for Hallmark new report request
3. Repair two broken chair , one for Andy, one for spare.
4. Aman email account has over quota
5. Find out that CCTV company installed 3 CAT5E cable in our server room. Don' t know what they want to do ..
6. Move email for Rony from C drive to D drive and compact his folders.

2010/04/21 Daily tasks

*** Total Support date 1/2 ( Due to Alex is on leave for 2 days ) ***

1. Finish the evaluation of OrangeHRM. And it is not suitable for us
2. Provide suggestion to HR about their new online leave application project. Due to the current Stupid old HRM, it is not possible for us to add extra function for it, i.e. online leave application.
3. Install photo editing software for CN office Junior designers
4. Remove "show hidden folder" problem ... It may be infected by virus due to USB
- remove all autorun.inf for all root drive and USB finger
- remove C:\windows\system32\eset*
- remove usb finger's mbc.exe in root
5. Confirm cabling working with Roctec ( totally 81 single port nodes )
6. Move some internal traffic to go though 10Mbps link instead of 2Mbps ( 75% 10Mbps )
7. Eat Stephen's tea for his 1-take-passed driving license

MS Excel Vlookup syntax

= VLOOKUP ( lookup_value , table_array , col_index_num , range_lookup )

lookup _value: The value you want to find in the first column of the table_array.

table_array: This is the table of data that VLOOKUP searches to find the information you are after.

The table_array must contain at least two columns of data. The first column contains the lookup_values.

col_index_num: The number of the column in the table_array that contains the data you want returned.

range_lookup: A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing False will return exact matches only.

Example Using Excel's VLOOKUP Function:

Note: For help with this example, see the image above.

1. Enter the following data into the cells indicated:
   

   Cell Data
   
   D3 - Part
   D4 - Bearing
   D5 - Bolt
   D6 - Cog
   D7 - Gear
   D8 - Washer
   

   E3 - Price
   E4 - $17.34
   E5 - $1.54
   E6 - $20.21
   E7 - $23.56
   E8 - $1.43
   

2. Click on cell D1 and type the word Bolt. This is the part we are trying to price.
   
   
3. Click on cell E2 - the location where the results - in this case, the price of a bolt - will be displayed.
   
   
4. Click on the Formulas tab.
   
   
5. Choose Lookup & Reference from the ribbon to open the function drop down list.
   
   
6. Click on VLOOKUP in the list to bring up the function's dialog box.
   
   
7. In the dialog box, click on the Lookup _value line.
   
   
8. Click on cell D1 in the spreadsheet to tell VLOOKUP that we are looking for the price of bolts.
   
   
9. In the dialog box, click on the Table_array line.
   
   
10. Drag select cells D4 to E8 in the spreadsheet to enter that range into the dialog box. The table_array is the table of data that VLOOKUP searches for the lookup_value specified in cell D1.
    
    
11. In the dialog box, click on the Col_index_num line.
    
    
12. Type the number 2 to indicate that the data we want returned is in column 2 of the table_array.
    
    
13. In the dialog box, click on the Range_lookup line.
    
    
14. Type the word False to indicate that we want an exact match for our requested data.
    
    
15. Click OK.
    
    
16. In cell D1 of the spreadsheet, type the word bolt.
    
    
17. The value $1.54 should appear in cell E1 displaying the price of a bolt as indicated in the table_array.
    
    
18. If you click on cell E1, the complete function = VLOOKUP ( D1 , D4:E8 , 2 , FALSE ) appears in the formula bar above the worksheet.

Source from : http://spreadsheets.about.com/od/excelfunctions/qt/080722_vlookup.htm

P.S. In order to force the cell to be value, you can use paste special and in the operation menu, choose add ( which means that it will add up the value to the paste area. You just need to ensure that the area is blank and it will show the value )

2010/04/21 Daily tasks

1. Check the Vlookup function for Peggy
2. Talk to the sale for the HRM system
3. Fixing HMB production attribute problem
4. Monitoring cabling to 9/F
5. Creating HGC working ticket number for PacNet


P.S. If you employ drivers and they told you that they cannot drive your car as it is too old. You should fire them instead of buying new cars for them to make their jobs working with less techniques.

2010/04/20 Daily tasks

1. HGC meeting for new service
2. Roctek meeting for new switches
3. IT internal bi-weekly meeting
4. Monthly YA meeting
5. Check and fix MBK customer account issue
6. Getting information of HRM
7. Check 8/F cabling. Should be finished at Wed.

2010/04/16 Daily tasks

1. Go to DC to get two switches
2. Install TB and P for EMK , import her email
3. Record Ricoh meter charge invoice
4. Ship a self-made label printer ribbon holder to JP
5. Celebrate Thomas B-Day cake
6. Arrange to replace dm team all LCD with the new one

2010/04/15 Daily tasks

1. Uninstall Vega 8 and install Vega 9 trail for Jasmine
2. Checking 8/F cabling status, arrange to add a extra power socket for switches
3. Production of Label printer ribbon holders ( V4 and new version )
4. Give 3 x HKPOS barcode scanner to Cheung
5. Checking Office Proxy usage and add image extension to non-scan list to lower the CPU usage

2010/04/14 Daily tasks

1. Talk to Ada about the HMB domain ownership problems
2. Talk to Henry about the new PC arrangement
3. Review and confirm SAN storage warranty renewal
4. Discuss with Cheryl about the email digital signature research findings and issues.
5. All IT staff meeting
6. Personal update meeting

2010/04/13 Daily tasks

1. Look into AWS
2. Look into Email security ( ssl cert and digital signature )
3. Apply Comodo free email cert for testing with different domain.

2010/04/12 Daily tasks

1. Discuss with EMK about the JP NTT fiber connection ..
2. Arrange cabling for 8/F new office ( start at Wed )
3. Read the Google Big table paper ... It is interesting ..
4. Send a big label printer roller to JP office.
5. Check the new delivered Dell PC/ Monitor
6. Discuss with PL about the 8/F floor problem ..
7. Update meeting

2010/04/09 Daily tasks

1. Update F5 irules to remove cookie ( requested by Wing )
2. Talk to sale for notebook quotation
3. Oracle warranty renewal
4. Fairwell Sony and copy his files
5. Discuss KR Dodostyle blocked by google problem with Insook
6. Checking YS new Arrival slowness
7. Change Office<=> Datacenter loadbalancing policy

F5 Path + URL operation

[URI::query $uri]
Return query part of the URI

[URI::query $uri PARAMETER_NAME ]
Return the Parameter value of Parameter name
i.e. set $uri = "/path/abc.aspx?a=1&b=2"
[URI::query $uri a]
it will return 1.

[HTTP::path ]
Return path part of the URI

F5 Switch operator

Switch SELECTOR {

MATCH1 { ACTION1 }
MATCH2 { ACTION2 }

default { ACTION3_for_not_match }

}