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

Comments

  • Perhaps try LAST_SYNC
Please log in to comment

Answers

4

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>'
Answered 06/12/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share