Recently we had cloned new machines to our system but they are still reporting to Log Analytics with the SourceComputerId property from the source machine (which new ones was cloned from). How to fix it?
We tried to reinstall the agents but it didn't help. This query still returns duplicates.
let duplicates = Heartbeat
| summarize dcount(Computer) by SourceComputerId
| where dcount_Computer > 1
| project SourceComputerId;
Heartbeat
| where SourceComputerId in (duplicates)
| distinct Computer, SourceComputerId
| order by Computer asc
This isn't a big deal for montiroing but we cannot setup update schedule from OMS (Azure Automation) because the new machines are unavailable - Update Solution relies on SourceComputerId (ref link: https://learn.microsoft.com/pl-pl/azure/automation/automation-update-management)