Report for last Windows update install

predator29 · ‎01-13-2015

I'm trying to come up with a report that shows the last time windows updates were installed on a system. I've been messing around with the newest date for Quickfix but I cant seem to get a working report. Has anyone come up with a report that does this?

Susan_A · ‎02-27-2015

leblanc.daniel.4@hydro.qc.ca wrote:
I am also getting the same message of error, i am using SQL Express

There was an error parsing the query. [ Token line number = 1,Token line offset = 193,Token in error = Select ]

You are likely using SQL Compact, not SQL Express. These are two completely different database servers. We posted a SQL Compact compatible report in this topic a while back.

View solution in original post

RCorbeil · ‎01-13-2015

Try this:

SELECT Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  ( SELECT Top 1
      tblQuickFixEngineering.Lastchanged
    FROM
      tblQuickFixEngineering
    WHERE
      tblQuickFixEngineering.AssetID = tblAssets.AssetID
    ORDER BY
      tblQuickFixEngineering.Lastchanged Desc) AS LastQFChange
FROM
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
WHERE
  tblAssetCustom.State = 1

Assumes that the entries in tblQuickFixEngineering are placed there as part of a Windows Update run, not one-off updates.

Report for last Windows update install

Reports & Analytics

New to Lansweeper?

Try Lansweeper For Free