how do you find out computers with duplicated values?
I would like to generate a report for all computers that share the same below registry value:
for those who don't know, this ID should be unique per computer, and if its not, reporting to WSUS will be wrong as WSUS identify computers using this ID.
after some troubleshooting I found out that a lot of computers are sharing same ID because they were deployed using the same image, and now I have to keep track of those with same ID and deploy a script to fix it.
How am I doing it right now?
I created a scan profile that looks for the above key, and did a scan for some computers, then I generate a report that have 2 columns, computername and the above registry value, I filter by the registry key name, then I take the report to excel and find those with duplicate IDs.
later I even clean them up manually or deploy a script that will delete the ID from registry and restart the windows update service in order to renew it.
am trying to find a way to generate a report that only contains those with duplicated IDs, check attached to see my current report.