SCCM 1810 Hotfix KB4490434 – Duplicate User Discovery Columns Fix

While working on SCCM 1810, I noticed a new hotfix KB4490434 appeared in the console. You might probably want to know what this hotfix contains before you install it. This hotfix addresses the issue where duplicate user discovery columns created after installing SCCM 1810. More information about this hotfix is documented here.

As per Microsoft, after current branch is updated to version 1810, multiple duplicate columns may be created in the user discovery data table (User_DISC). If there are duplicate columns created, the features that rely on Active Directory User Discovery data may return incorrect results. For example, collection or query results or user-targeted software deployments.

Needless to say the KB4490434 is applicable only to SCCM 1810. Furthermore this issue is seen when additional attributes are collected by user discovery method. In my lab setup, I haven’t seen the duplicate user discovery columns issue yet. But at least to prevent this issue from occurring, I decided to install this update.

One question that comes up is should I install the KB4490434 hotfix ?. – It is not mandatory to install this hotfix. You may skip this update if you don’t see the issue (the one described above) in your setup. Now that you know what this hotfix contains, let’s check if this issue exists in your setup. You may want to connect to the SCCM database and look over User_DISC table to find any duplicate columns. Or probably run the below script to verify if this issue exists.

Hotfix KB4490434 Check

Before installing KB4490434, Microsoft advises you to run this script. This is a SCCM duplicate user discovery columns detection script. Running this query against your SCCM DB will tell you if the issue exists in your setup. If it returns any records, then go ahead and install the SCCM 1810 hotfix KB4490434. In my setup, the query returned no records.
Duplicate user discovery columns detection script

SCCM 1810 Hotfix KB4490434

The SCCM 1810 hotfix KB4490434 should be available in Updates and Servicing node. To install Configuration Manager 1810 hotfix KB4490434 :-

  • Launch SCCM console.
  • Go to Administration > Overview > Updates and Servicing.
  • Right click Configuration Manager 1810 Hotfix KB4490434 and click Install Update Pack.

Since I am installing ConfigMgr 1810 hotfix in my lab setup, I am going to select ignore any prerequisite check warnings. Click Next.

Note that the update includes only Configuration manager site server updates. Hence you won’t see the Console Upgrade window during end of update installation. The client agent version will remain same.

KB4490434 hotfix

Complete the next steps and on Completion page, click Close.

SCCM 1810 hotfix

Go to Monitoring node and click Updates and Servicing Status. Right click Configuration Manager 1810 hotfix (KB4490434) and click Show Status. Wait for all the steps to show completed. Close the console and re-open it.

SCCM 1810 Hotfix KB4490434

The hotfix KB4490434 installation is successful. Prior to installing this hotfix, if the above query had returned any records, you may want to run the query again and check if no records are returned.

SCCM 1810 Hotfix KB4490434

You might also like

2
Leave a Reply

avatar
2 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
rai80
Guest
rai80

@charan Same here, already waiting a few hours now. Still on SMS_Executive not started..
Were you able to fix this?

charan
Guest
charan

After installing this hotfix it got stuck at post installation
I have noticed that content not downloaded to easy setuppayload

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More