Question about software list on individual computers

[Jeff]

In the console I usually select one workstation and then go to the Software section to review the software on the computer. In that page, next to the Install Date I noticed an untitled column where a few of the software titles have an icon of a person next to the date. Are those icons for software that the currently logged-in user was able to install on the computer?

If so, is it possible to create a report of just the user-installed software on all the workstations in our console? Thanks.

[Daniel_B · Accepted solution]

Lansweeper will set tblSoftware.CurrentUser to 1 if a software was scanned which was installed only for the currently logged on user.
Note: Software which was installed for another user (not logged on during scanning of the computer) won't be scanned. The following report will list only software which was installed for a logged on user.
This feature is available since Lansweeper version 5.2.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblSoftwareUni.softwareName As software,
  tblSoftware.softwareVersion As version,
  tblSoftwareUni.SoftwarePublisher As publisher,
  tsysOS.Image As icon
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
Where tblAssetCustom.State = 1 And tblSoftware.CurrentUser = 1
Order By tblAssets.AssetName,
  software,
  version

For instructions on how to run a report, please refer to this note.