Will test and let you know
ThaveshinP, do you mean the SQL query?
Yes, that will still work. To me it didn't llok like the DB schema updated. To understand what is stored in the DB and which fields to work with, have a look at the database schema reference manual available from http://www.symantec.com/docs/DOC2411.
Have a look here too: http://www.symantec.com/docs/TECH102544.
WIll this work on Ru6 mp3?
We also run RU5 and that does not seem to fix the problems for us. we get hte same results as netsaran.
Netsaran, AFAIK there is no easy way to find duplicates from the SEP console. Either search for a computer name that you suspect is duplicated or increase your display filter to show 500+ clients on a page, sort by name and manually scroll down.
Alternatively, use Excel 2007 or above to do a data connection to your SEPM database and pull out the info from the SEM_COMPUTER view, then use conditional formatting to highlight duplicate values.
If your SQL is any good or you have access to a DBA, maybe you can do it directly in the DB.
This will extract all computer names for you, but you still need to manually find trhe duplicates.
SELECT [COMPUTER_NAME] ,[COMPUTER_DOMAIN_NAME] ,[CURRENT_LOGIN_USER] ,[MAC_ADDR1] ,[IP_ADDR1_TEXT] ,[COMPUTER_ID] ,[DOMAIN_ID] ,[HARDWARE_KEY] ,[COMPUTER_DESCRIPTION] FROM [V_SEM_COMPUTER] ORDER BY [COMPUTER_NAME],[CURRENT_LOGIN_USER]
Best I can do for you.
I tried it shows below message
<?xml version="1.0" encoding="UTF-8" ?>
good information
Just checked these question as was on leave and away... Is this issue going to impact any clients that do not sync with AD?
Yes this issue migh occur with clients that do not sync with AD Is it possible to get duplicate client logs.... Yes this does affect client logs and reporting Thanks :-)