alexgravel
Level 2

Report - Add a count on inventory in a report

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

Labels (1)
0 Kudos
3 Replies
erwinlindemann
Level 8

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.

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/ComplianceSche...

 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

0 Kudos
ChrisG
Community Manager Community Manager
Community Manager

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:

image.png

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)