K1000 Create Smart Label for machines hosting a replication share
Hi
I'd like to create a report that runs and checks AMP connection for all my site servers, emailing me if any are off. To do this I need to create a (smart) label including all the machines to which stuff is being replicated. Is there a registry setting or reliable file I can look for?
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
dugullett
12 years ago
Posted by:
jverbosk
12 years ago
Try this for the smart label SQL query - it will list all the machines hosting replication shares.
John
________________________
SELECT *
FROM MACHINE
JOIN REPLICATION_SHARE ON (REPLICATION_SHARE.MACHINE_ID = MACHINE.ID)
Comments:
-
I just tried your code and man it works awesome, thanks. - josefino 10 years ago