Report to display PC workstation which has installed Autodesk software

[ken]

Hi guys,

I would like to create a PC workstations list report that has installed the Autodesk software. The version of my lansweeper is v.5233


Fore example

PC Hostname, pc description, OS, PC Model, Memory site, Autodesk software name, software version.


Any help is appreciated!

[Susan_A · Accepted solution]

A sample report can be seen below. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  
• Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Description As LocalDescription,
  tblADComputers.Description As ADDescription,
  tblOperatingsystem.Caption As OS,
  tblAssets.SP,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssets.Memory,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblSoftwareUni.SoftwarePublisher Like '%autodesk%' And
  tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Software