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
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.
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)
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.