→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
servicedesk
Champion Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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