Windows: Changes in the last 7 days (Built-in)

[Daniel_B]

Old name: Software changes (installation/uninstallation) in the last 7 days

The report below lists Windows computers that were scanned and whose software was changed in the last 7 days

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• Software changes were detected within the last 7 days.
  

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tsysAssetTypes.AssetTypename As Type,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lasttried,
  tblAssets.Lastseen,
  Case tblSoftwareHist.Action When '1' Then '+' When '2' Then '-' End As [+/-],
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftwareHist.Installdate,
  tblSoftwareHist.Lastchanged
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tsysIPLocations On tblAssets.LocationID =
    tsysIPLocations.LocationID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftwareHist On tblAssets.AssetID = tblSoftwareHist.AssetID
Where tblSoftwareHist.Lastchanged > GetDate() - 7 And tblState.Statename =
  'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName,
  tblSoftwareHist.Lastchanged Desc,
  Software