KACE Product Support Question
K1000: Device list where user is currently not logged in
09/19/2017 711 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
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.
Be the first to answer this question