Hi All,

The query i am looking for is to "Create a collection of computers that has not been windows update from last 30 days". I have got some Powershell scripts which can perform the tasks, but I require this can be done from by WQL or SQL query.

Below are some related powershell article:

http://www.powershelladmin.com/wiki/Check_when_servers_were_last_patched_with_Windows_Update_via_COM_or_WSUS

https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca

Please share if somebody have the script.

Hi, 

 This is a query to get the need information....

v_R_System.Netbios_Name0Hostname,v_UpdateScanStatus.LastScanTime

v_R_System

ONv_R_System.ResourceID=v_UpdateScanStatus.ResourceID

v_UpdateScanStatus.LastScanTime<(GetDate()-30)

BYLastScanTimeDESC

Hi Jeovan,

I am getting below error while running the query in SQL:

ONv_R_System.ResourceID --> ON v_R_System.ResourceID and BYLastScanTimeDESC --> BY LastScanTime DESC

Hi,

Thanks for the help. Now Query is working, But my question is to find the Last update install time on machine not last scan time.

Above highlighted value can be fetch from below registry value:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install REG_SZ: LastSuccessTime

That would require to modify hardware inventory. 

Win32_QuickfixEngineering also contains the install date. 

Thanks,

Now I am able to fetch the Last install date in SCCM by Win32_QuickfixEngineering. 

I have created the same query to fetch Last install date as the same used in last software scan query.

Now the outcome of the report something like showing all updates less than 30 days.. I need some fine tuining here which will fetch the machine with time stamp details from last 30 days. Only a single Installed date against the mac