Way to be alerted when an agent is "connected"
Is there a way that the KBOX can alert people when a specific computer makes a connection to the KBOX for inventory?
We have a number of pc's that require software updating on them but they are remote users who work "randomly" and we need the notification to alert us when they are online and available.
We have a number of pc's that require software updating on them but they are remote users who work "randomly" and we need the notification to alert us when they are online and available.
0 Comments
[ + ] Show comments
Answers (8)
Please log in to answer
Posted by:
GillySpy
12 years ago
I'd do everything scott said except we cannot be certain of a sync happening (e.g. AMP is good but inventory fails) so please use this Here's an example SQL for that alert
Steps:
1. reporting ->email alerts->choose action->new computer notification->go through the wizard->Create Notification
2. reporting ->email alerts->click on what you just created
3. modify the SQL to be:
4. modify the alert schedule to be every 15 minutes
You'll get 4 notifications during the hour when it checks in
Steps:
1. reporting ->email alerts->choose action->new computer notification->go through the wizard->Create Notification
2. reporting ->email alerts->click on what you just created
3. modify the SQL to be:
select MACHINE.NAME,
MACHINE.IP,
MACHINE.USER_LOGGED,
LAST_SYNC,
GREATEST(SC.CONNECT_TIME, SC.DISCONNECT_TIME) "Last Seen",
IF(SC.CLIENT_CONNECTED=1,'Still Connected','Doh, missed it!') "Connected?"
-- , whatever else you want
from MACHINE JOIN
KBSYS.SMMP_CONNECTION SC on SC.KUID=MACHINE.KUID
where LAST_SYNC > DATE_SUB(NOW(), INTERVAL 1 HOUR)
4. modify the alert schedule to be every 15 minutes
You'll get 4 notifications during the hour when it checks in
Comments:
-
I tried this mysql query and I get all machines that are connected, but I'm looking to get notified when one machine is turned on and syncs. As soon as this machine is seen as being on, then I need to manually connect to it and do some work on it. How can I have the above SQL query check for a single machine and notify me when it has checked in, like 5 minutes after it checks in notify me via email. - jwaltersnsm 12 years ago
Posted by:
scottlutz
12 years ago
Posted by:
dave1kelsey
12 years ago
Posted by:
scottlutz
12 years ago
Posted by:
dave1kelsey
12 years ago
Posted by:
scottlutz
12 years ago
Posted by:
Roonerspism
12 years ago
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.