Software report Machine Name

[pixa241]

I am looking to run a report where it will give the Name of the asset, IP, Hardware info, and the software that is installed on the machine. Here is an example.

Machine1 1.1.1.1 PowerEdge 2650 Adobe
Chrome
VNC
Machine1 1.1.1.2 PowerEdge 2750 Adobe
Chrome
Citrix
VNC
Machine1 1.1.1.2 VMWare Adobe
Chrome
Citrix
Microsoft Office
VNC

[Daniel_B]

Very good solution.

[Daniel_B]

This is not really supported by SQL which Lansweeper is using in order to generate reports. Especially for software installations, we wouldn't recommend it as the list can get too long to put it into a single row and it likely won't help to get a better overview.

[pixa241]

Daniel.B wrote:
This is not really supported by SQL which Lansweeper is using in order to generate reports. Especially for software installations, we wouldn't recommend it as the list can get too long to put it into a single row and it likely won't help to get a better overview.

I figured out how to do it. Once it creates the report, export it to XML, then open it with Excel, and create a Pivot table with it. Works Great!. Thanks for the help.

[Daniel_B · Accepted solution]

The built-in report "Software: List of software by computer" comes close to your need. You could edit this report and add tblAssets.IPAddress as well as tblAssetCustom.Model to it. However, as many software is installed on each computer, this might become a long report.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.IPAddress,
  tblAssetCustom.Model,
  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
Order By tblAssets.AssetName,
  software,
  version

[pixa241]

Daniel.B wrote:
The built-in report "Software: List of software by computer" comes close to your need. You could edit this report and add tblAssets.IPAddress as well as tblAssetCustom.Model to it. However, as many software is installed on each computer, this might become a long report.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.IPAddress,
  tblAssetCustom.Model,
  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
Order By tblAssets.AssetName,
  software,
  version

Yes that is what I was wondering, there is no way to consolidate the machine name so I can export it to excel, instead of having one line for each software?