Can K1000 notify when clients enter disconnected/offline state after (x) hours?
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
Answers (1)
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
Or, would you like a report showing a list of machines and whether they are still connected after a certain amount of time? - chucksteel 11 years ago