→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
adnan
Engaged Sweeper
Hi There,

I am having trouble creating a custom report to list all the software installed on desktops. I have found this information in two seperate reports but am unable to create a single report which retrieves information from two different tables.

To Summarise the report needs to contain:

-Software Name,Version installed on only desktops
-Count of each software on the desktop.

Thanks in advance.
6 REPLIES 6
adnan
Engaged Sweeper
That worked a treat!

Thank you 🙂
adnan
Engaged Sweeper
Thank you very much for this, thats worked 🙂

Is it possible to combine multiple chassis types in the same report or would it be easier to create seperate report per chassis type?

For example if I wanted to include Chassis Type 3, 4 and 6 in the same report.
Hemoco
Lansweeper Alumni
adnan wrote:
For example if I wanted to include Chassis Type 3, 4 and 6 in the same report.


Please try the report below. (Original report was also edited to make a few improvements.)

Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
SoftwareCount.[Number of Installations]
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
(Select tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, Count(tblSoftware.ComputerName) As
[Number of Installations]
From tblSoftware Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblSoftware.ComputerName
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSystemEnclosure.ChassisTypes
Having (tblSystemEnclosure.ChassisTypes = '3') Or
(tblSystemEnclosure.ChassisTypes = '4') Or
(tblSystemEnclosure.ChassisTypes = '6')) SoftwareCount On
SoftwareCount.softwareName = tblSoftware.softwareName And
SoftwareCount.softwareVersion = tblSoftware.softwareVersion
Where (tblSystemEnclosure.ChassisTypes = '3') Or
(tblSystemEnclosure.ChassisTypes = '4') Or
(tblSystemEnclosure.ChassisTypes = '6')
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion
Hemoco
Lansweeper Alumni
Please try the report below. This report lists only computers that have the "desktop" chassis type. An overview of all possible chassis types can be found here.

Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
SoftwareCount.[Number of Installations]
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
(Select tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, Count(tblSoftware.ComputerName) As
[Number of Installations]
From tblSoftware Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblSoftware.ComputerName
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSystemEnclosure.ChassisTypes
Having tblSystemEnclosure.ChassisTypes = '3') SoftwareCount On
SoftwareCount.softwareName = tblSoftware.softwareName And
SoftwareCount.softwareVersion = tblSoftware.softwareVersion
Where tblSystemEnclosure.ChassisTypes = '3'
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.
adnan
Engaged Sweeper
Thank you for the quick reply 🙂

I am referring to creating a report of a list of all software installed on the desktops across the network along with a count of how many desktops it is installed on.

There is a default report available in Lansweeper which lists the Name, Version and Count of all installed software across the network, this includes on all desktops, laptops and servers. I am looking to create the same as this but only limited to Desktops.

I hope that makes sense.

Is this possible?
Hemoco
Lansweeper Alumni
adnan wrote:
-Count of each software on the desktop.

Could you clarify what you mean by this. Are you referring to a count of how many software packages are installed on each desktop? Or a count of how many times a particular software package is installed across your network?