Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report on Automatic updates

Status
Not open for further replies.
Jul 5, 2006
42
US
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.
 
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.
 
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.
 
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
 
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'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top