All, Doing this manually today which is very time intensive.  Asking to see if the community here has ideas or SQL Scripts to help. Here's what I'm ideally attempting in order to refresh our data faster 1. List of Applications that I would define in a "List" which we know has a Java dependency and would include device properties to get where installed. The list would be updated periodically 2. The above list would then be compared against known Java deployments to include device properties to get where installed.   3. A compare that would then show Java submit to remediation or otherwise where known to have one or more application that has a Java dependency   Step 1 is where help needed, my list is growing and not feasible to run individual app deployed reportes Steps 2,3 I can manage. Just showing end to end in case of some wild miracle this is possible in a complex SQL query   Thanks for any help on step 1   ... View more

How can this be accomplished in FNMS?  I'm on-prem 2019R2.  My attempts keep creating a single line for every app on each devices making the record counts into the millions.  The report GUI is challenging to edit, modify, etc. Looking for something like this OS, App Name, Count Thanks ... View more

This will be an odd inquiry, bear with me.    Within the compliance tab of a License Properties one could "manually" increment entitlements without adding in a purchase record.  Where inventory (consumption) is not available for any reason how might I manually "increase" consumption to give a single compliance perspective for both discoverable (dynamic) and non-discoverable (Static or PIT point in time) positions? This would help form a complete position where FNMS either can't or we're not permitted to run discovery.  ... View more