/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comment

Comments

  • Perhaps try LAST_SYNC
Please log in to comment

Answer this question or Comment on this question for clarity

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