Last successful transmission by subscribers

,

this script will give you a list of the last successful transmition for all your suscribers.

SELECT subscriber_name, Max([Time]) as LastTx
	FROM distribution..MSmerge_history mh
		INNER JOIN distribution..MSmerge_agents ma
			ON mh.agent_id = ma.[id] 
	WHERE runstatus = 2
	GROUP BY subscriber_name

Rate

5 (1)

Share

Share

Rate

5 (1)