→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
eknabusch
Engaged Sweeper
I am new to the tool, I need a report that shows all software by userid. Not a consolidated report on software running. Is this available on the standard reports.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
I moved this report from the report center to Report Requests & Questions. Keep in mind that the report center is only for posting ready-to-use Lansweeper reports, not questions.

You can slightly modify the built-in "Software: List of software by computer" report to display the information you are after.
  • Open the report in the Reports tab.
  • Hit the Edit Report button on the left.
  • In the visual representation of the report in the upper section of the report builder, tick the Username and Userdomain fields in tblAssets. This will add your computers' last logged on users to the report.
  • Hit Save & Run.

View solution in original post

3 REPLIES 3
ProfileNL
Engaged Sweeper III
 Select Top (1000000) tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Department,
tblADusers.Company
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
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Left Outer Join tsysIPLocations On tsysIPLocations.StartIP <=
tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version

As far as I see, there isnt such thing for managers.
OriPEBE
Engaged Sweeper II
Hi,

that is also exactly what I wanted but I need additional information about the user like Firstname Lastname (or Fullname),Manager, Department and Company.
All information are in the AD user but I cannot find it hot to add it to the report.
Susan_A
Lansweeper Alumni
I moved this report from the report center to Report Requests & Questions. Keep in mind that the report center is only for posting ready-to-use Lansweeper reports, not questions.

You can slightly modify the built-in "Software: List of software by computer" report to display the information you are after.
  • Open the report in the Reports tab.
  • Hit the Edit Report button on the left.
  • In the visual representation of the report in the upper section of the report builder, tick the Username and Userdomain fields in tblAssets. This will add your computers' last logged on users to the report.
  • Hit Save & Run.