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   [ + ] Show 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

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
Answer this question or Comment on this question for clarity