Happy Independence Day from all of us at the Connect IT Community! Our US offices will be closed on Monday, July 4th, 2022 in recognition of the holiday. Limited Support staff in the US will be on-call and available for critical Service(s) Down issues only. Normal Support operations in the US will resume on Tuesday, July 5th, 2022.

Find Duplicate Agents

Matt Stanzel
Matt Stanzel Member CHOCOLATE MILK
edited January 24 in Solutions

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.

Tagged:

Comments

  • Norberto
    Norberto Member CHOCOLATE MILK
    edited September 2018

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

  • Duane Godwin
    Duane Godwin Member
    edited September 2018

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

  • Jarrod Delong
    Jarrod Delong Member CHOCOLATE MILK
    edited April 2019

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

  • Brent Jones
    Brent Jones Member CHOCOLATE MILK
    edited January 2021

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

  • Brad Howell
    Brad Howell Member CHOCOLATE MILK
    edited January 2021

    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.

  • Martin Green
    Martin Green Member CHOCOLATE MILK

    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.

Weekly Leaderboard