K1000: Device list where user is currently not logged in
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
-
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? - chucksteel 6 years ago
-
Ya know, I totally forgot about that option. HA! Thanks. I will try that. - ehansen 6 years ago
-
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. - PaulGibson 6 years ago
-
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. - ehansen 6 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
