/bundles/itninjaweb/img/Breadcrumb_cap_w.png

Hiya, we are requiring Kace to notify us if clients go disconnected/offline after a desired time period.This will help us in isolating a possible root cause of port exchuastion issues we are seeing

2 Comments   [ - ] Hide Comments

Comments

  • I believe you could do either one with data in the KBSYS.SMMP_CONNECTION table. This table shows if clients are connected to the KBOX or not. Just to clarify, you want an alert to let you know when a specific computer has gone offline, but only after it has been online for a set period?

    Or, would you like a report showing a list of machines and whether they are still connected after a certain amount of time?
  • you can do this with the report wizard, as all needed stuff is predefined in the wizard
Please log in to comment

Answer this question or Comment on this question for clarity

Answers

0

SQL for Computers that are MIA for 60 Days:

*NOTE* This is included in the preconfigured reports on the K1000.

SELECT MACHINE.ID, MACHINE.NAME AS SYSTEM_NAME, SC.CONNECT_TIME, SC.DISCONNECT_TIME, LAST_SYNC, CLIENT_VERSION, OS_ARCH, OS_NAME, OS_VERSION, MACHINE.IP FROM MACHINE  LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID WHERE ((SC.DISCONNECT_TIME < now() ) AND (concat(SC.CLIENT_CONNECTED) = '0') AND ((TIMESTAMP(SC.DISCONNECT_TIME) > NOW() OR TIMESTAMP(SC.DISCONNECT_TIME) <= DATE_SUB(NOW(),INTERVAL 60 DAY)))) ORDER BY CLIENT_VERSION, SYSTEM_NAME

 

Answered 08/30/2013 by: easterdaymatt
Seventh Degree Black Belt

Please log in to comment