March 20, 2011
HomeConfiguration ManagerMerging obsolete records in Configuration Manager 2007

Merging obsolete records in Configuration Manager 2007

By  Configuration Manager  37 Comments

When reinstalling a computer which is already present in Configuration Manager 2007 it sometime obsolete the existing client record specially when reinstalling it using PXE boot. When I wanted to use Direct Membership only in a project instead of using AD-groups for instance for targeting this became a major issue.

I then found this excellent script which merge conflicting records in SCCM it can be found here: http://kristianfthomsen.spaces.live.com/blog/cns!59A30145A64F8A9F!156.entry?wa=wsignin1.0

As the site has been down the script can be downloaded here: https://ccmexec.com/wp-content/uploads/2011/04/merge.vbs.txt

The blog post tells to schedule it as a schedule task, but I love status filter rules, it is amazing what you can do with them, so I created a status filter rule which will trigger the script as soon as a duplicate record is created.
The status filter rule looks like this: MergeRecords

The only negative with this solution is that the advertisement history for the client is kept after a reinstallation which can be a bit confusing sometimes.

If you want to implement the script as a status filter rule, these are the steps:

  1. Download the script and place it in a folder on the Primary Site server in this example: “E:\sccmtools”
  2. Change the site settings to “Manually resolve conflicting records” under the Advanced tab in site properties in the SCCM Console.
    MergeRecords2
  3. Create a new status filter rule with the following properties as displayed earlier:
    Component : SMS_DISCOVERY_DATA_MANAGER
    Message ID: 2642
  4. And on the next page select that it should “Run a Program” :  “cscript.exe E:\SCCMtools\merge.vbs”
    MergeRecords3

Then you will not have any obsolete records in your SCCM site anymore.

Related Posts

About Author

Jörgen Nilsson

37 Comments
  1. Wayne Robinson

    Fantastic post, cant wait to give this a try 🙂

    Reply
  2. Genesis

    Can you please provide the merge script. The site that was hosting is no longer available.

    Reply
  3. Jörgen Nilsson

    Hi,
    I will update the post with the script

    /Jörgen

    Reply
  4. Stuart

    Beautiful 😉

    Reply
  5. Scott

    Can you clarify what is meant by “The only negative with this solution is that the advertisement history for the client is kept after a reinstallation which can be a bit confusing sometimes.” Does this mean that the imaged computer would not receive advertisments for software that was installed BEFORE it was imaged?

    Reply
  6. Jörgen Nilsson

    HI,
    The client will run all advertisements again no problem, but if you look in the advertisement history you will have all the history left from before you reinstalled the computer. For instance if you run an advertisement for Office 2007 and after reininstallation you install Office 2010 you will have the advertisement status history for Office 2007 still in the reports and database.

    /Jörgen

    Reply
  7. Scott

    Thanks for clarifying. Knowing this, I can see this script really solves a problem with ConfigMgr 2007 when it comes to imaging known computers. I have seen alot of duplicate/obsolete accounts which prevents advertisement to the new client until the obsolete account is deleted. You can delete the odsolete accounts daily with ConfigMgr but this actually PREVENTS this from occuring (even better) so advertisement happen almost immediately (R3). Nice job and thanks for sharing.

    Reply
  8. Scott

    Hopefully this issue imaging known computers is resolved in ConfigMgr 2012. Anyone know?

    Reply
  9. binarymime

    Are these settings supposed to be configured on the secondary site servers as well? Or just the primary?

    Thanks

    Reply
  10. Jörgen Nilsson

    it is only needed in the primary sites.

    /jörgen

    Reply
  11. jonny

    Hello. This seems nice. But I do have too edit the .vbs with correct settings for my site?

    Reply
  12. Jörgen Nilsson

    Hi,
    No modifications the vbscript is needed, there is no site specific information in there.
    /Jörgen

    Reply
  13. Kathy

    I have set this script up per the instructions and it does not seem to be working. I have duplicate machine listings. The machines have different versions of the client. Does this make any difference. I hope to get this to work as this is exactly what I need.

    Reply
  14. Jörgen Nilsson

    Hi,
    Kathy, are you sure the objects in your environment are obsoleted? otherwise they will not be merged..

    /jörgen

    Reply
  15. Kathy

    Yes they are obsolete. We are getting ready to deploy Windows 7 and applications and the once Windows 7 creates a new client then the one that is in the application collection is obsolete and the package will not deploy. There is no message id 2642 as is suggested in the status filter I think that may be my problem. If it does not generate that ID then it will not run the script, correct?

    Reply
  16. Jörgen Nilsson

    Hi,
    Again Kathy, that is correct the script is triggered by the status message, do you have any records in the “Conflicting Records” node in the SCCM console?
    /Jörgen

    Reply
  17. Kathy

    Yes I did this morning and the other packages that I tried to deploy showed no status since yesterday.

    Reply
  18. binarymime

    It’s not working for me either. I have had the script in play for about a month now and the conflicting records are showing up, they are just not automatically resolving themselves via the script. I am having to manually Merge them. Any insight. One thing i am a bit confused on…how long does it take for an obsolete record to actually be marked obsolete?

    Reply
  19. binarymime

    Further update to this. I checked in event viewer and filtered 2642 event ids for the SMS_DISCOVERY_DATA_MANAGER component and found nothing…any idea as to why these would not be generated?

    Reply
  20. Kathy

    I can manually run the script and it works just not through the status filter rule.

    Reply
  21. John Rolstead

    You must set Site properties\Advanced\”Manually resolve conflicting records” to get the event ID 2642 for the SMS_DISCOVERY_DATA_MANAGER component.

    Reply
  22. Peter

    Hi, this looks really promising, but my problem records are technically not Obsolete, they have a blank in that column and no SMSID at all, they dont even have the same site code, but they do have the same hostnames and obvious causes me grief for the same reasons as an Obsoletely marked record would.

    Will the script merge my records even if the Obsolete column is blank for the problem records?

    Thanks

    Reply
  23. andy

    Hi,

    Same deal with me, I can manually run the script and it works just not through the status filter rule.
    I can see the 2642 event in status filter under SMS_DISCOVERY_DATA_MANAGER. Do I need to restart a service?

    Reply
  24. andy

    Issue fixed, by using the full path: C:\Windows\SysWOW64\cscript.exe D:\SCCM\Scripts\merge.vbs

    Reply
  25. binarymime

    I am still not able to find any 2642 events although i am getting conflicting records…im so confused, i have changed the pathing according to andy and hopefully that will fix it

    Reply
  27. binarymime

    Okay i see the event id 2642 and i have setup the status filter rule…however the script is not running, i am using the path:

    C:\Windows\SysWOW64\cscript.exe E:\Source\Scripts\merge.vbs

    Any additional suggestions?

    Reply
  28. Herwin

    Hi

    I setup the filtered rule as explained, and it is working like a charm!!

    running SCCM 2007 R3 and scriptpath is C:\Windows\SysWOW64\cscript.exe E:\Source\Scripts\merge.vbs

    Thanks!,

    Reply
  29. eric

    Hello,

    i have clients in some dynamic collections (AD) and also in static collections. Is the client after the merge in all related collections?

    Regards Eric

    Reply
    • Jörgen Nilsson

      Hi,
      Yes the client will still be member of exactly the same collections as the old SCCM object is kept.
      /Jörgen

      Reply
  30. mbroome

    Dim swbemLocator
    Dim swbemServices
    Main()
    Sub Main()
    Dim oProviderLocation
    Dim oLocation
    Dim oReg
    Dim oPendingRegs
    Set swbemLocator = CreateObject(“WbemScripting.SWbemLocator”)
    swbemLocator.Security_.AuthenticationLevel = 6 ‘Packet Privacy.
    Set swbemServices = swbemLocator.ConnectServer(“.”, “root\SMS”)
    Set oProviderLocation = swbemServices.InstancesOf(“SMS_ProviderLocation”)
    For Each oLocation In oProviderLocation
    If oLocation.ProviderForLocalSite = True Then
    Set swbemServices = swbemLocator.ConnectServer(oLocation.Machine, “root\sms\site_” + oLocation.SiteCode)
    End If
    Next
    Set oPendingRegs = swbemServices.ExecQuery(“SELECT * FROM SMS_PendingRegistrationRecord”)
    For Each oReg In oPendingRegs
    Resolve 1, oReg.SMSID
    Next
    End Sub
    Sub Resolve(action, SMSID)
    Dim InParams
    Set InParams = swbemServices.Get(“SMS_PendingRegistrationRecord”).Methods_(“ResolvePendingRegistrationRecord”).InParameters.SpawnInstance_
    InParams.Action = action
    InParams.SMSID = SMSID
    swbemServices.ExecMethod “SMS_PendingRegistrationRecord”,”ResolvePendingRegistrationRecord”, InParams
    End Sub

    Reply
  31. MC

    Jörgen

    Could the script not be amended to clear the advertisment history to prevent the shortcoming you mention?

    Reply
  32. Joe

    Jorgen this is very nice something I wish I wouldve found 2 years ago, anyways do you know if this is used in the same fashion on 2012 we are in the process of migrating and Im not yet very familiar with the way 2012 handles this.

    Reply
  33. cary

    Hello Jorgen, question for you regarding this process. We have 2 07 primaries; 1 is parent (for reporting) and the other is child (where all operations occur). I am assuming this would need to be setup on the parent but curious if it needs to be on both or just one. Please let me know when you have a chance. Thanks….

    Reply
  34. Peatrick

    work in SCCM 2012? I have the same problem.

    Reply

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.