Report all devices not patched in last 90+ days

[pabby]

Hi 

I can get monthwise data but is there a report that tells me how to find all devices on network that have patches missing for more than 90 days.

[Mister_Nobody]

Try this

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.oscode,
  tblAssets.BuildNumber,
  tblAssets.Version,
  tblAssets.Username,
  tblAssets.IPAddress,
  Max(Convert(date,tblQuickFixEngineering.InstalledOn)) As lastPatchDate,
  Max(tblQuickFixEngineering.qfeid) As fixversion,
  tblAssets.Lastseen
From tblQuickFixEngineering
  Inner Join tblAssets On tblAssets.AssetID = tblQuickFixEngineering.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.oscode,
  tblAssets.BuildNumber,
  tblAssets.Version,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssets.Lastseen
Having Max(Convert(date,tblQuickFixEngineering.InstalledOn)) < GetDate() - 90
Order By lastPatchDate Desc