/build/static/layout/Breadcrumb_cap_w.png

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


2 Comments   [ + ] Show 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? - chucksteel 10 years ago
  • you can do this with the report wizard, as all needed stuff is predefined in the wizard - Nico_K 10 years ago

Answers (1)

Posted by: easterdaymatt 10 years ago
7th Degree Black Belt
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

 

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ