Client Activity and Client Duplicate IDs error

Author Message
dcslick

  • Total Posts : 32
  • Scores: 0
  • Reward points : 4590
  • Joined: 6/11/2009
  • Status: offline
Client Activity and Client Duplicate IDs error Tuesday, February 16, 2010 6:35 PM (permalink)
0
Hello,

I am trying to upgrade SCCM 2007 to SP2.  When the prerequisites check runs it tells me I have errors with Client Activity and Client Duplicate IDs.

Client Activity
Inactive clients cannot be managed by Configuration Manager. Inactive client records should be removed from the site database before continuing the upgrade process.


Client Duplicate IDs
Duplicate client IDs can cause unexpected results in collection evaluation and software distribution to clients. Duplicate client IDs should be resolved before continuing the upgrade process.

Any suggestions on how to fix?

Thanks!
 
#1
    dcslick

    • Total Posts : 32
    • Scores: 0
    • Reward points : 4590
    • Joined: 6/11/2009
    • Status: offline
    RE: Client Activity and Client Duplicate IDs error Tuesday, February 16, 2010 8:15 PM (permalink)
    0
    I found the duplicate IDs using a report.  Now that I have found the IDs how do I remove them?

    Thanks
     
    #2
      dcslick

      • Total Posts : 32
      • Scores: 0
      • Reward points : 4590
      • Joined: 6/11/2009
      • Status: offline
      RE: Client Activity and Client Duplicate IDs error Wednesday, February 17, 2010 1:23 PM (permalink)
      0
      Any ideas, I found the problems via a query but I have no idea on how to remove them, I am not a SQL person so any help would be appreciated!


       
      #3
        jjose

        • Total Posts : 244
        • Scores: 33
        • Reward points : 31460
        • Joined: 8/25/2009
        • Location: Bangalore, INDIA
        • Status: offline
        RE: Client Activity and Client Duplicate IDs error Wednesday, February 17, 2010 2:21 PM (permalink)
        0
        create a collection, add those duplicate hostnames to it, perform a delete special...
         
        #4
          kingskawn

          • Total Posts : 378
          • Scores: -2
          • Reward points : 14390
          • Joined: 4/25/2007
          • Status: offline
          Re: RE: Client Activity and Client Duplicate IDs error Thursday, September 02, 2010 5:40 AM (permalink)
          0
          Can you tell us how to find those duplicateID's please?
           
          #5
            cp07451

            • Total Posts : 527
            • Scores: -26
            • Reward points : 48400
            • Joined: 9/17/2009
            • Location: San Antonio,TX
            • Status: offline
            Re: RE: Client Activity and Client Duplicate IDs error Thursday, September 02, 2010 8:31 AM (permalink)
            0
            You can use this document. It's older but still very valid.
            http://www.myitforum.com/articles/1/view.asp?id=1780

            this will allow you to delete the resources or have them generate new guids.

            hope this helps!
             
            #6
              kingskawn

              • Total Posts : 378
              • Scores: -2
              • Reward points : 14390
              • Joined: 4/25/2007
              • Status: offline
              Re: RE: Client Activity and Client Duplicate IDs error Tuesday, September 07, 2010 4:26 AM (permalink)
              0
              Thanks cp07451!

              I also found the used query to perform a search for duplicateIDs

              SELECT GSYS.Domain0, GSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name',  GSYS.SMSID0 AS SMS_Unique_Identifier0 FROM System_DATA GSYS JOIN System_HIST GHSYS ON GSYS.MachineID = GHSYS.MachineID JOIN System_SMS_Instal_ARR site ON GSYS.MachineID=site.ItemKey WHERE GSYS.Name0!=GHSYS.Name0 UNION SELECT RSYS.Resource_Domain_OR_Workgr0 as Domain0, RSYS.Name0, site.SMS_Installed_Sites0, GSYS.Domain0 AS 'Previous Domain', GSYS.Name0 AS 'Previous Name', RSYS.SMS_Unique_Identifier0 FROM System_DISC RSYS JOIN System_DATA GSYS ON RSYS.ItemKey = GSYS.MachineID JOIN System_SMS_Instal_ARR site ON RSYS.ItemKey=site.ItemKey WHERE RSYS.Name0!=GSYS.Name0  UNION SELECT RSYS.Resource_Domain_OR_Workgr0 as Domain0, RSYS.Name0, site.SMS_Installed_Sites0, GHSYS.Domain0 AS 'Previous Domain', GHSYS.Name0 AS 'Previous Name', RSYS.SMS_Unique_Identifier0 FROM System_DISC RSYS JOIN System_HIST GHSYS ON RSYS.ItemKey = GHSYS.MachineID JOIN System_SMS_Instal_ARR site ON RSYS.ItemKey=site.ItemKey WHERE RSYS.Name0!=GHSYS.Name0

              I hope it will be useful for someone
               
              #7
                Online Bookmarks Sharing: Share/Bookmark

                Jump to:

                Current active users

                There are 0 members and 1 guests.

                Icon Legend and Permission

                • New Messages
                • No New Messages
                • Hot Topic w/ New Messages
                • Hot Topic w/o New Messages
                • Locked w/ New Messages
                • Locked w/o New Messages
                • Read Message
                • Post New Thread
                • Reply to message
                • Post New Poll
                • Submit Vote
                • Post reward post
                • Delete my own posts
                • Delete my own threads
                • Rate post

                2000-2012 ASPPlayground.NET Forum Version 3.9