SCCM : The software could not be found on any servers at this time.

Deploying OSD today and forgot something very important !!! 

Error Message: 

The software could not be found on any servers at this time.

Resolution : 

Please ensure the content has been distributed to Distribution Point.

Make sure you won't make the same mistake like me :'(

SCCM : Failed to get DP locations as the expected version from MP Error 0x87d00215

While deploying SCCM agent, this may one of the error that throw from Clients CCMSetup log.

Error Message: 

Failed to get DP locations as the expected version from MP 'http://SCCMPrimarySite'. Error 0x87d00215

MP 'http://SCCMPrimarySite' didn't return DP locations for client package with the expected version. Retrying in 30 minutes.

Resolution : Confirmed the mentioned MP server is added into the Boundary Group belong to the client.

Something simple but better keep a notes here rather than wasting time to troubleshooting same issue again in future.

Cireson Portal: Custom Form and Troubleshooting

Cireson Portal did provided a good portal interface for System Center Service Manager (SCSM). Of course customer always requested to add new custom fields into work item form like Incident, Service Request and Change Request.

I've done this couple of times but my brain is getting older and forgetful. Alright let write it down here for future quick reference.

This is the expected result : 

In order to display Type Of Change on Change Request form, new line 22 is added into ChangeRequest.js

The actual line of script here:

{ DataType: "Enum", PropertyDisplayName: "Type of Change", PropertyName: "TypeofChange", EnumId: 'aebf24d4-a7ac-3180-e5b3-cd34c86f03b2', Required: true }

The key here are PropertyName and EnumID. 

By using PowerShell command Get-SCSMEnumeration, EnumID can be search by Name.

Get-SCSMEnumeration -name TypeofChange | select Displayname, name, id

Troubleshooting:

Issue 1: Task Tower 1 field is display value Test in SCSM Console, but portal show blank.

{ DataType: "Enum", PropertyDisplayName: "Tower", PropertyName: "Enum.Change.TaskTower1",EnumId: '90f2bc75-7681-9b57-33ef-d9aa5d2e2db8', Required: true}

Remember! Name that return from Get-SCSMEnumeration is not PropertyName. 

We need to find out the PropertyName from Management Pack.

   

After updated the correct PropertyName

{ DataType: "Enum", PropertyDisplayName: "Tower", PropertyName: "TaskTower1",EnumId: '90f2bc75-7681-9b57-33ef-d9aa5d2e2db8', Required: true}

The correct value is shown on portal now.

Issue 2: After confirmed the PropertyName and EnumID, portal still not display the dropdown list item.

Don't forget to Recycle Application Pool.

If you need more detail on other form field, below are pages you should visit:

    Cireson Portal - How to create custom form

    Detail Steps to custom configuration item form

Thank you and please comment if you have any question

How to get SQL Server Product key from ISO

When installing SQL Server 2019 Reporting Service or 2017 and later, you will be ask to enter product key.

According to Microsoft article, product key can be retrieve from SQL Server 2019 installer.

Actually there is another way to get it.

When we run setup.exe from the media, the Product Key is picked from DefaultSetup.ini file located under Root\X86 or Root\x64 folder. This file is also used to make slipstream media (refer KB)

The file would look like below

Comment if you know other way to do this too.

Connect-AzureAD : The term 'Connect-AzureAD' is not recognized

Working on Windows 10 2004 to execute powershell script and found that AzureAD module is not installed yet. 

Error Message: 

Connect-AzureAD : The term 'Connect-AzureAD' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Executed command Install-Module AzureAD to install the module from Administrator powershell windows, another error prompt as below:

Error Message:

Install-Module : The 'Install-Module' command was found in the module 'PowerShellGet', but the module could not be loaded. For more information, run 'Import-Module PowerShellGet'. 

Perform check on Powershell Execution Policy and currently on Restricted state. 

Execute Set-ExecutionPolicy Unrestricted to unblock it and it's work !

Finally, I was able to connect AzureAD to continue the work.

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 ! ✅