A lot of customers use standard PC's to set up replication shares in remote offices. The biggest thing to keep in mind in those cases is the limitation of connections that are imposed by the operating system. Windows XP Pro is limited to 10 concurrent connections while Windows 7 is limited to 20. In dealing with these limitations it's important to identify the total # of machines you have assigned to a particular replication share.
The SQL code below can be copied and pasted into a new SQL report on the K1000 or into your favorite reporting tool like MySQL workbench.
/* ACTIVE REPLICATION SHARES WITH COMPUTER COUNT*/
SELECT M2.NAME AS REPLICATION_MACHINE,
Case when FAILOVER_TO_KBOX = 1
THEN 'Failover is ENABLED'
else ''
end as "KBOX Failover",
COUNT(*) AS "PC'S Assigned to Share"
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 M2.name
Comments