I needed a kind of report which shows compliance with internal patch policy. Now you can call this report via Chart widget and get nice dashboard report on windows updates on clients Where PREVIOUSLYCREATEDREPORTNAME.OSname In ('Win 7', 'Win 8', 'Win 8.1', When PREVIOUSLYCREATEDREPORTNAME.lastPatchDate = DateAdd(day, When PREVIOUSLYCREATEDREPORTNAME.lastPatchDate >= DateAdd(day, -7, In this query, I wanted only clients using where OSname In ('Win 7', 'Win 8', 'Win 8.1', This may be better utilized SQL code but it was my first shot.

Next, you can create report with Chart: prefix. You should note this report name (db view) because it will be required for the next query. The issue here could be that you may have wrong date in some cell and convert might fail. Group by tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAssets.Username, tblAssets.IPAddress, tblAssets.Description,įormat of column InstalledOn is mm/dd/yyyy and Convert function nicely converts it to datetime. Join tsysOS on tblAssets.OScode = tsysOS.OScode JOIN tblAssets on tblAssets.AssetID=tblQuickFi圎ngineering.AssetID MAX(CONVERT(datetime, InstalledOn)) as lastPatchDate, SELECT tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAssets.Username, tblAssets.IPAddress, tblAssets.Description, In order to get this info, I used latest KB installed date in table yblQuickFi圎ngineering.

I would like to share report on installed windows updates which shows details on windows assets plus date of latest windows update installed.

Lansweeper windows updates