The numbers of workstations which have the Blueprint tracker installed do not match the number of workstations seen by the Blueprint Analyst

The number of workstations which have the Blueprint Tracker installed do not match the number of workstations seen by the Blueprint Analyst

This could be that when they deployed the tracker packages out to the workstations they could had the same MachineGuid i.e having a clone of the registry setting when deploying.

The query below shows the approximate number of duplicate MachineGuids per machine record:

select convert(int, round(1.0*LastUpdate / (1 + datediff(d, InstallDate, LastHeartbeat)), 0)) as NumMachines, * from Machines order by NumMachines desc

As you can you see from the first column which reflects the number workstations which have the duplicate MachineGuids.

The attached script(RefreshMachineGuid.zip) will clear out the MachineGuid on a Tracker and cause it to request a new MachineGuid from the server. This could be run as a login script.