Duplicate software IDs in SCCM

I have installed SCCM Server 2007 with SP2. Currently the problem is that when i run the resource explorer and software inventory from Add/Remove Componenets, There are duplicate entries with same installed software. I have attached the screenshot of SQL Server 2005 Installed but  it has 2 entries.

Similarly, other Different softwares like adobe, MS Visual Source Safe, MS Visual Studio etc have multiple entries.

How can i remove the duplicate records?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I also was suprised about those entries. I assume the duplicate IDs are caused from x64 system. There's information in HKLM\Software\Windows\CurrentVersion\Uninstall and in HKLM\Software\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall

Deleting these entries is not possible you could just customize your hardware inventory (SMS_DEF.MOF - see code below) to not capture x64. But in my opinion this makes no sense.

[ SMS_Report (FALSE),
SMS_Group_Name ("Add Remove Programs (64)"),
Namespace ("\\\\\\\\localhost\\\\root\\\\cimv2"),
SMS_Context_1 ("__ProviderArchitecture=64|uint32"),
SMS_Context_2 ("__RequiredArchitecture=true|boolean") ]

class Win32Reg_AddRemovePrograms64 : SMS_Class_Template
[SMS_Report (TRUE), key ]
string ProdID;
[SMS_Report (TRUE) ]
string DisplayName;
[SMS_Report (TRUE) ]
string InstallDate;
[SMS_Report (TRUE) ]
string Publisher;
[SMS_Report (TRUE) ]
string Version;
Netsol-NOSAuthor Commented:
Can i come to know whether this is a SCCM 2007 problem or there is configuration issue in my server. If this is configuration issue then how can i solve this problem.
There is also same problem in earlier version of SMS i.e. System Management Server 2003. And we can not resolve this problem in 2003 version.

This is neither a configuration issue nor a problem. This is by design and should be correct

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Netsol-NOSAuthor Commented:
How can i correct this design issue.
To correct this issue you should not use x64 bit machines, but as i said this is no solution.
You have to live with this ;)
Netsol-NOSAuthor Commented:
There is no exact solution. This is a design issue commented by expert and should correct.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.