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

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

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?
Answered 03/09/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
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.
Answered 03/09/2012 by: dave1kelsey
Orange Belt

Please log in to comment
0
I guess the real question here Dave is, what exactly is your end goal with this?
Answered 03/09/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
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.
Answered 03/09/2012 by: dave1kelsey
Orange Belt

Please log in to comment
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.
Answered 03/09/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
0
Thanks for that will gove it a go.
Answered 03/09/2012 by: dave1kelsey
Orange Belt

Please log in to comment
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
Answered 03/09/2012 by: GillySpy
Seventh Degree Black Belt

  • 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.
Please log in to comment
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.
Answered 03/11/2012 by: Roonerspism
Second Degree Brown Belt

Please log in to comment
Answer this question or Comment on this question for clarity