Report that gives me all software by userid

[eknabusch]

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.

[ProfileNL]

 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]

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 · Accepted solution]

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.