Report specific Sofware installed where installation date is at least one week old

[servicedesk]

I want to clean up computers from useless software using a after scanning deployment configuration, eg installed 3rd party antivirus but technician forgot uninstall it.

I already have a report for this but has a problem, If the software its just installed and is being used will uninstall it... for this reason I would like a report that also filters by 1 week after installation date.

Is this posible?

Here is my actual report:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.IPAddress,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblAssets.Username,
  tblSoftwareUni.softwareName As software,
  tblSoftware.softwareVersion As version,
  tblSoftwareUni.SoftwarePublisher As publisher,
  tsysOS.Image As icon,
  tblADComputers.OU
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
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssets.IPAddress Like '10.162.%' And tblSoftwareUni.softwareName Like
  'Malwarebytes Anti-Malware%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  software,
  version

Many thanks

[Daniel_B · Accepted solution]

You can do this by filtering on tblSoftware.Installdate, like in the example below. Be sure to regularly scan your computers in order to have recent information in your database.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.IPAddress,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblAssets.Username,
  tblSoftwareUni.softwareName As software,
  tblSoftware.softwareVersion As version,
  tblSoftwareUni.SoftwarePublisher As publisher,
  tsysOS.Image As icon,
  tblADComputers.OU
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
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssets.IPAddress Like '10.162.%' And tblSoftwareUni.softwareName Like
  'Malwarebytes Anti-Malware%' And tblAssetCustom.State = 1 And
  tblSoftware.Installdate < GetDate() - 7
Order By tblAssets.AssetName,
  software,
  version