Technical Article

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)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (1)

You rated this post out of 5. Change rating