Thinixlogo

Find Duplicate Agents

SQL query to 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.

Class
Developer
  • Name: Matt Stanzel
  • Company: Thinix
  • Website: https://www.thinix.com
  • Contact Developer
  • Summary
  • Find Duplicate Agents
  • 231 Downloads
  • Initially Released July 11th, 2016
  • Discussion
    Gravatar for Norberto
    Norberto over 2 years ago

    How can you import this to the VSA? Can't figure it out.

    Gravatar for Duane Godwin
    Duane Godwin over 2 years ago

    You need to run it directly on your SQL server. Only possible if you're on-prem.

    Gravatar for Jarrod Delong
    Jarrod Delong about 2 years ago

    Doesn't seem to work... dbo.vAuditMachineSummary doesn't exist in the ksubscribers db.

    Gravatar for Brent Jones
    Brent Jones 3 months ago

    Any way to create something like this for hosted VSA customers who don't have direct access to SQL db?

    Gravatar for Brad Howell
    Brad Howell 3 months ago

    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.