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.

SQL: Delete Duplicate Audit Application Records Per Agent

Gonzalo Carrillo
Gonzalo Carrillo Miami, FLMember, Kaseya Certified, Kaseyan, Automation Exchange Administrator

MODERATOR

edited January 24 in Solutions

Product Name: SQL: Delete Duplicate Audit Application Records Per Agent

Description : This query will delete any duplicate application records that are gathered by Latest Application Audits. This will help keep this table from growing unnecessarily large.

Instructions :

1. Load File into SQL

2. Click Execute Now

Tagged:

Comments

  • Matt Stanzel
    Matt Stanzel Member CHOCOLATE MILK
    edited July 2016
    I would definitely like to see more of these non-destructive cleanup queries on here. This one itself took us from 103,969,511 records (tallied by running only the SELECT portion) down to 3,735,384 records.