We have a problem with our SCCM environment; yesterday the SMS_EXECUTIVE service had stopped responding. Once restarted all of the collection were emptied of all system resources! After the a re-sysnc with the AD, all objects have now returned however SCCM states that the clients are missing and none are approved. Can anyone offer any advice as into why SCCM would have deleted all objects or how I can re-populate the database with the correct information. Thanks

The clients should come back after they do a heart beat. I have never heard of this. I did have a problem with SQL one time that made it appear the collections were empty. A restart of SQL and then of the Primary ConfigMgr site brought all the systems back in.http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

Thanks for the update, we restarted SQL and now at least all the clients know which site they are attached to. Problem now is our site is set to auto approve clients, yet under approval they all are set to N/A. Is it best to manual approve or will SCCM approval these over time?

Hi,They will be approved in time. Like said before it can all take a while.Follow me through my blog and Twitter!