/build/static/layout/Breadcrumb_cap_w.png

Replication: Reporting a count of machines assigned to a replication share

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

This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ