/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


K1000: Device list where user is currently not logged in

09/19/2017 712 views
I'm looking for a way to create a SmartLabel that will list all devices where the user is currently not logged in. I've resorted to the fact that I'll have to use the Edit SQL feature in the SmartLabel wizard. One tip I did find and confirmed on a few machines is to look for explorer.exe in the list of running processes. In my searches I did find a couple queries to try but they did not work as they still pulled in systems with users logged in.

One of the queries I tried is this:

select MACHINE.ID from MACHINE
JOIN MACHINE_PROCESS_JT MP ON MP.MACHINE_ID=MACHINE.ID
JOIN PROCESS P ON P.ID=MP.PROCESS_ID
WHERE
P.NAME='explorer.exe'

I don't know if the structure is different on the version we have (7.0). Does anybody have any other ideas on making this work?  I have a software deploy to do and would prefer the users not be logged in while it takes place.

Thanks.

2 Comments   [ + ] Show comments

Comments

  • Instead of going through the hassle of setting up this smart label, why not just set the managed install to only run when user is logged out?
    • Ya know, I totally forgot about that option. HA! Thanks. I will try that.
  • I'm trying to create a similar SmartLabel for patching. I'd like to patch computer which are turned on and is not logged on, with an immediate reboot. For logged-on computers, I want to give the user the option of delaying the reboot.
    • With patches, you can set the notifications for the initial notification and reboot. Under the reboot section, check the box to automatically reboot when no one is logged in. Use your smartlabel for devices that need patching, like those that would get them during the night vs. during the day, or executives vs. rest of employees.

Be the first to answer this question

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