Hi there, Although the title of my issue may seem weird, i'll try to explain my self. I'm dealing right now with 90 hosts (all of them are with windows xp sp3), and the sccm client is appearing as client NO. I did a collection that specify all this agents, and after i had all the client "NO" i needed, i right click the collection andd choose install client, including checkingthe box on "repair or upgrade client agents". After almost an hour, i'm updating my sccm console with right click, and choosing "Update collection membership", and i can see that some hosts are now appears twice, first of all with client NO and line beeneth it i see same hostname with client YES. How can i solve this issue without typing each hostname and check if it appears twice after i reinstalled all the collction with agents? btw, i thought that maybe the report will help to to see the clients, but when i choose the eport i want (All advertisments for a specific collection), i see that there are no details. Hope to hear from you soon with soe ideas how to remove those double agents from my sccm console. Best regards, Nahum Israel

Check if the machines which are showing twice ,one might be Obsolete. Create a collection for computers which are obsolete and delete all those by right cliking on collection and use delete special. select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System where Obsolete = 1 //Eswar Koneti @ http://eskonr.wordpress.com/

Check if the machines which are showing twice ,one might be Obsolete. Create a collection for computers which are obsolete and delete all those by right cliking on collection and use delete special. select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System where Obsolete = 1 You can also create report to see how many are duplicate computers : select name0 'Computer Name', count (*) 'Installs' from v_r_system GROUP BY name0 having count (*) > 1 order by count(*) desc //Eswar Koneti @ http://eskonr.wordpress.com/

Hi kent, Thanx for the quick reply... Here's my problem...were talking about 60 pc's that to most of them i can connect with remote tools, and i don't see them twice in the sccm all systems collection. To be honest, i don't want to take the risk and delete 60 computers that most of them looks fine, and i can connect to them. Put your self in my situation, what would you do based on the collection i made, and the result i got. Not to mention that i'm a rookie in sccm :) Hope to hear from you soon. Nahum

Here's my problem...were talking about 60 pc's that to most of them i can connect with remote tools, and i don't see them twice in the sccm all systems collection. To be honest, i don't want to take the risk and delete 60 computers that most of them looks fine, and i can connect to them. Is that a problem if you are able to connect remote tools on all those (60) computers ? also you dont see all these computers twice in collection ? //Eswar Koneti @ http://eskonr.wordpress.com/

Hi Eswar, First of all, thank you very much for taking the time to answering my question. I created the collection you told me, and i see in the collection about that only 3 of them, are the computers that i did a collection about. My question is, what is this query, and why should i delete the computers in the collection that i made using your instructions? I see that you use the value "Obselete=1", can you please explain me about this, what does it do, and when should i use it? Hope to hear from you soon Nahum.

Obsolete clients are (most often) client computers that have been reinstalled with a new operating system. This action creates a new record in the ConfigMgr. database and at the same time marks the "old" record as obsolete. Obsolete clients do not work as clients and the records should be deleted.Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

Hi eswar, I don't see all the computers in the collection i made with your help...i see diffrent computer names. That's why i don't want to delete them even when they are based on the collection of "obselete" as you sent me...the consequenses will be good for me...if you know what i mean :) I guess that i don't see the cmputers name that i'm talking about, because the obselete value is diffrent and does not match the collection, do you have any other suggestions?

I think the following query will help you. What it will do? It lists all the NetBiosnames that have more than one entry in the SCCM database. Here it returns only the old records and will keep the new record in the SCCM database. It can be used for removing the duplicate records in the SCCM database that gets created when you push client on unhealthy client. Please create a new collection using this query and limit it to your orginal collection on which you are working. when ever you need to cleanup come to this new collection and do a "Delete Special". ;-) select SYS1.ResourceID,SYS1.ResourceType,SYS1.Name,SYS1.SMSUniqueIdentifier,SYS1.ResourceDomainORWorkgroup,SYS1.Client from SMS_R_System as sys1 inner join SMS_R_System as sys2 on sys2.NetbiosName = sys1.NetbiosName where (sys1.ResourceId < sys2.ResourceId) Regards, Madan | www.madanmohan.com

I think the following query will help you. What it will do? It lists all the NetBiosnames that have more than one entry in the SCCM database. Here it returns only the old records and will keep the new record in the SCCM database. It can be used for removing the duplicate records in the SCCM database that gets created when you push client on unhealthy client. Please create a new collection using this query and limit it to your orginal collection on which you are working. when ever you need to cleanup come to this new collection and do a "Delete Special". ;-) select SYS1.ResourceID,SYS1.ResourceType,SYS1.Name,SYS1.SMSUniqueIdentifier,SYS1.ResourceDomainORWorkgroup,SYS1.Client from SMS_R_System as sys1 inner join SMS_R_System as sys2 on sys2.NetbiosName = sys1.NetbiosName where (sys1.ResourceId < sys2.ResourceId) Regards, Madan | www.madanmohan.com

Can you check for the computers that are appearing twice in SCCM console if they are Active : Yes or NO ,there will be only one client which is Active:Yes and should not be obsolete//Eswar Koneti @ http://eskonr.wordpress.com/

Hi Madan, I'll be in the office on sunday, and i'll do that... btw, what is the meaning of "Delete Special"...what does it do?

Hi Eswar, I'll be in the office on sunday and i'll check it up, althought i'm almost positive in 99% i've seen the a couple of times two hostnames and they appeared with client yes, and client no.

"Dlete Special" is to remove a client record from the SCCM database. If you perform this on a collection, it deletes all the clients in a collection. Here the above query that I provided should list all the duplicate systems, which you may want to remove from the SCCM database. If so, you can right click on the collection and select "Delete Special" to delete all the client records in that collection....Regards, Madan

Hi. How can i conntact you. i want to ask you something (i'm from israel too) thanks kobi hemed kobih@molsa.gov.il

052-3673446 Nahum

Hi maden, I did exactlly as you told me, i choose the specific collection that i have with my 60 computers, and when i used your query on this specific collections with i don't getany result, even after doing refresh, and waiting for several minutes. But, when i remove the specific collection, and use your query on the "All Systems" collection, i see over 150 computers. So, now according to you'r query, i know that the 60 computers do not appear twice in the database of sccm (but somehow when i go to the All Sysytems collections i can see that some of them are duplicated twice.) Now, thanx to you maden, i know tat they are 150 computers that are written twice in my database, it looks like wer'e discovering new things with those queries that you are sending me....i curios what more will i discover in this sccm. -:) anyway, maden this query unfortunatlly does not solve my problem, and other ideas? Best reagards, Nahum Israel