SQL query to find duplicate agents
Detailed report showing duplicate machines by MAC address. This will help to find offline machines that can be safely removed. For example, if a machine is reimaged and the Kaseya agent is reinstalled, you may now have two agents in the VSA for the same machine (one of which is permanently offline). You can add additional fields to the SELECT statement to expand this if necessary, or JOIN with other tables to create a more detailed result set.
Perfect... found several "messes" to clean up!
How can you import this to the VSA? Can't figure it out.
You need to run it directly on your SQL server. Only possible if you're on-prem.
Doesn't seem to work... dbo.vAuditMachineSummary doesn't exist in the ksubscribers db.