push feature updates to computers where no user is currently logged in

Help!, I need a sql query to help me to update computers during the day when nobody is logged in to the PC.

I'm trying to get all of my machines updated for compliance reasons, but it would help if I can be updating machines during the day 

without disrupting people's workday. I need a report to tell me machine names, os release, and where there is no user currently logged in.

Thanks in Advance, Tom 

0 Comments   [ + ] Show comments

Answers (3)

Posted by: KevinG 2 months ago
Red Belt

The information in the database is from the last inventory upload from the device.  Since the last upload, a user may have logged in or logged out from a device. 
This is not real-time data. 

Posted by: Dynas2001 2 months ago
White Belt

Instead of that you could just use OneVinn to deploy. It can be aware if there is a user on the box and you can tell it to install right away if no user is logged on i believe.

It also allows the user to schedule it off hours. (I'm assuming you mean full feature updates via Task Sequence) because using an enablement update takes a few seconds and there is no real interuption for the users.  You would just need to do some tweaking (maybe, we haven't had to while using the enablement)

Posted by: tbarth 2 months ago
White Belt

Are you currently using Group Policy to set schedules on when Windows Updates are performed on computers? If so, here is what I recommend:

Set the TargetReleaseVersion, TargetReleaseVersionInfo, and ProductVersion, in Registry on your workstations. Then you can leave it up to your Windows Updates policies to handle the rest.

As for how you accomplish this, you can do this in Group Policy and OUs or you can push it to set those Registry keys. An advantage to this approach is that when the next Feature Update comes out, all you'll need to do is update the TargetReleaseVersionInfo and sit back while Windows Updates does the rest with installing the enablement package.

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