When managing remote environments with the K1000 replication plays a large role in driving down bandwidth requirements and throughput of tasks for the clients. Because of this emphasis users normally need to identify which machines in their environment do not belong to a replication share. The SQL code below can be pasted into a SQL report or your favorite reporting tool like MySQL workbench.
/* COMPUTERS NOT PART OF A REPLICATION SHARE */
SELECT NAME, USER, IP, LAST_SYNC,
CASE WHEN DATEDIFF(NOW(), LAST_SYNC) < 5
THEN 'LAST CHECK IN LAST 5 DAYS'
WHEN DATEDIFF(NOW(), LAST_SYNC) < 10
THEN 'LAST CHECK IN < 10 DAYS'
WHEN DATEDIFF(NOW(), LAST_SYNC) < 20
THEN 'LAST CHECK IN < 20 DAYS'
ELSE 'LAST CHECK IN OVER 20 DAYS'
END AS "TIME SINCE LAST SYNC"
WHERE ID NOT IN
INNER JOIN MACHINE_LABEL_JT MLJ ON
MACHINE.ID = MLJ.MACHINE_ID
INNER JOIN LABEL L ON
L.ID = MLJ.LABEL_ID
INNER JOIN REPLICATION_SHARE RS ON
RS.LABEL_ID = MLJ.LABEL_ID AND
ENABLED = 1)
ORDER BY 4 DESC;