Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Report to show computers with duplicate GUIDS

Updated: 21 May 2010 | 5 comments
cathossie's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

Does anyone know of report that can show computers that have duplicate GUIDS, I can find a report for duplicate computer names and serial numbers.

Comments

EdT's picture
22
Sep
2009
0 Votes 0
Login to vote

Do you mean UUID?

Are you referring to the UUID property of the Win32_ComputerSystemProduct WMI call?

If your issue has been solved, please use the "Mark as Solution" link on the most relevant thread.

rpoag's picture
22
Sep
2009
0 Votes 0
Login to vote

This query is for a

This query is for a collection in NS 6.  If you want a report you can use that as a starting point and select the fields you are looking for.

SELECT  
 rkc.ResourceGuid as [Guid],  
 COUNT(DISTINCT LEFT(rkc.KeyValue, charindex('.',rkc.KeyValue)-1)) AS [Count]  
FROM ResourceKeyChanged rkc 
JOIN vComputerResource vcr ON vcr.Guid = rkc.ResourceGuid            
JOIN Inv_AeX_AC_Identification aci ON aci.[_ResourceGuid] = vcr.Guid 
 AND (lower(aci.[System Type]) = 'win32' OR lower(aci.[System Type]) = 'win64') 
WHERE rkc.ChangeTime > getdate() - 7  
 AND rkc.KeyName = 'name.domain'  
 AND rkc.KeyValue LIKE '%.%' 
GROUP BY rkc.ResourceGuid   
HAVING COUNT(DISTINCT LEFT(rkc.KeyValue, charindex('.',rkc.KeyValue)-1)) > 2

Ryan Poag
Campbell & Company, Inc.
If your question has been resolved, please be sure to "Mark as Solution"! Thank you.

KSchroeder's picture
22
Sep
2009
0 Votes 0
Login to vote

Duplicate Guid Diagnostics pack

I suggest reviewing AKB3848 for more information. This has an attached "folder" of collections/reports/tasks that can be used to remediate the issue.

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

cathossie's picture
22
Sep
2009
0 Votes 0
Login to vote

Thanks this is exactly what

Thanks this is exactly what I'm looking for

KSchroeder's picture
23
Sep
2009
0 Votes 0
Login to vote

Great, glad I could help.  We

Great, glad I could help.  We have used this in the past after one of our sites deployed a Ghost image to about 100 new laptops, and didn't remove the Guid from the registry beforehand.

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.