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
Miami, FLMember, Kaseya Certified, Kaseyan, Automation Exchange Administrator
MODERATOR
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:
0
Comments
-
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.0
Categories
Join The Community