Saturday, 19 August 2017

Excel : Replace comma to line break

For some reason, I need to rearrange my excel data in cell from comma to link break as below:
  1. Selected the range of cells I needed to replace.
  2. Go to Home > Find & Select > Replace or Ctrl + H
  3. Find what: ,
  4. Replace with: CTRL + SHIFT + J
  5. Click Replace All
  6. Hooray here i got my result as below.
This helps me on lots !

Sunday, 27 September 2015

SCSM 2012 R2 UR7 - Gotcha!

UPDATE 18/2/2016 : Issue resolved in UR9 released.
Recently we have implemented Microsoft System Center 2012 R2 Service Manager Update Rollup 7 in a project. Everything are working good until we are preparing for go live. Once we are started to configuring Analyst User Role-based, we found that any changes to the existing configured user roles in SCSM won't reflect in Console of analyst's machine.
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.
Reference: System Center 2012 - Service Manager Registry Keys
Third: We try again to clear Health service from Management Server but no luck :'(

  1. Stops the System Center Management service.
  2. Deletes the health service store files.
  3. Resets the state of the agent, including all rules, monitors, outgoing data, and cached management packs.
  4. Starts the System Center Management service.
Reference: How and When to Clear the Cache
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.
  1. Manually set the server setting on the mobile device to
  2. Add PIN to lock screen
  3. Delete account and reboot
  4. …etc
Finally this work for me.
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

In this post, I would like to introduce the method to 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.
  1. You may download Security Compliance Manager (SCM) from Microsoft.
  2. Extract "Security_Compliance_Manager_Setup.exe" to a new folder A via 7zip or WinRAR.
  3. Extract the "" to a new folder B.
  4. In the new folder B, add the .msi extension to file named "LocalGPO"
  5. Install the new MSI Installer "LocalGPO.msi"
  6. 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.clip_image006
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