SOLUTIONS ARE PROVIDED ON AN "AS IS" BASIS. NEITHER FLEXERA NOR ITS SUPPLIERS MAKE ANY WARRANTIES, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, TITLE, FITNESS FOR A PARTICULAR PURPOSE OR NONINFRINGEMENT. LICENSEE MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, WILL BE LIMITED TO THE SHORTER OF (I) THE STATUTORILY REQUIRED PERIOD OR (II) THIRTY (30) DAYS FROM LICENSEE’S ACCEPTANCE OF THE AGREEMENT.
The Named User Consumption and Optimization Report will be released early August in the 2022 R1.4 version of Flexera One ITAM. This report extends the logic of a report already published in the community for Adobe: https://community.flexera.com/t5/FlexNet-Manager-Blog/Import-your-Adobe-subscriptions-directly-from-the-Adobe-Portal/ba-p/207424
Below is the documentation and the code to implement the report in an on premise instance of FlexNet Manager. The SQL code to create the report is in the attached Word document.
The Named User Licenses Consumption and Optimization Report when ran, allows Software Asset Managers to actively track subscriptions for installed applications, and returns license consumption for all named user licenses.
By design, named user licenses can be complex as subscriptions often allow for bundled software. This makes it hard to understand what applications (installed applications, installed and used applications) are consuming the named user license. To address this complexity and optimization opportunity, this report brings a summarized view, per user consumption that provides all details to understand the consumptions: installed and used applications consuming the license.
The report returns extensive user details such as full name, email address and so on. As well as consumption details such as installed applications consuming licenses, and installed and used applications consuming licenses.
Beyond Software Asset Management data transparency, the report computes optimization recommendations assessing each user(s) with an active subscription against lower cost subscriptions from the same Publisher, for installed and used applications. Specifically for Adobe, the report will identify if it's cheaper to license standalone Adobe products in comparison to subscribing to the Creative Cloud All Apps license subscription.
The report provides all cost information (current cost, optimal cost, potential saving for users, total potential saving and so on).
Software Asset Managers can subsequently use this data to action subscription(s) downgrades.
Note: By design, a named user license will cover installed applications for only those users who are allocated the license.
On running the report after the latest inventory import and license reconciliation process, the report will compute the following:
Note: The report does not include Microsoft Developer Network (MSDN). MSDN has a very specific configuration (in certain cases, can have hundreds of applications linked to a license) and does not have any downgrade capability.
Note: This report is scoped to the data that each operator is entitled to see, according to their access rights.
While an administrator can see all licenses, consumption, and optimizations, another operator who has access rights restricted to EMEA sees only those elements linked to the EMEA location, and to any of its child locations.
To create the report, please execute the code below on the FNMSCompliance database. It will create the report at the root of your report tree. You can then move the report in a selected folder with the following query (make sure the folder name and report name are unique)
SET ComplianceSearchFolderID = (SELECT ComplianceSearchFolderID
FROM ComplianceSearchFolder f
WHERE f.Name = 'MyTargetFolder'
AND f.Path LIKE '-17.%')-- reports folders
WHERE ComplianceSavedSearch.SearchName = 'Named user Licenses Consumption & Optimization (NR)'
Jul 20, 2022 09:59 AM