SCCM : Event ID 1130 Startup Script failed

Today troubleshooting SCCM GPO client push issue. Manually execute the batch script from local machine working fine, but it not working from GPO. 

First, check RSoP to ensure the GPO is deployed to the machine. ✅

Second, check Event Log and found error below: 

Event Log ID       : 1130

Source                  : GroupPolicy

Error                     : Startup script failed

Error Description : Access is denied

The root cause for this is access denied from the client machine to the Installer shared folder. 

After granted permission Authenticated Users - Read & execute to the folder, it work again ! ✅

Excel : Convert ISO 8601 formatted timestamp into datetime

I was getting data from Web page API into Excel. The datetime retrieve was in format ISO 8601 with
Complete date plus hours, minutes and seconds with optional "Z":

         YYYY-MM-DDThh:mm:ssTZD (eg 2020-03-16T10:06:05Z)

Where:

YYYY = four-digit year

MM   = two-digit month (01=January, etc.)

DD   = two-digit day of month (01 through 31)

hh   = two digits of hour (00 through 23) (am/pm NOT allowed)

mm   = two digits of minute (00 through 59)

ss   = two digits of second (00 through 59)

Z    = special UTC designator ("Z") (optional)

Tried to format the datetime type but that might required split column and time zone convert.

Finally after did some testing and below is the outcome of excel formula that worked for me.

Excel Format to convert ISO DateTime to Local GMT +8

=DATEVALUE(MID(C2,1,10))+TIMEVALUE(MID(C2,12,8))+(8/24)

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 !

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

Caution

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 :)

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 m.outlook.com
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 !