It seems I have duplicated computer records in SCCM. One says client = yes, the other client = no. Is it possible to generate a report on these duplicated records ?

Try this: select Name0,count(*) cnt from v_R_System group by Name0 having count(*) > 1 John Marcum | http://myitforum.com/cs2/blogs/jmarcum |

Hi, By default in ConfigMgr, there is no Report for Duplicate guid, but you can create it. For more info : http://blogs.catapultsystems.com/javery/archive/2009/06/26/duplicate-pcs-or-guids-in-my-sccm-configmgr.aspxPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.