2010/12/30 Daily tasks

1. Discuss and process New phone system order
2. Place order for new IDAP lines
3. Check mass email capacity
4. Apply for compensation leave
5. Send material icon demo for HMB
6. Claim Oct, Nov, Dec expense
7. Check PCI Scanning result and generate report

Last working day of 2010 ....

2010/12/29 Daily tasks

1. Check and fix network issue between office and datacenter. The H3C duplex is not correct with Auto .. need to set it manually 10 Full for correct speed.2
2. Finish the email for new phone systems and request E to approve.

2010/12/28 Daily tasks

1. Fix email problem , too many connection, too many large email
2. Check/fix backend subnet network issue, replace Cisco switch with H3C switch to fix it

2010/12/24 Daily tasks

1. Prepare for maintenance
2. Pack for 2 x switch and 3 x APC power
3. Upgrade F5 firmware
4. Relocate servers
5. Replace APC power for single power input device
6. Checking after everything is back .

Work until 23:00

2010/12/23 Daily tasks

1. Oracle Flash card demo
2. Discuss phone system proposal with P

2010/12/22 Daily tasks

1. ESI demo

2010/12/21 Daily tasks

1. YA AMM
2. HMB Onsite meeting
3. Arrange Dell to come tomorrow to fix Wang's Laptop keyboard problem at 14:00-16:00
4. IT bi-monthly meeting , ask Alex to update the team for all big project and 24 Dec maintenance.

2010/12/20 Daily tasks

1. YS AMM
2. WT&T Avaya phone system demo
3. Email list update

2010/12/17 Daily tasks

1. Go to watch Mitel phone system demo in afternoon.

2010/12/16 Daily tasks

1. Move 7 x Server from datacenter to office
2. Discuss with sale for phone system ..
3. Move seat for Aman.

2010/12/15 Daily tasks

1. Talking to different phone suppliers sale for updates of system capacity and functional features. And update quotation as needed .
2. Talk with WT&T sale for IDAP application and migration of phone line.

2010/12/14 Daily tasks

1. Review phone quotation and ask questions to sales
2. Discuss about the possible changes to quotation and update the quantity
3. Check with Jack for US Retail PO system UAT
4. Talk to Wang to HMB outsource email newsletter proposal .. and finally HMB has rejected .

2010/12/13 Daily tasks

1. Review phone system quotations.
2. Move seat for Connie
3. General full email list for HMB
4. Update F5 for testing setting .

2010/12/10 Daily tasks

1. Go to datacenter to check what sever need to move, what single power supply device needed to shutdown in 24 .
2. Prepare DV and netbook for Annual dinner

2010/12/09 Daily tasks

1. Receive some final quotation from suppliers , start to review and verify
2. Look into Mitel phone system details.
3. Clean up some table for new joiner and setup power bar

2010/12/08 Daily tasks

1. Trouble shoot Palm handheld connection issue, the problem is due to the old application's ip configuration is not clear and it somehow wakes up itself causing conflict to network ..
2. Record for WT&T and NWT invoice
3. Switch AP to 123 subnet to save DHCP IP

2010/12/07 Daily tasks

1. Talk to HM for update of their frontpage of HMB
2. Continue to talk to phone system suppliers for details
3. IT AMM
4. Prepare 24 Dec system maintenance schedule ..
5. ask associate to check their DNS server and see what result that they have for the aff.x.bz domain ..

2010/12/06 Daily tasks

1. Talk to phone system suppliers for explanation of our requirements.
2. some user support work.

2010/12/03 Daily tasks

1. Check with NS for DNS lookup issue for yxi.bz domain issue. Sometimes, it returns the CDN's CName record instead of A Record.
2. send the CS call flow to supplier for final quotation ..
3. Relocate power bar for KR team so that they won't shutdown other's power easily .
4. Finish the Phone system requirement and send to Supplier for final quotation .

2010/12/02 Daily tasks

1. Calculate HMB NOV production fee.
2. Update website performance data
3. Checking UK associate image loading problem . confirm that they cannot reach our F5 when they cannot load our image, checking with NB to see if it is possible that they have blocked the request from their side ...
4. Talk to CS to verify some questions of the call flow chart ..

2010/12/01 Daily tasks

1. Draw the CS phone call flow sample for US toll-free
2. Collect and select photo for annual dinner slide show

2010/11/30 Daily tasks

1. Burn Image DVD for HM for both processed and un-processed images from Jan 2010 to now
2. Build 腳踏 with PC packing material for some staff to test the design
3. Find security training course information for S

2010/11/29 Daily tasks

Alex 又 sick leave
1. user support for CN office to setup label printer and ftp client
2. label printer has strange behavior .. trying to update the USB driver
3. Check JP account staff pc .. let her to install program freely since there are a lot of updates on account software
4. Check Image1 FTP issue, restart service
5. Roll back firewall setting to include CS in the proxy
6. Add our image domains to web-scanning excluding list

2010/11/26 Daily tasks

1. Cut NWT Line
2. Process order for China PC x 2
3. Confirm to buy 4 in 24 out phone system for SHO
4. Check payment method for Symantec sale
5. Check office internet access speed issue.

2010/11/25 Daily tasks

1. Continue to check UK associate image local problem. They use PHP script to get and resize our image ...
2. Verify UltraDNS setting
3. Draw CS call flow chart
4. Fix JP backend java runtime issue
5. Update F5 to redirect .cn site to .hk site
6. users support as alex takes AL this afternoon to go home to repair the wash machine.

P.S. 3. cannot be finished, need to work tomorrow for that ..

2010/11/24 Daily tasks

1. Setup of UltraDNS record
2. Trouble shooting UK associates image problem with our new aff.ysi links .
Check all rules and setting . they are the same as image.ys.com and so I cannot find out any source of problem .. wait for them to provide sample pages ..

test for external link of images

2010/11/23 Daily tasks

1. YA AMM
2. HMB onsite meeting

2010/11/22 Daily tasks

1. YS AMM
2. Move small copiers for Account team
3. Relocate Keyboard drawer for AC Pauline
4. Record for WT&T month fee
5. Reject HGC DIA service
6. Reject NB upgrade offer
7. Talk to WT&T for cloud based content filter service. Wait for their line to reach us at Dec
8. IT AMM

2010/11/19 Daily tasks

1. Setup Pidgin for Cherry
2. Check associates image loading problem for new aff.xxx.bz links ..
3. Fix Pidgin MSN issue by following this link ..

http://squidsrants.blogspot.com/2010/11/pidgin-msn-and-other-protocols.html

4. Update call flow chart ..

2010/11/18 Daily tasks

1. Check for Lantronix Spider sourcing and price
2. Discuss with P , Stephen and Gladys about the deployment timeline of phone system
3. Find and test sound recording and processing software to prepare recording of voice for phone system

2010/11/17 Daily tasks

1. Suggest and draw phone system call flow chart for CS team
2. Get requirements from CS team for new phone system
3. Talk to P to pick up phone system from admin team and switch copier operation to admin team
4. Process order for ultradns and ask sale for some additional service charge
5. Setup FTP for CN office to download images from HK NAS
6. Ask and suggest CN office PABX options

2010/11/16 Daily tasks

1. Read YS retail documentation of order processing
2. Discuss with Jack for detail
3. Discuss with P for details

2010/11/15 Daily tasks

AL

2010/11/12 Daily tasks

1. Update system performance metrix
2. Check CPCnet invoice issue
3. User support as Alex is not in office
4. ASM
5. Setup VPN for Henry and check his password with NB

2010/11/11 Daily tasks

1. AMM
2. Claim Pretty cash for court booking
3. personal updates

2010/11/10 Daily tasks

1. Special secret task for J and P .....
2. Replace LCD for KR team
3. Discuss about the DIA service for Office with HGC sale
4. Meeting with Network box sale for upgrade options

2010/11/09 Daily tasks

1. Meeting with HGC sale
2. unbox 5 x PC and Monitor
3. Replace LCD for IT team

2010/11/08 Daily tasks

1. YS AU site ssl cert phone verification
2. Place order for microsoft license
3. Arrange to go to datacenter tomorrow for re-installation of server for be team

2010/11/05 Daily tasks

1. Check and test for F5. The hang up is not related to high number of active connection. Need to check it again later when we can reboot it
2. Translate a new letter image link to S3
3. Meeting with Nortel sale for phone system

2010/11/04 Daily tasks

1. Check some account issue with account team
2. finish the final production of printer roller and clean up the table
3. Update F5 for testing and deployment of new payment gateway for YS site
4. F5 high volume of active connection trouble shooting
- b conn all show
- One of deployment server heavily connect to lib site . dont' know why .. but we change to use firewall as default gateway.
- F5 may have some problem in handling NAT traffic

2010/11/03 Daily tasks

1. Build printer roller
2. Receive cipherlab 8000 ccd scanner and start to configure
3. Place order for 5 x new pc
4. apply ys.au ssl cert
5. check MetroNet price from NWT
6. Fix mail merge problem for Gladys, set outlook express to be the default mail handler to solve the problem.

2010/11/02 Daily tasks

1. Record for Akamai, NWT, Ricoh invoice
2. Check for CN office , newsletter internal link issue. Fixed by Design team to automatically transform the link to correct external link format
3. Borrow a nettop to Cheryl for using in holiday in PH
4. Order for CipherLab 8000 CCD scanner
5. Ask DELL for PC quotation for HK office and CN office
6. Summarize HMB OCT production fee
7. Install software for new YS China team staff

2010/10/29 Daily tasks

1. Create bugzilla for HM special material ball ball demo
2. Update Earthlink billing information
3. HMB onsite meeting

2010/10/28 Daily tasks

1. Replace PC for Janice
2. Mass production for printer rollers ( x 10 )
3. Build a PC for Dian 's new joiner
4. Update F5 for some new server node for ya pool

2010/10/27 Daily tasks

1. Update F5 for some associated image links after migration to linux image server
2. build label printer roller ( last few steps ), Production of 4 rollers are finished. Prepare material for another 10 rollers.
3. Reply some budget related email and ask ID-Tech for handheld questions/quotations.

2010/10/26 Daily tasks

1. YA Amm
2. Setup of wireless device from motorola to connect to wifi network for testing
3. Check NAS samba ability and find that it cannot support folder level ACL .. Samba 3.3.x or above can do so but NAS don't have it yet ...
4. Move marketing and blog folder to a bigger disk and change the access right for them

2010/10/25 Daily tasks

1. YS AMM
2. remotely support for JP office

2010/10/22 Daily tasks

1. make label printer roller
2. Update F5 cert for ys.hk testing domain of secure

2010/10/21 Daily tasks

Oracle full day seminar

2010/10/20 Daily tasks

1. Go to HM for meeting
2. Check TaoBao integration details

2010/10/19 Daily tasks

AL

2010/10/18 Daily tasks

1. Check F5 issue again. The previous restart of services finally cannot solve the problem .. Tar log to F5 support again
2. Setup testing domain for FE team to test new payment gateway

2010/10/15 Daily tasks

1. Connect two copier for warehouse
2. Go to SSP to check the label scanning problem
3. Go to buy the drawing board for fashion designer
4. Buy snack for the team ..

Linux tar usage

tar [options]

Operations:
[-]A --catenate --concatenate
[-]c --create
[-]d --diff --compare
[-]r --append
[-]t --list
[-]u --update
[-]x --extract --get
--delete

Common Options:
-C, --directory DIR
-f, --file F
-j, --bzip2
-p, --preserve-permissions
-v, --verbose
-z, --gzip

--recursion
recurse into directories


Example

To tar and zip the whole directory

tar -xcv filename.tar.gz /target/directory

To extract the tar file

tar -zxv filename.tar.gz -C /target/directory

Linux Netstat usage

功能说明：Netstat用于显示与IP、TCP、UDP和ICMP协议相关的统计数据，一般用于检验本机各端口的网络连接情况。
语　　法：netstat [-acCeFghilMnNoprstuvVwx][-A<网络类型>][--ip]
补充说明：利用netstat指令可让你得知整个Linux系统的网络情况。
参　　数：
-a或–all 显示所有连线中的Socket。
-A<网络类型>或–<网络类型> 列出该网络类型连线中的相关地址。
-c或–continuous 持续列出网络状态。
-C或–cache 显示路由器配置的快取信息。
-e或–extend 显示网络其他相关信息。
-F或–fib 显示FIB。
-g或–groups 显示多重广播功能群组组员名单。
-h或–help 在线帮助。
-i或–interfaces 显示网络界面信息表单。
-l或–listening 显示监控中的服务器的Socket。
-M或–masquerade 显示伪装的网络连线。
-n或–numeric 直接使用IP地址，而不通过域名服务器。
-N或–netlink或–symbolic 显示网络硬件外围设备的符号连接名称。
-o或–timers 显示计时器。
-p或–programs 显示正在使用Socket的程序识别码和程序名称。
-r或–route 显示Routing Table。
-s或–statistice 显示网络工作信息统计表。
-t或–tcp 显示TCP传输协议的连线状况。
-u或–udp 显示UDP传输协议的连线状况。
-v或–verbose 显示指令执行过程。
-V或–version 显示版本信息。
-w或–raw 显示RAW传输协议的连线状况。
-x或–unix 此参数的效果和指定”-A unix”参数相同。
–ip或–inet 此参数的效果和指定”-A inet”参数相同

2010/10/14 Daily tasks

1. Test Image server tomcat setting to see if they are related to the F5 active connection number
2. Fix F5 problem. One of the data class has no content which cause sync failure.

To fix save&hang problem,

bigstart restart httpd
bigstart restart tomcat4

After that everything looks ok
Next step is to lookinto the active connection issues.
3. Personal update meeting
4. Fix Evita flash issue
5. Send out form to Erina for software purchase and CN office purchase

2010/10/13 Daily tasks

1. Troubleshooting HMB email issue
2. Chase F5 for case update
3. IT ASM
4. Email Erina for license purchase approval

2010/10/11 Daily tasks

1. Update F5 for some server pool updates
2. Talk to F5 support for the non-responsive time of F5 when update setting
3. Replace PC for MKT Stephen
4. General support ( alex -> sick leave )

2010/10/08 Daily tasks

1. Handle WT&T invoice
2. Tidy up maintenance area ( 220S )
3. Talk to Warehouse team for printer arrangement
4. Setup PC for MKT team Stephen

2010/10/07 Daily tasks

1. Replace PC for Kayla, Sue, Helen, Angel, Mika, Kenny, Kay.

2010/10/06 Daily tasks

1. Troubleshooting image server slowness, disable tomcat log to improve performance
2. Replace PC for andrew

2010/10/05 Daily tasks

1. Trouble shooting proftpd slowness issue.
2. Give up and setup NFS for replacement. Wait for catalog team to change code
3. F5's sudden high active connection issues still exist ..
4. Handle DELL and Kenfil invoice
5. Replace PC for Andrew
6. IT amm
7. Translate YA newsletter for S3 storage
8. Replace PC for Mio

2010/10/04 Daily tasks

1. Switch image server for YS from Window to Linux
2. F5 rebooted again when adding new node
3. Active connection dropped after reboot. ( Corresponding to 06 Sep issues )
4. Move 2 server to data center
5. YS Blog DB connection error.. only happen to our office ip .. find that it is persist cookie issue, add irule to force connection back to primary server.

2010/09/30 Daily tasks

1. Replace PC for Jacvin
2. Calculate the number number of office license to buy
3. Ask Kenfil for Adobe license status
4. Split phone line for AC team to add one more extension
5. Redirect mbk.com.cn and mbk.cn domain back to mbk.com
6. Replace PC for Evita
7. Replace PC for Aman
8. Calculate MBK SEP charges
9. Replace PC for Jenny

2010/09/29 Daily tasks

1. Replace PC for Tiffany, Dian, Tong

2010/09/28 Daily tasks

1. Replace PC for Serena
2. Receive two new pc for fashion designer
3. Bargaining for Office license cost
4. HM onsite meeting in afternoon
5. Swap 3 LCD, ( Photograph team x 2 and AC team x 1 ) for new Fashion designer team
6. Replace PC for Grace

2010/09/27 Daily tasks

1. Replace PC for Jody
2. Replace PC for Connie
3. Record for NWT invoice
4. Meeting with Global Call Sale ( China Unicom )
5. Unpack 30 PCs ..

2010/09/24 Daily tasks

1. Go to DC to install QNAP NAS for backup testing
2. Move files for Stefan 's new PC
3. Check Webmetrics loading speed improvement reason
4. Prepare phone system comparison

2010/09/22 Daily tasks

1. Copy some folders for Cheryl 's new pc
2. Arrange YS image sync and set next weekend to take action
3. Recover lost video for Jasmine ... However, we don't see any thing on cards.
4. Place order for Adobe and Dell PCs
5. Inform AC for payment of the above order
6. Replace PC for last CS staff

2010/09/21 Daily tasks

1. Help to fix Oracle RAC problem
2. Relocate a Printer for AC team
3. Prepare a PC for Cheryl to replace
4. Test 3G network access
5. Akamai Invoice
6. Ask KH to check Adobe license
7. Check Adobe license for CN office
8. Check PC configuration for CN invoice software.
9. Replace PC for Cheryl
10. Talk to WT&T sale for July 2011 PCCW cable rental issue
11. Ask quotation from HGC for IDAP line

2010/09/20 Daily tasks

1. YA AMM
2. Discussion on License issues
3. HM Meeting

2010/09/17 Daily tasks

1. Meeting with service one sale
2. Meeting to discuss DB backup solution
3. Preparation meeting for HM
4. Checking licensing issue
5. Update HM slide

2010/09/12 Daily tasks

1. Start to replace 50 new PCs for staff.
2. Prepare HM presentation
3. Mr T's PC is done

2010/09/07-10 Daily tasks

07 => SL
08 - 10 => AL

2010/09/06 Daily tasks

1. Complete migration of image server from window to linux.
- Arrange catalog team to update their ftp target
- Arrange FE team to update their content upload tools
- Update F5 irules to handle tomcat's necessary URI modification.
- Update hosts file to point all traffic to image server domain directly for testing
2. F5 suddenly failover itselfs . Active connection is double after migration to linux image server. Checking the reason.
3. Meeting with Phone sale for call center solution.

2010/09/03 Daily tasks

1. ysstlist domain forward. Remove registrar URL forwarding and use F5 to verify the domain for forwarding.
2. Teach Jasmine to use the new Sony DV. And test some function with her .
3. Review warehouse New PC arrangement with Anthony.
4. Check FTP server storage issue. Advice a TW suppliers not to upload all their catalog and design team will try to ask them for specific product image instead of all
5. reschedule catalog down time to Sunday .

2010/09/02 Daily tasks

1. Place order for Dell and fill all necessary forms.
2. Explain DB and system infrastructure to Stephen , with further growth expectation and limitation.
3. Work on company presentation to HM ..
4. Fix YSlist web forwarding by F5 , check tomorrow and wait for DNS update to be effective.

2010/09/01 Daily tasks

1. Check for US warehouse inventory data and ask for photo.
2. Check order for 50 X PCs with Dell and get quotation from others
3. Process Dell Order for 50 x PC as we can get a good deal

2010/08/31 Daily tasks

1. Check HGC for 10Mbps BB and IDAP cost ( HGC => NO IDAP )
2. Continue to research HM website background
3. Modify Flash light power circuit for Barry
4. Upload YA newsletter images to S3
5. Calculate MBK Aug production expense
6. Meet with PacNet sale

2010/08/30 Daily tasks

1. Try to find out the equation to calculate when to add more bandwidth for datacenter
2. General support for users ( MR T, Ms P, Serena, Jasmine )
3. Order for new PC and CS5 for new designer
4. Accept new HM project assignment. Start to prepare company introduction powerpoint and information.
5. Collect HM background information.( their website is down ) ..

2010/08/27 Daily tasks

1. conclude two little things discussion with 8 points
2. clean up DV machine and give nettop to Lydia
3. Upload blu-ray newsletter images
4. Work with CN office to try to trouble-shoot their phone system problem.
5. Prepare Dell OptiPlex 330 Ghost recovery CD for US office

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 }

}

Robocopy command

From window 2003 resource kit, you can find a execute file called robocopy.exe which is able to do more than copy/xcopy ...

To copy only changed files by comparing time stamp ..

=> robocopy /E /SEC /NP /NFL /xo /purge source_path dest_path

F5 show stats command

bigstart list => list all running service
bigstart restart|shutdown |kill SERVICE_NAME => to kill or restart services

F5 show stats command

bigtop

F5 forces standby command

bigpipe failover standby

or

bigpipe fo standby

Type "bigpipe fo help" for help