Report with sum/count of applications installed

Hi Lasse,

I'm sorry this comes late, and hopefully you were able to get the report you wanted, but in case you weren't or others are looking for the same thing, the 6.2 version of Inventory has a canned report called, "Application Counts" that has exactly what you're looking for.

To access this, open Inventory -> REPORT (menu) -> Run Rerport -> Application Counts

I hope that helps.

Has anyone taken this a step further and listed all applications, the versions installed, and list of computers these are installed on with counts and totals?

you need to make some SQL query to have this kind of report kirk.
here is what i used:

make a new report (SQL Report !!!)

replace the code by the following :

Select
    Applications.Name 'Applications',
    Applications.Version 'Versions',
    count(Computers.Name) 'Number',
    group_concat(Computers.Name, ', ') 'Computer Names'
from Computers inner join Applications on Computers.ComputerID=Applications.ComputerID
group by Applications.Name
order by Applications.Name

Run report.

FYI: it's not a finished version of my SQL report (cause i haven't modify the where <ComputerFilter>) but this SQL code does the SQL report for All Computers hope it'll help

Thank you Corentin for the SQL.  Exactly what I needed. 

Thanks very much for this helpfull SQL snippet. I added the SQL Snippet "where

Select Applications.Name 'Applications', count(Computers.Name) 'Number', group_concat(Computers.Name, ', ') 'Installed on this Computer Names' from Computers inner join Applications on Computers.ComputerID=Applications.ComputerID where <ComputerFilter> group by Applications.Name order by Applications.Nameenter

Thanks very much for this helpfull SQL snippet. I added the SQL Snippet ComputerFilter to select the collection source.

---
Select
Applications.Name 'Applications',
count(Computers.Name) 'Number',
group_concat(Computers.Name, ', ') 'Installed on this Computer Names'
from Computers inner join Applications on Computers.ComputerID=Applications.ComputerID
where

This is a great report!  Is there anyway to create multiple rows of the computer names that have the applications installed instead of the computer names being separated with a comma on the same line?  

For Example:

Current SQL Report shows

7-Zip       16.04      2      ComputerA, ComputerB, ComputerC

I'd like the report to show this output:

7-Zip       16.04      1      ComputerA

7-Zip       16.04      1      ComputerB

7-Zip       16.04      1      ComputerC

Emily Dullum

Are you looking for something other than the built-in Applications report?

I realize this is old but does anyone know how to use this but also create SW exclusions from the report output?

I want to generate this report in this exact format but exclude numerous specific applications to have a clean way of viewing Non-Standard installations. I attempted to create a dynamic collection excluding the SW however running the report still generates 'all' SW in the list.

Thanks

Add a Filter like this to your Report:

Not Any
    Application | Name | Contains | Google Chrome

I can create the filter but not sure how to do it within a SQL report. If I create a dynamic collection and run the following report it still displays all data within the report even with the filters added to exclude the data because it's included within the SQL reporting

This is what I am using, just trying to exclude 'known' apps from the report such as Google, Adobe Reader etc. Hopefully that makes sense.

Select
    Applications.Name 'Applications',
    Not
    Applications.Version 'Versions',
    count(Computers.Name) 'Number',
    group_concat(Computers.Name, ', ') 'Computer Names'
from Computers inner join Applications on Computers.ComputerID=Applications.ComputerID
group by Applications.Name
order by Applications.Name

Edit:

I believe I resolved it be using this as a sample;

Select
    Applications.Name 'Applications',
    Applications.Version 'Versions',
    count(Computers.Name) 'Number',
    group_concat(Computers.Name, ', ') 'Computer Names'
from Computers inner join Applications on Computers.ComputerID=Applications.ComputerID
And applications.name not like "Google%"
And applications.name not like "chrome%"
group by Applications.Name
order by Applications.Name