- Selected the range of cells I needed to replace.
- Go to Home > Find & Select > Replace or Ctrl + H
- Find what:
,
- Replace with: CTRL + SHIFT + J
- Click
Replace All
- Hooray here i got my result as below.
Ben's System Center Experience
Microsoft System Center deployment experience sharing.
Saturday, 19 August 2017
Excel : Replace comma to line break
Sunday, 27 September 2015
SCSM 2012 R2 UR7 - Gotcha!
OMG ! This seem to be a shoes stopper for us to go for Production. In the meantime, another testing environment was built to re-produced the issue.
First: We have try to running console with the /clearcache parameter from analyst's machine but no luck :'(
"D:\Program Files\Microsoft System Center 2012 R2\Service Manager\Microsoft.EnterpriseManagement.ServiceManager.UI.Console.exe" /cache
Reference: How and When to Clear the Cache
Second: We try to clean the registry from analyst's machine but no luck :(
HKEY_CURRENT_USER\Software\Microsoft\System Center\2010\Service Manager\Console
![]() |
Incorrectly editing the registry can severely damage your system. Before making changes to the registry, you should back up any valued data on the computer. |
Third: We try again to clear Health service from Management Server but no luck :'(
- Stops the System Center Management service.
- Deletes the health service store files.
- Resets the state of the agent, including all rules, monitors, outgoing data, and cached management packs.
- Starts the System Center Management service.
Fourth: We delete user profiles from windows, Hooray ! It's working :)
BUT WAIT ! Customer will not allow us to delete windows user's profile which they might lost existing configuration and files.
There should have cache in windows user's profiles for SCSM Console and luckily found a folder for SCSM under %LOCALAPPDATA% as below.

Delete the file in the folder and it's working great! Finally SCSM Console are reflect the changes of user role. Try this in few machines and confirm the workaround.
Workaround: Delete *.bin and *.hash files from folder “C:\Users\<user name>\AppData\Local\Microsoft\System Center Service Manager 2010”
YES, it's a bug in UR7 and we have reported this to Microsoft Support. After a day we got confirmation from MS for this bug.
For those of you who were waiting for feedback to Update Rollup 7; please take note of this bug.
Will update when MS release the hotfix.
Hope this is help :)
Wednesday, 26 February 2014
Samsung: Security Update Required

Recently my samsung S3 keep prompt this error message “Update security settings to use” and after click on OK still failed to retrieve email. It was struggled me about 2 weeks and I really need to fix this. Luckily my boss didn’t notice yet why I’m slow in reply email lately. After tried few methods and seem not working.
- Manually set the server setting on the mobile device to m.outlook.com
- Add PIN to lock screen
- Delete account and reboot
- …etc
Go into Settings, Security, Device Administrators and remove the existing one for Email. Re-configure the exchange mailbox and it work !
Monday, 24 June 2013
SCCM: Reports under “Software - Companies and Products” & “Software - Files” categories are blank
Do you notice that reports mention in title are show blank in SCCM 2012 ? Here I would like to share with you the finding.
In SCCM 2012, Report under ‘Software – Companies and Products’ & ‘Software – Files’ categories are to collect inventory by file types/extension from client machine. There is no file types configured by default. In order to retrieve the inventory for the reports above, please follow the steps below :
1. Open the Configuration Manager Console, Select Administration, Client Settings.
2. Select on Software Inventory and click on Set Types button.
3. Click on the star button highlight in RED.
4. Enter file type : *.exe
5. Now take a coffee break and waiting for inventory collection.
Here are the sample reports after inventory completed.
Share it out !
Friday, 11 January 2013
Error installing SCCM 2012 SP1 Client – MicrosoftPolicyPlatformSetup.msi
Receiving error from log file on Agent Push for SCCM 2012 SP1.
Couldn’t verify ‘C:\Windows\ccmsetup\MicrosoftPolicyPlatformSetup.msi’ authenticode signature. Return code 0x800b0101
InstallFromManifest failed 0x80004005
CcmSetup failed with error code 0x80004005
Install KB 2756872 Patch Fixed for me on Windows Server 2012.
Update 14/1/2013 : Microsoft Article - Installation error 0x800b0101: System Center 2012 Configuration Manager Service Pack 1 client
Friday, 28 September 2012
Backup and restore the Local GPO
LOCALGPO, A handy tool to apply security setting to non-domain joined computers or Local GPO in your organization.
- You may download Security Compliance Manager (SCM) from Microsoft.
- Extract "Security_Compliance_Manager_Setup.exe" to a new folder A via 7zip or WinRAR.
- Extract the "data.cab" to a new folder B.
- In the new folder B, add the .msi extension to file named "LocalGPO"
- Install the new MSI Installer "LocalGPO.msi"
- Launch command-line here.cmd from C:\Program Files\LocalGPO on 32-bit systems or C:\Program Files (x86)\LocalGPO on 64-bit systems

Export Policy
cscript LocalGPO.wsf /Path:C:\GPObackups /Export
- Exports a GPO Backup based on the Local Policy configuration to a folder in the specified path.

-New GPO GUID folder was created

Import Policy
cscript LocalGPO.wsf /Path:C:\GPObackups\{GPO Backup GUID}
- Applies the contents of the GPO Backup stored in the specified path to the Local Policy of a Windows computer.

Create GPOPack to deploy via Microsoft Deployment Toolkit (MDT) or Microsoft System Center Configuration Manager (SCCM)
cscript LocalGPO.wsf /Path:C:\GPObackups /Export /GPOPack
- Creates a GPOPack and stores it in the specified path. GPOPacks can be copied to other computers, and applied by double-clicking GPOPack.wsf.

Copy the folder and double click GPOPack.wsf from other machine to apply the same policy.

You may notice that you get a pop-up message when you run this command.

This can be suppressed by adding the “/silent” switch
Script to deploy via MDT and SCCM
GPOPack.wsf /silent

Restore Policy to default
cscript LocalGPO.wsf /Restore
- Restores the entire Local Policy to its default configuration.

It’s FREE!
You can get your hand on the LocalGPO tool right now as part of the Microsoft Security Compliance Manager
Update 18/10/2012
Download LocalGPO.msi
Wednesday, 29 August 2012
Windows 8 : Country Holiday Calendar
Looking on my calendar today, 3 Sept is Labor day …. something wrong with my calendar.
Found the article : Add holiday or other calendars to your calendar
1. Go to Malaysia (English) ( For Malaysian )
2. To add the calendar, click Subscribe to this calendar.
3. Got Malaysia Holiday in my calendar now. You can add more country’s calendar into your Microsoft account as you like.
Holiday calendars
Argentina
Australia
Austria (German)
Belgium (Dutch)
Belgium (French)
Bulgaria
Brazil
Canada (English)
Canada (French)
Chile
China
Croatia
Czech Republic
Denmark
Estonia
Finland
France
Germany
Greece
Hong Kong SAR
Hungary
India (English)
India (Gujurati)
India (Hindi)
India (Kannada)
India (Malayalam)
India (Marathi)
India (Tamil)
India (Telugu)
Indonesia (English)
Indonesia (Indonesian)
Italy
Ireland
Japan
Korea
Latvia
Lithuania
Malaysia (English)
Malaysia (Malay)
Mexico
Netherlands (Dutch)
New Zealand
Norway
Philippines
Poland
Portugal
Romania
Russia
Serbian (Cyrillic)
Serbian (Latin)
Singapore
Slovakia
Slovenia
South Africa
Spain (Catalan)
Spain (Spanish)
Sweden
Switzerland (French)
Switzerland (German)
Thailand
Turkey
Ukraine
United Kingdom
United States (English)
United States (Spanish)
Vietnam