6 7 2016 10 27 24 am

SQL: Delete Duplicate Audit Application Records Per Agent

Delete Dupl. Audit Application Records

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.

Class
Developer
  • Name: Gonzalo Carrillo, Kaseya Support
  • Company: Kaseya
  • Website: http://www.kaseya.com
  • Contact Developer
  • Summary
  • SQL: Delete Duplicate Audit Application Records Per Agent
  • 70 Downloads
  • Released on June 6th, 2016
  • Reviews
    Gravatar for Matt Stanzel
    by Matt Stanzel on July 8th, 2016

    This one itself took us from 103,969,511 records (tallied by running only the SELECT portion) down to 3,735,384 records.

    Discussion
    Gravatar for Matt Stanzel
    Matt Stanzel about 3 years ago

    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.