Avoid multiple Listing in Reports

[mcam]

The problem occures for example in this report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblADusers.Displayname,
tblADusers.Department,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
TsysLastscan.Lasttime
From tblADComputers
Inner Join tblAssets On tblAssets.AssetID = tblADComputers.AssetID
Left Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Where tblSoftwareUni.softwareName Like '%Avira Professional Security%'
Order By tblAssets.AssetUnique

In this query i want to get the pc name,the user name and the time it was seen the last time of all pcs with the Software "Avira Professional Security". I get all these infos but due to the lastscan (which i think is lastseen??) i get multiple entries for one pc. I just want to have one entry per pc.

Thanks a lot

[mcam]

Thank you, Works great

[Susan_A · Accepted solution]

TsysLastscan stores information on when specific data (memory, processor, software...) was last scanned. You are seeing multiple entries per computer because you did not filter the TsysLastscan table. There is one line in your report per computer and per scan item (memory, processor, software...)

If you are simply trying to list your computers' "last seen" dates, you should:

• Remove TsysLastscan from your report, by (in the visual representation of the report in the upper section of the report builder) hitting the in the upper right corner of the table.
  
• Tick the Lastseen field in tblAssets instead.