cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pixa241
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

5 REPLIES 5
Daniel_B
Lansweeper Alumni
Very good solution.
Daniel_B
Lansweeper Alumni
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
Engaged Sweeper II
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
Lansweeper Alumni
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
Engaged Sweeper II
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?