Report - Add a count on inventory in a report

[alexgravel]

Hi,

I'm trying to add a column in a report that shows the number of applications that are discovered on inventory device.

Is it possible to do so? I couldn't find the option while building a report

Thanks

Alex

[erwinlindemann]

Hi Alex,

There is no way to configure such a report using the report builder available from the FNMS UI, unfortunately.

Assuming that you work with an on-prem version of FNMS, you can extract this information from the [FNMSCompliance] database using the following SQL:

;WITH cteInstalledApplicationCount (ComplianceComputerID, InstalledApplicationCount) AS
(
    SELECT
          ia.ComplianceComputerID
        , COUNT(ia.SoftwareTitleID)     AS InstalledApplicationCount
    FROM [InstalledApplications] ia
    GROUP BY ia.ComplianceComputerID
)
SELECT 
       cc.ComplianceComputerID   
    ,  cct.DefaultValue                 AS ComputerType
    ,  cc.ComputerName
    ,  ciac.InstalledApplicationCount
FROM      [ComplianceComputer]          cc  
JOIN      [ComplianceComputerType]      cct  
    ON cc.ComplianceComputerTypeID = cct.ComplianceComputerTypeID
JOIN      cteInstalledApplicationCount  ciac 
    ON ciac.ComplianceComputerID   = cc.ComplianceComputerID

All you need to do is expose this SQL query as a report in the FNMS UI.

[alexgravel]

Hi Erwin !

Thanks for the reply on this.

The SQL returns the value I was looking for.

As for exposing the SQL as a report in the FNMS UI, I am not too sure how too procede.

I found this (ComplianceSavedSearch Table) :

https://docs.flexera.com/FlexNetManagerSuite2020R1/EN/Schema/index.html#SysRef/schema/ComplianceSchema/Compliance.Logic.CoreTables/reference/ComplianceSavedSearch.html

 So in order to make this work I would need to add a record in the said table in order to access it via the UI?

Or is it something else I need to do to acheive this?

Thanks

[ChrisG]

Try using the Installations (number) report column that is available on inventory device records, which counts the number of application installations that have been recognized on each device: