"All installed software" report but show only for devices hat have been online since the last 30d

[RDiabl]

Hi,

there is a great report called "All installed software" and it works perfectly. Although we would like to have it show the software of devices during the last 30 days. I tried to change it myself, but the filter didn't work. Can you guys please help me out?

Thank you!

[RDiabl]

I think I managed to do it by my own:

Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Count(tblSoftware.AssetID) As Total
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
Where tblAssets.Lastseen < GetDate() - 30
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
Order By Total Desc