Find Duplicate Agents
Product Name: Find Duplicate Agents
Description : 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.
Instructions :
Copy the query text and merely run from the New Query window in SQL Management Studio. Possible that this can be used from within a report part as well, though that is untested.
Comments
-
How can you import this to the VSA? Can't figure it out.
0 -
You need to run it directly on your SQL server. Only possible if you're on-prem.
0 -
Doesn't seem to work... dbo.vAuditMachineSummary doesn't exist in the ksubscribers db.
0 -
Any way to create something like this for hosted VSA customers who don't have direct access to SQL db?
0 -
Sadly I have had to come up with my own process...very manual.
Export everything in Manage Agents
Delete all columns except computer name
Do a Find for all computer names with "-1" at the end and clean up duplicates
Do a conditional format on column for duplicates and research those.
1 -
Odd that there is no way to automatically identify duplicate assets like ScalePad does. After name change, the same asset will consume two licenses. A little frustrating that a different product is required to identify duplicates which must be manually located and merged. Would be great if there was a similar prompt in VSA to notify and offer to merge offline accounts with newer ones.
0
