Free Helpdesk Software

Today I’m trying one of the free helpdesk software, download off the net called “SysAid”.  Not sure how popular it is, but it seems to be on the market for a while.  I can’t really compare it with the popular ones but for what it does and free of charge (most importantly), it’s really good.

Originally I was looking for free “Knowledge Base” software, this software does a lot more.  It handles helpdesk ticketing system, asset management, remote support (yes, it builds in), system monitor, performance benchmarking and more … well, I’m still trying it, so I can’t really comment on it.  If some used this before or know something better, please drop a few word.  Otherwise, this is handy if you are looking for the same thing.

iPhone Disaster

I recently upgraded my iPhone 3GS to 4.3.3, everything went well.  There are new features, such as wifi/bluetooth Tethering, it is very handy.  However, I found myself in a real disaster 2 days later.  ALL MY CONTACTS ON THE PHONE HAS DISAPPEARED!!!

I spent the entire Saturday morning today, I was searching through the entire Google, I found many people have the same problem, however not many of them have much luck restoring their contacts.  I seems to be a bug in this upgrade and even you have created a backup before upgrade, the restoration won’t help.  Interesting thing is some user like my luck Boss, he upgraded his phone without any issues (I can’t imagine what will happen if he loses his 500 contacts @.@)

Anyway, I managed to find a few solution and I want to share them here.

  • Recover the contact list from backup

As I have mentioned, even I restored from backup, the contacts are still missing, so am I confusing you!?  Actually this method need a bit of technical skill, but I got all my contacts back from this method, so it is highly trusted.  If you don’t have much confidence, get someone to give you a hand.  Also another requirement is Cydia App, which means you need to JailBreak your phone.  (It is totally up to you, JB your phone or lost all contacts)

1- Download and install iPhoneBackupExtractor software in trial mode
2- Connect your iphone to your computer and start  iPhoneBackupExtractor.exe
3- Browse and select the appropriate backup. Some backups may not contain any contacts (Possibly the recent one). Check the amount of contacts under Available Data / Contacts (You can see the exact number highlighted with blue.)
4- Click “Expert Mode”
5- Go to Library / AddressBook
6- Mark the checkbox of AddressBook.sqlitedb
7- Click “Extract selected” (Trial version of iPhoneBackupExtractor allows only to extract 2 files at the same time. So this does not bother us because we only need to extract a single file.)
8- In your iPhone go to Cydia and search for OpenSSH
9- Install OpenSSH to your iPhone
10- On your computer download WinScp from
11 – In WinScp choose new

HostName= iPhone IP address (To find out, on your iPhone go to settings-wifi and tap the blue arrow next to your connection)
password=alpine (this is the default password)

12 – After login go to private/var/mobile/Library/AddressBook
13- Drag and drop the file “AddressBook.sqlitedb” which you have extracted from backup, to the folder “AddressBook” (replace the existing file)
14- Right click to “AddressBook.sqlitedb” and click “Properties”
15- Change the owner to “mobile”  (some people on Internet says change the owner to “root”, however it doesn’t work in my case, change to “mobile” work for me)
16- Restart your iPhone.

  • Open up the SQLiteDB

If you do have problem copying the SQLiteDB file back onto your phone, I also found another way to read your contact data, however this should be the last option as this method will still need you to either enter the contact back onto your phone, or if you are smarter, you can run some SQL query from this software, export it to another format and then import it back to your phone.

You download this software, drag and drop the “AddressBook.sqlitedb” from the above steps, you will find all the phone number in ABMultiValue table under Browse Data tab.

Good luck restoring your contacts.

ESX host grey out ~

Since last night, one of the ESX host in the cluster has became “not responding”, although all the VMs on it are still running, I just don’t know what will happen next.

From home, I logged in through Putty, and tried a few methods that found on Internet, still doesn’t resolve the problem.

This morning had a look at the console screen, it says some CPU Journal I/O error, not sure what it is yet, but looks like I will need to reboot the physical server to try fix it.


“Ping” Command doesn’t work

Quite often that some of the command doesn’t work in the command prompt, showing some errors like

‘ping’ is not recognized as an internal or external command
‘defrag’ is not recognized as an internal or external command
‘ipconfig’ is not recognized as an internal or external command

but every time I forget about the fix, so let me put it here this time.

For Windows XP:

Right click “My Computer” and click “Properties”. Click the “Advanced” tab up top followed by the “Environment Variables” button at the bottom. In the 2nd list box, scroll down to the 5th or 6th entry “Path”, select it and click “Edit”. Add “%SystemRoot%system32;%SystemRoot%;” (minus the quotes) to the beginning of the line. Okay the changes and try out your commands now.

Cannot open outlook attachment

Today a user reported that she can’t open up an attachment in one of the email, then I went to try a few different things – one typical approach  “REBOOT COMPUTER”.  No!  not this time, it’s still can’t open.  The user is actually saying this is not the first time, the previous times were able to fix by close and open up Outlook, but this time don’t work.

Went on Google search, I found the problem very interesting.  It’s saying about permission problem with the “Temporary Internet Files” folder, and it’s suggesting to do a registry hack.  But this folder is not on network, it’s on local C drive, and this user is in a local administrators group.  Anyway, it doesn’t work!  So before I want to do this hacking, let me go to clean up the “Temporary Internet Files” folder under Internet Options.  Again, it still doesn’t work.

Then I followed the instruction from M$ Support, rebooted the computer, problem solved.

As you would imagine that local administrators group has full permission, how can it lose its permission to this folder?  To me, it’s a mystery~~

Recover single mailbox/file/folder from Exchange 2007

I have been backing up Exchange store many years, but to be honest, I have never ever used it to restore any mailbox or data.  The time finally comes, one of the director has a missing folder in his Exchange mailbox, we looked everywhere but still can’t find it, thus I have no other option but to do a recovery.

Surprisingly, it is not too difficult with the new Exchange console.  I found this article from Petri by Daniel Petri, he did a brilliant job of demonstrating steps.  I want to share with everyone.  By using this method, not only can restore the mailbox, it can also restore specific folder or even specific file or subject line, it’s a very useful and powerful tool.

Just 2 little things I would like to add, you need to make sure that the user mailbox has enough storage to merge/copy the backup, temporary increase it if necessary, and also make sure that you follow the exact steps, don’t skip steps because you are too smart 😛