Upgradedto 5.0.0.81 now report won't work

[massimi]

The following report worked fine Monday, but we upgraded to 5.0.0.81 on Tues, and now it's not showing any software has been updated since 20 Aug.

Select Top 1000000 a.AssetID,
a.AssetUnique,
a.Domain,
os.Image As icon,
Case sh.Action When '1' Then '+' When '2' Then '-' End As [+/-],
su.softwareName As Software,
sh.softwareVersion As Version,
su.SoftwarePublisher As Publisher,
sh.Installdate,
sh.Lastchanged
From tblAssets a
Inner Join tblSoftwareHist sh On a.AssetID = sh.AssetID
Inner Join tblSoftwareUni su On sh.softid = su.SoftID
Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
Inner Join tsysOS os On a.OScode = os.OScode
Where sh.Lastchanged > GetDate() - 7 And ac.State = 1
Order By a.AssetName,
sh.Lastchanged Desc,
Software

Am I missing something? Thanks.

[Hemoco]

Please verify whether your computers have recently and successfully been rescanned. The "last seen" dates listed on their asset pages should be recent. You can rescan your machines by clicking the Assets link at the top of the web console, ticking the upper checkbox and hitting the Rescan button on the left.

If there are scanning errors, you can find them listed in the machine's Errors tab. A troubleshooting guide can be found here: http://lansweeper.com/kb/1/troubleshooting-guide.html