Advanced Retail (UK) Ltd
Company Wiki

Run to see how much data there is pending on server

select count(*) from data_distribution_queue_terminal 

Run to get terminal ID for each till. (terminal_type 4 are store tills)

SELECT * FROM terminal where terminal_type = 4

Run with terminal ID to see how much data is pending on each till

select count(*) from data_distribution_queue_terminal where terminal_id = ''

To see what tills the store have active use Server branch list
Any till listed here is actively receiving data powered on or off.

SELECT * FROM server_branchlist