How to create an emailalert in K1000 for specific clients that come online
Hi, I want to get an emailalert, when a specific client comes up.
I tried systemname = <Systemname>
AND uptime > 1
but it showed online clients and offline clients as well.
What attributes should i use?
1 Comment
[ + ] Show comment
-
Perhaps try LAST_SYNC - Jbr32 10 years ago
Answers (1)
Please log in to answer
Posted by:
dugullett
10 years ago
That data is in KBSYS.SMMP_CONNECTION.CLIENT_CONNECTED.
SELECT M.NAME FROM KBSYS.SMMP_CONNECTION S LEFT JOIN MACHINE M ON M.KUID = S.KUID WHERE CLIENT_CONNECTED = '1' AND M.NAME = '<SYSTEMNAME>'
