Report with sum/count of applications installed

Comments

8 comments

  • Brigg Angus

    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.

    0
    Comment actions Permalink
  • Kirk Rogers

    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?

    0
    Comment actions Permalink
  • Corentin Douny

    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

    0
    Comment actions Permalink
  • David DePuy

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

    0
    Comment actions Permalink
  • Webmaster

    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


    0
    Comment actions Permalink
  • Reto Frauenfelder

    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

    0
    Comment actions Permalink
  • Emily Dullum

    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

    0
    Comment actions Permalink
  • Colby Bouma

    Emily Dullum

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

    0
    Comment actions Permalink

Please sign in to leave a comment.