Ask a questionAsk a question
 

AnswerComputer Association Not working!!!!!!!!!!!!..................

  • Wednesday, October 28, 2009 4:00 PMLee Martin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I have been using SCCM for ages now working happily away.

    Yesterday I installed SP2 and began work on Windows 7 Deployment.

    I am 99% sure i imported a computer into my test collection earlier.

    Once that machine joined to the domain it no longer PXE booted so I normally delete it out re-import it again and all carries on......



    however now when I import it, I put in the MAC address give it a name next next. all says it finishes and no errors, yet the collection never shows the machine.

    have tried a couple reboots stopped and started ccmexec service to no avail.






    im stumped :S ................................


    any ideas please???

    Thanks

Answers

  • Wednesday, October 28, 2009 4:48 PMLee Martin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Fixed it.

    For anyone that adds SP2 to there SCCM. 2 MORE resource IDs were added:

    in the table:

    select SMS_R_UNKNOWNSYSTEM.ResourceID,SMS_R_UNKNOWNSYSTEM.ResourceType,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name from SMS_R_UnknownSystem where Decommissioned = "0"


    i had to change the value back to '0'


    NOW I HAVE 6 instances in unknown computers. whey to go microsoft!
    • Marked As Answer byLee Martin Wednesday, October 28, 2009 4:48 PM
    •  

All Replies

  • Wednesday, October 28, 2009 4:48 PMLee Martin Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Fixed it.

    For anyone that adds SP2 to there SCCM. 2 MORE resource IDs were added:

    in the table:

    select SMS_R_UNKNOWNSYSTEM.ResourceID,SMS_R_UNKNOWNSYSTEM.ResourceType,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name from SMS_R_UnknownSystem where Decommissioned = "0"


    i had to change the value back to '0'


    NOW I HAVE 6 instances in unknown computers. whey to go microsoft!
    • Marked As Answer byLee Martin Wednesday, October 28, 2009 4:48 PM
    •  
  • Thursday, October 29, 2009 2:44 AMWallyMSFT, OwnerUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    And just so everyone else understands, what Lee did is absolutely not supported by Microsoft. You are never to manually edit the site database without CSS directing you through the process.

    Glad it worked for you however.
    Wally Mead