
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-26-2015 05:47 PM
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.
If so, is it possible to create a report of just the user-installed software on all the workstations in our console? Thanks.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2015 07:40 PM
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.
For instructions on how to run a report, please refer to this note.
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.
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2015 07:40 PM
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.
For instructions on how to run a report, please refer to this note.
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.
