The VID_SystemMeter report generated from Launchpad called: "Create license report" is showing incorrect data.
License Count - additional Modules, is showing the wrong value.
SAP R/3 User Management Module showing the result is 1 which is not the case.

Generally, the "VID_SystemMeter" report is using the "SystemInfos" object to represent the information:

The "SystemInfos" object is receiving the data from the "QBMSystemMetering" view:

In 9.2.x versions, please navigate to "Designer \ System tables \ QBMSystemMetering \ ViewAddons \ Target System Connector (SAP) ", like the example below:

Here in the SQL section, the responsible SQL query which is delivering the identities accounts that is presented in the report.
Alternatively,
The the below query can be run to get the information:
1. SELECT 'SAP' as Object /*LicenseSubType */
2. , count(distinct u.UID_Person) as CountObjects /* LicenseCount*/
3. , min(u.XObjectKey)as XObjectKey
4. , min(u.XDateInserted)as XDateInserted
5. , min(u.XDateUpdated) as XDateUpdated
6. from SAPUser u
7. where u.UID_Person in(
8. --take the Person from any SAPUser where the Person is an ManagedIdentity from QER_VLicenseIdentites where SortOrder > 0
9. SELECT u1.UID_Person
10. FROM SAPUser u1
11. WHERE u1.UID_Person IN
12. (
13. SELECT i.ManagedIdentity
14. FROM QER_VLicenseIdentites i
15. WHERE i.SortOrder > 0
16. )
17.
18. UNION
19. --take the person from SAPUser where the Person is an ManagedIdentity from QER_VLicenseIdentites where SortOrder = 0
20. -- and this person has an SAPUser account where this Person is NOT a master identity of another Person which a linked SAPuser account
21. SELECT u2.UID_Person
22. FROM SAPUser u2
23. WHERE u2.UID_Person IN
24. (
25. SELECT i.ManagedIdentity
26. FROM QER_VLicenseIdentites i
27. WHERE i.SortOrder = 0
28. )
29. AND u2.UID_Person in
30. (select u.UID_Person as sapperson
31. from SAPUser u join Person pm on pm.UID_Person = u.UID_Person
32. where u.UID_Person > ' '
33. and not exists (select u3.UID_Person
34. from SAPUser u3
35. where u3.UID_Person = pm.UID_PersonMasterIdentity
36. )
37. )
)
*please note, there are some comments in the SQL to understand, what the query is doing, make sure they remain comment
The only extension in the SQL above is that the following 3 columns are added, to be able to use this in a custom view:
Use the SQL command above (with or without the 3 fields), below is the type of output that would be returned:

Or with the 3 fields, below is the output:

© 2026 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center