How to use netsh command to set the DNS dynamic update configuration for a specified DHCP server

I always wanted to blog about this. At last, I got the time now (after work).

Have you ever been task to configure the DNS dynamic update configuration on hundreds of DHCP servers? For me, yes. Smile

To avoid possible mistake made. Here, I will share with you on how to use netsh command to do it.

The command is as follow:

netsh dhcp server <dhcp server IP address> scope <scope ip address> set dnsconfig A B C D

Refer to the picture below for better understand on what is “A B C D” stands for.


To have setting as above on a server on scope of, the command will be as follow:

netsh dhcp server scope set dnsconfig 1 1 1 0

If you wish to disable it. The command will be just:

netsh dhcp server scope set dnsconfig 0 0 0 0

Note: there are space between those numbers for DNSCONFIG!

So, if you have all the IP addresses of your DHCP servers and scope IP address (which you should have!), you can just prepare the command using Microsoft excel or merge this with Powershell script; and you can configure all your DHCP server DNS Dynamic update configuration just from a device with connections to all your DHCP servers!

Hope this can buy you more time to spend with your family! Cheers! Smile

Posted in Microsoft DHCP, Microsoft Windows, Singapore Windows User Group (SWUG) | Tagged , | Leave a comment

Plan to Implement IPv6 in your Windows Environment?

My environment is planning to implement IPv6 very soon.

Of course, I went to read up on fundamental of IPv6 first. But those documents are purely on network portion. My environment is mainly Windows Server and Client. How?

Glad that I found something online and I feel that for those who are in similar situation as me, go and read up on the article.

The topic that interest me and gave me a quick overview on DNS and DHCP are:

  • IPv6 Static Addressing, DNSv6
  • Setting up DHCPv6 to Dynamically issue IPv6 Address

Hope this article can provide Windows System Engineer some rough idea what needs to be done when there is a need to move on to IPv6 in the environment.

Have a nice Day.

Posted in IPv6, Microsoft Windows | Tagged , , , | Leave a comment

I am not Missing. I had a Stent Placement but I am Back!

I am back after MIA since Sept 2012. The reason is not because I am busy with work but it is due to health issue. I think it is good for me to share my experience here, hope that anyone who read this will take action to take care of their health.

What happened to me? Well, I had a heart artery blockage of 95%!! Since Oct 2012, I cannot walked more than 400m as I will feel chest tight and hands numb. I thought that it was heart burn but i experience the same discomfort for the next 2 days after walking for a distance. I read online and suspect that I have heart related diseases.

Straight away, I went to see a doctor and arranged a treadmill test where the result is positive – my heart was detected not able to function properly at certain load.

For Singapore, to get medical subsidies, we have to go to polyclinic to get referral letter to see a specialist. Else I cannot imagine how much will my medical bill be.

3 weeks after my first visit to doctor and polyclinic, I get to see the cardio specialist at Tan Tock Seng Hospital. That time, my leg started to feel numb after walking a distance and started to swell. The doctor straight away arrange angiography for me as he suspect that I am having heart artery blockage. He gave me priority else it may take months before I get my turn for the test.

1 week later, I went for my angiography and straight away, the doctor identify that I have a 95% blockage at the front heart artery. I need a stent placement and ballooning immediately. Very interesting part is that I am fully awake and able to see the whole operation from the LCD screen during the operation. The doctor first explain to me my condition and ask if they can proceed with the stent placement operation. He also explain to me the cost of the stent – S$3500 (excluding ballooning and other operation fee). And to my shock is that for that better stent, it is not able to be covered by Medisave!! But lucky enough, I have bought hospitalization and critical illness insurance policies.

Anyway, the whole angiography with stent placement plus 3 ballooning took about 1hr plus. After the operation, I am hospitalized for 1 day to monitor my condition before I was discharged.

The whole incident is not over yet. My right hard where the angiography took place swell and have a huge patch of bruise that last for a week! I was not able to move it and apply strength for about 3 weeks!

But one good thing is by 3 week, I tried to went for a stroll and I can walk for more than 400m without chest tight or hand numb!

So… what is the cause of this blockage? I do not drink, smoke nor have cholesterol problem. What the doctor said is because I lack of exercise!! But of course, another factor is stress where doctors will never acknowledge that but it is somehow contributing to this.

So, for past months, I need to go back to hospital regularly for check up, re-hab where they teach me how to exercise properly and what food to eat. On my own, I am trying my best to change my lifestyle – spend 30mins daily to do some exercise (brisk walk) and avoid working for long hour. And… avoid oily and salty food Sad smile 

Lastly… As per doctor advise, I need to lose 15kg. No choice, as I still have a long way to go. I need to change my lifestyle and maintain it as healthy as possible. Reason is the stent in the artery will increase the chance of blockage if I never take care of my cholesterol and blood pressure.

Oh.. forgot to put down… Guess how much I spent on the operation? Total of S$11,000. I can only use S$2,000 from my Medisave and the rest…. lucky I got my insurance.

Hope for those who read this blog… hope my experience can wake you up a bit on

  • Lifestyle – All work but no exercise? Add in at least 30mins of exercise daily where your heart-rate must be at least 100-120. Photo walking is not really a form of exercise! I go for my brisk walk (1km – 10mins is a rough gauge on how fast you need to walk).
  • Buy Correct Insurance – In Singapore, please get Hospitalization and Critical Illness Insurance. Do not rely on your company insurance. You cant be working throughout your life! Endowment / Investment Insurance does not cover hospitalization nor Critical illness!
  • Regular and Correct Body Check Up – ECG is not reliable. Imagine my condition, ECG cannot detects. You may want to go for Treadmill or Stress Test for more reliable body check up.
  • Eat Healthy – Eat less Oily and Salty Food. See, even I may not have Cholesterol issue, I got the heart artery diseases.

Ok! dinner time.. Good Day!  

Some photos for you all to see.. Smile See if you can see where is the blockage~ The photo is before my stent placement.


The photo below is after the stent placement and ballooning. Can see the difference, right?


Boys and Girls… take good care of your health~ Smile

Posted in Everyday Life | Tagged | 2 Comments

Windows 8 – Windows to Go Workspace on Thumb Drives requires Specific Hardware

Dear all,

Please note on the hardware requirement on USB Thumb Drive when you wish to test out Windows 8 “Windows to Go Workspace” feature. Not all USB 3.0 thumb drive can be used! I bought a scandisk USB3.0 thumb drive happily and wanted to test and I see the following message.. Sad smile


What brand and model of thumb drive can be used?

Please refer to the link below for the specific brand and model of thumb drive before buying to use for testing. Smile


Now, I can only use external hard disk to test out Windows to Go Workspace. It is working fine!

By the way, only Windows 8 Enterprise Edition supports this feature!

Posted in Uncategorized | Tagged , | Leave a comment

Encounter Error Code 0x80010643 when install a Role or Feature in Server Manager under Windows Server 2008 R2

1 month plus ago, when I was trying to DCPromo a Server to be a Domain Controller in my environment and I encountered an error that really freak me out! Fatal Error Code 0x80010643.

Error Message is:

“Attempt to install “Role/Feature Name” failed with error code 0x80010643. Fatal error during installation.”

I was like wow… Something wrong with my DNS? or Some firewall rules that my network engineer has amended wrongly?

But after troubleshooting a while, I decided to perform the standard drill… removing of our friend antivirus software (FOR A WHILE)! And guess what? I can now DCPROMO! COOL~

Of course, after the DCPromo, I re-install the antivirus software and patch it up-to-date! Smile

Then today.. my another team ask me if we have encounter issue when adding Windows Deployment Services (WDS).

I look at the error message and the error code is the same. This time, we search online and found that McAfee had acknowledge that it is a bug and published an article on their knowledge base website as follow:


So, if your environment is having the following combination:

  • McAfee VirusScan Enterprise 8.8 (unpatched)
  • McAfee VirusScan Enterprise 8.7 (with Patch 5)
  • Microsoft Windows 2008 R2

Please following the instruction as stated in the McAfee Knowledgebase. Either you upgrade to VSE 8.8 Patch 2 or… perform workaround as follow:

————– Extracted from the Website —————————-

Use the following steps to temporarily disable the rule triggered during the Windows Role or Feature installation:

  1. Disable Report and Block on Access Protection Rules that protect McAfee processes and directories:
    1. Click Start, Programs, McAfee, VirusScan Console.
    2. Right-click Access Protection, and select Properties.
    3. Select Common Standard Protection.
    4. Deselect Report and Block for Prevent modification of McAfee files and settings.
    5. Deselect Report and Block for Prevent termination of McAfee processes.
    6. Click OK.
    7. Exit the VirusScan Console.
  2. Install the Windows Role or Feature.
  3. Revert back to the previous configuration.
  4. Enable Report and Block on Access Protection Rules that protect McAfee processes and directories

————– Extracted from the Website —————————-

Have Fun folks!…. Now, we need to work on a plan to upgrade VSE~

Posted in Microsoft Windows, Troubleshooting, Uncategorized, Windows Server | Tagged , | Leave a comment

Windows Server 2008 R2 ADDS – Remember to Open Firewall–TCP5722 and…

Was troubleshooting recent issue on AD Replication. What we found out is that we actually need to open up the following port on our firewall appliance.

TCP-UDP 135 and TCP 5722

Note: TCP 5722 is needed for Windows Server 2008 domain controllers.

One may want to take note of TCP-UDP 135. As according to the TechNet website, it only indicate TCP 135. But based on our sniffing of network while troubleshooting, we need to turn on UDP 135 too. Weird. Maybe someone can confirm on this too?

Refer to the website:


Posted in IT Security, Microsoft Active Directory, Windows Server | Tagged , | Leave a comment

Microsoft Excel Formulae to Convert Date from DD/MM/YYYY to YYYYMMM


Just want to record this down on my Blog so that I can use this as again.

I encounter a scenario where I need to group item in such a way for my recent report that is using Microsoft Excel.

1. Group by Item Type

2. Group by Year and Month

3. Sum up the Qty of the Item

The Item type is nothing. The challenge is in the raw data excel sheet, the date is in format of DD/MM/YYYY but I need it to be YYYYMMM.

I tried to play with formulae such as =Year()&Month() and tried with date format… It did not turn out what I want.

With changing date format, I almost got it but when I use the raw data for pivot table, the original date format appears with the “days” and I did not managed to group the item by YYYYMMM format.

Screen shot below shows what I mean:

Using Custom Format to “YYYYMMM”


Yup.. It works. But….


Under Pivot table, It shows the actual date again. NOT what I want!



I know I can always copy and paste the value back but I want something that fast. So, I explore on formulae further.


So.. what Formulae I used in the end in Microsoft Excel?

=TEXT ( CELL, “yyyymmm”)

It WORKS!! Smile

Below screen shot shows the formulae I used to convert my cell containing the date.


With that, even under my pivot table, data is able to be grouped accordingly!


YES! With that, I can do my data analysis faster! Smile

Posted in Everyday Life, Microsoft Office | Tagged | 3 Comments