Listing clients for removal
Used SQL to list all relevant fields for clients to decide which will be removed
SELECT o.id, o.ident, o.`name`, eds.`value` AS `subdomain`, ede.`value` AS `email_domain`, ea.contact_email, ea.seats, o.state AS `entity_state`, ea.`status` AS `account_status`, ea.`status_updated_on` AS `account_status_last_update`, FROM_UNIXTIME(o.tstamp) AS `creation_time`, (
SELECT COUNT(*)
FROM entity u
WHERE u.parent_id = o.id
) AS `users`, (
SELECT COUNT(*)
FROM entity ua
WHERE ua.parent_id = o.id AND ua.state = 'A'
) AS `active_users`, (
SELECT MAX(dul.login_date)
FROM dashboard_user_login dul
INNER JOIN entity edul ON dul.entity_id = edul.id
WHERE edul.parent_id = o.id
) AS `last_login`, (
SELECT FROM_UNIXTIME(MAX(rg.`timestamp`))
FROM recent_grid rg
INNER JOIN entity m ON rg.entity_id = m.id
WHERE m.parent_id = o.id
) AS `last_grid_access`
FROM entity o
LEFT JOIN entity_data eds ON o.id = eds.entity_id AND eds.entity_field_id = 1
LEFT JOIN entity_data ede ON o.id = ede.entity_id AND ede.entity_field_id = 37
LEFT JOIN entity_account ea ON o.id = ea.entity_id
WHERE o.entity_type_id = 1
INTO OUTFILE '/tmp/clients.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';