I am hoping to support a project that is rationalising applications across our estate.
Is it possible to create a report that will accept a list of device numbers and report back all applications found on each device?
Basically, what I am after is the result of clicking on a device and then the Applications tab but for multiple devices at the same time.
Jan 10, 2020 02:55 AM
What you are asking for sounds like a logical "or" for a report filter. You should be able to achieve this with "Advanced filter".
A more elaborate solution could involve dynamic SQL. The idea would be to pass a filter string containing elements separated by a delimiter (e.g. 'abc;xyz'). Then disassemble it in SQL and build a dynamic filter (ComputerName = 'abc' OR ComputerName = 'xyz') from it.
Jan 10, 2020 04:01 AM
As demonstrated by @mfranz, there are ways to achieve this with multiple filters, but that is not practical for a large number of devices. This is a capability I have seen in Service Now and i believe it would be a good enhancement to request via the link below:
Further to your problem, depending on your environment size, it would be simpler to extract all the required data for all devices via a report or SQL, and then filter and search for specific device results in excel.
Jan 13, 2020 03:59 AM
Under "Reports > License Compliance > Applications", there is a standard report named "Device Installation Details" that allows listing all applications installed on a single Inventory only.
You can create a custom report from the FNMS Web UI that allows listing applications installed on multiple Inventories.
In the "Report Builder", combine the "Inventory Device" object with the "Installations" object. For the "Installations" object, I remove the "Inventory Device Name" property (as this would be listed twice). From the "Application" object, feel free to add additional properties like "Edition" or "Classification".
In the subsequent "Preview and Filter" dialog, you can re-arrange the columns as needed (see attached screen shots).
After giving your report a name and saving it, you can use the "global search" feature in the report, or use an advanced filter for filtering on multiple device names in the "Inventory device name" column.
Jan 13, 2020 08:03 AM