/build/static/layout/Breadcrumb_cap_w.png

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.

0 Comments   [ + ] Show comments

Answers (8)

Posted by: GillySpy 12 years ago
7th Degree Black Belt
2
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:
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 11 years ago
Posted by: scottlutz 12 years ago
Orange Senior Belt
0
Dave,

You could look to create a notification if the "Last Sync" was over a certain period of time.
You do this from the Computer Inventory page, and notifications are next to Smart Labels.

Is that what you are looking for?
Posted by: dave1kelsey 12 years ago
Orange Belt
0
Thanks i have tried this already and end up with numerous emails depending on the frequency set within the properties of the notification.
i was hoping that when a inventory took place it would send a notification then.
Posted by: scottlutz 12 years ago
Orange Senior Belt
0
I guess the real question here Dave is, what exactly is your end goal with this?
Posted by: dave1kelsey 12 years ago
Orange Belt
0
Essentially our clients need a software update but are un-reliable and wont tell us when they are connected remotley, so i need to know when they are on the system to push the update via scripting.
Posted by: scottlutz 12 years ago
Orange Senior Belt
0
Why not create a Smart Label based on target machines not having the required software, and assign this to the deployment? That way, when they connect, it will be deployed to them. Then you don't have to worry about where they are, and whether or not they let you know they connect.
Posted by: dave1kelsey 12 years ago
Orange Belt
0
Thanks for that will gove it a go.
Posted by: Roonerspism 12 years ago
Second Degree Brown Belt
0
Gilly,

Thats pretty handy mate, I'll be stashing this away as a way of getting notified when particularly nefarious students connect to the network so we can watch them.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

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