Checking the size of the logs (prior to 7.1)

List and order table starting from the highest count of log types.

Checking the size of the logs (after 7.1)

List and order table starting from the highest count of log types.

Check for single KB installs

Checking for presence of one KB across all devices.

SQL Script - Device Details

Manufacturer, Model, Serial Number, OS details

SQL Script - Check for duplicate devices

Comparing devices names to find duplicates

SQL Script - Client logs for GUI start and GUI end

Log time, Log Type, Device name, MACaddress, IP address

Check all table sizes in database

TSQL: Remove duplicates

v. 7.0 +