Report to show computers with duplicate GUIDS
Updated: 21 May 2010 | 5 comments
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.
discussion Filed Under:
Comments
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.
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.
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.
Thanks this is exactly what
Thanks this is exactly what I'm looking for
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.
Would you like to reply?
Login or Register to post your comment.