report on Automatic updates

[DennisZhao]

Any one know how I can run a query or report to find out HOW MANY WORKSTATIONS HAVE THE WINDOWS AUTOMAIC UPDATES TURNED ON. I can't seem to find that information in the software collection data.

 

[lnesta431]

To check try the positive query:
select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName = " Automatic Updates" and SMS_G_System_SERVICE.StartMode = " Auto"

To show all machines that have the service set to auto.

Enabled is not an option. When you select the value in the query, click on the values button. It will show Auto, Disabled, Manual and Unknown.

If you are still not getting any results, open up a resource explorer for a machine and check it has services key under hardware.

 

[DennisZhao]

With that query, the result lists all the computers on my network. Is it only checking to see if there is the auto update service?
Which part of the statement tells sms to only look for the start mode of only automatic update service? instead of other services.

Thank for you help, I am really close to getting it, just that little piece missing.

 

[ncotton]

cause it is checking for each instance of a record for Automatic Updates and StartMode=auto. Are you sure that all the systems reported dont have it in auto?

Hope this Helps.

Neil J Cotton
njc Information Systems
Systems Consultant

 

[SMSwannabe]

You have to work with subqueries (...is in...)

 

[SMSwannabe]

SQL:

SQL Query:

Select
System.Netbios_Name0 'Machine Name',
System.User_Name0 'User Name',
Services.DisplayName0 'Service Name',
Services.State0 Status,
Services.StartMode0 'Startup Type'

From System_Disc System
Join Services_DATA Services on System.ItemKey = Services.MachineID

Where Services.Name0 = 'Wuauserv'
And Services.State0 = 'Running'

 

[DennisZhao]

It worked, thank you.