1. Check report linkage: Ensure that the report is linked to the license.
2. Run reconcile: Execute a reconcile and wait for completion.
3. Run query: Execute the following query:

SELECT *

FROM dbo.SoftwareLicenseScopingGroup AS slsg

LEFT JOIN dbo.ScopingGroupMember as sgm

ON slsg.ScopingGroupID = sgm.ScopingGroupID

WHERE slsg.SoftwareLicenseID = <SoftwareLicenseID>

This should contain a list of the ComplianceUserIDs for all the users included in the report linked to the license. If it does not, then there is a mismatch issue between the account that the reconcile is running under vs the account in the ComplianceOperator table.

4. Verify service account: The service account in the OperatorLogin column of ComplianceOperator needs to be an exact match with the user running the reconcile (for example, "domain.org\user" is considered different than "domain\user") as configured in the FNMS server scheduled task "Inventory Import and License Reconcile" as well as the account running the FlexNet Batch Processor and Batch Process Scheduler services. The OperatorLogin value in ComplianceOperator for the service account running the reconcile can be adjusted to match and resolve this issue.

Here is a scenario showing the expected behavior in a working environment:

1. Create custom user report: A custom user report is created and filtered as desired. In the picture below, the username has been filtered.

2. Run report: After creating the public user report, run it to confirm that it returns the filtered list of 25 users (note that the number here may not necessarily match the preview and filter page above as that view only shows a preview of the results capped at 1000 results).

3. Configure license: Configure the license with the report restriction and perform a reconcile.

4. Verify results: After the reconcile has completed, run a slightly modified version of the above query against the FNMSCompliance DB and confirm that it contains the list of 25 users from the report above. Include an additional 'TotalRows' column and add a where clause to illustrate that the query returned 25 rows and that the ComplianceUserID is not NULL for any of the 25 rows and should match the users in ComplianceUser which is returned by the report.