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

View solution in original post

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