Creating Software Report with computers listed as results

[abustraan]

I've created a copy of the "Software: All installed programs" and added a filter for 3 specific peices of software that make up a specific release.

However, when I run the report, it only shows the number of systems per peice of software and not the systems themselves, unless I click on one of the peices of software listed.

Is there a way to modify the results to show all of the systems and not the count?

Thanks in advance.

[Hemoco]

We recommend familiarizing yourself with SQL, as the Lansweeper report builder uses standard SQL queries: http://www.w3schools.com/sql/default.asp

An overview of WMI (Windows Management Instrumentation) classes scanned by Lansweeper can be found in the Configuration/Scanning Setup/Item Wait Time section of the Lansweeper web console. Most database table names mimic their WMI counterparts. For instance: Win32_Operatingsystem data is stored in tblOperatingsystem. If you cannot locate a specific field, please contact us. We would be happy to help.

[abustraan]

Thanks for the great prompt reply. LanSweeper has so much capability, I just need to go through all of the prebuilt reports and see what they offer and how I can tweak them.

[Hemoco]

abustraan wrote:
Thanks for the great prompt reply. LanSweeper has so much capability, I just need to go through all of the prebuilt reports and see what they offer and how I can tweak them.

If you get stuck creating a specific report, please contact us at support@lansweeper.com and provide us with your report requirements. We will send you the report.

[Jeff]

Lansweeper wrote:

abustraan wrote:
Thanks for the great prompt reply. LanSweeper has so much capability, I just need to go through all of the prebuilt reports and see what they offer and how I can tweak them.

If you get stuck creating a specific report, please contact us at support@lansweeper.com and provide us with your report requirements. We will send you the report.

I have taken some of the built-in reports and tweaked them with varying degrees of success, but do not have a lot of SQL experience. Is there additional documentation specifically on the Report Builder I can locate, or is there a recommended guide for SQL queries that may be helpful for creating reports? Thanks.

[Hemoco · Accepted solution]

You need to base your report on "Software: List of software by computer", as "Software: All installed software" does not include computer names.

A sample report can be seen below. Replace YourSoftware1, YourSoftware2 and YourSoftware3 with the names of the software packages you would like to report on.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblSoftware.softwareName As Software, tblSoftware.softwareVersion As Version, tblSoftware.SoftwarePublisher As Publisher, Web40OSName.Compimage As icon From tblSoftware Inner Join tblComputers On tblSoftware.ComputerName = tblComputers.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where tblSoftware.softwareName = 'YourSoftware1' Or tblSoftware.softwareName = 'YourSoftware2' Or tblSoftware.softwareName = 'YourSoftware3' Order By tblComputers.ComputerUnique, tblSoftware.softwareName, tblSoftware.softwareVersion