When using replication with the K1000 it is important to assign computers to only 1 replication label at a time.  If a machine belongs to more than 1 replication label the replication share used will most likely be the one you did not want.

The SQL below and be copy/pasted into a K1000 SQL report or into your favorite reporting tool like MySQL workbench.

/* MACHINES BELONGING TO MORE THAN 1 REPLICATION LABEL */
SELECT MACHINE.NAME AS MACHINE, COUNT(*) AS REPLICATION_COUNT,
GROUP_CONCAT((M2.NAME)) AS REPLICATION_SHARES_LINKED
FROM MACHINE
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
LEFT JOIN MACHINE M2 ON
M2.ID = RS.MACHINE_ID
group by MACHINE.KUID
HAVING COUNT(*) >1