SCCM MECM MCM Configuration Manager Taking a Long Time to Update Collections

 When Configuration Manager takes a long time to update device collections, there are several possible causes to evaluate.

First, go to Monitoring - Collection Evaluation Queue and review Full Evaluation Queue and Manual Evaluation Queue

Any evaluation exceeding 2 minutes is suspect. If it is a handful of collections, carefully evaluation the collection selection criteria.

If there a numerous collections exceeding 2 minutes (in our case we found numerous exceeding 20 minutes), evaluation of the SQL database performance tuning is recommended as Configuration Manager may run better when the site database is configured at a different SQL Server CE compatibility level. 

Refer to the following Microsoft Article:

https://learn.microsoft.com/en-us/troubleshoot/mem/configmgr/alerts-reports-queries/sql-query-times-out-or-console-slow-performance

Configuration Manager installs utilizing SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, and SQL Server 2022 experiencing slower than normal collection evaluations can be improved when the site database is configured at a SQL Server CE compatibility level of 110.

Compatibility level can be set by running the following SQL Query:

ALTER DATABASE <ConfigurationManager_DataBase Name>

SET COMPATIBILITY_LEVEL = 110;

GO


Uninstall Google Chrome Extensions/Apps From Command Line

 Google Sheets

"C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=fhihpiojkbmbpdjeoajapmgkhlnakfjf


Google Drive

"C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=aghbiahbpaijignceidepookljebhfak


 Google Docs

"C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=mpnpojknpmmopombnjdcgaaiekajbnjb


Gmail

"C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=fmgjjmmmlfnkbppncabfkddbjimcfncm


Youtube

"C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=agimnkijcaahngcdmfeangaknmldooml


 Google Slides

"C:\Program Files\Google\Chrome\Application\chrome.exe" --profile-directory=Default --uninstall-app-id=kefjledonklijopmnomlcbpllchaibag

Silent Uninstall Azure Data Studio

 C:\Program Files\Azure Data Studio\unins000.exe /SILENT

Silent Uninstall Attribute Changer

 C:\Program Files\Attribute Changer\unins000.exe /SILENT

Windows 11 Machines With MECM / SCCM Client Installed Do Not Have Check for Online for Updates from Microsoft Update Drop down From Windows Update

 Windows 11 Machines With MECM / SCCM Client Installed Do Not Have Check for Online for Updates from Microsoft Update Drop down From Windows Update


Two registry keys set by MECM client causes this issue (which does NOT cause this issue with Windows 10). Deleting these two registry values returns this functionality:


 reg delete "HKLM\SOFTWARE\WOW6432Node\Policies\Microsoft\Windows\WindowsUpdate" /V UpdateServiceUrlAlternate /F


 reg delete "HKLM\SOFTWARE\WOW6432Node\Policies\Microsoft\Windows\WindowsUpdate" /V DoNotConnectToWindowsUpdateInternetLocations /F







Windows 11: Setting Check for Updates to Check Against Microsoft Online

 If you need a computer to check against Microsoft for latest updates and the option is missing in the Settings menu, the following will enable it.

1-Close Settings menu.

2-Open Registry Editor.

3-Navigate to :


Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate



4-Modify the value of key from 0 to 1

5-Launch Setting and check the updates menu for drop down options for expected 'link' option


(Restart is not needed)


Error Installing Cisco Anyconnect Secure Mobility Client: Must Be Admin to Install

 Click Start and type “regedit” in the box.


A dialogue box will pop up with the following text: Do you want to allow the following program to make changes to this computer?

Click Yes.


Browse to the following location: HKEY_CLASSES_ROOT\Installer\Products\


Within the Products folder, locate and delete the registry key which contains product information for Cisco AnyConnect. (We recommend making a backup of this registry key before deleting it.)


Each registry key within Products is an alphanumeric string. Select the first key and look on the right side for ProductName REG_SZ Cisco Anyconnect Secure Mobility Client. Go through each key in the Products folder until you find the one for Cisco AnyConnect.


For example,

the registry key GUID for Cisco Anyconnect Secure Mobility Client v4.4 is  31D43F43B3678C84490E6DDCF38F2486

the registry key GUID for Cisco Anyconnect Secure Mobility Client v4.5 is  89A926BE96E58E04ABE93C3998F959D9

the registry key GUID for Cisco Anyconnect Secure Mobility Client v4.10.05111 is A5EF3288780FD794198D259C9799A4B0


Each version of Cisco Anyconnect Secure Mobility Client will have a different GUID for this registry key.


Close the registry editor.


Install the latest version Cisco Anyconnect Secure Mobility Client.