snorroy
Level 3

Query FNMS user entitlements

Jump to solution

Our User Access Management system would like to query the FNMS database to retrieve the list of users with access to FNMS, as well as associated privileges (user, operator, admin).

Has anyone done that before or knows what table(s) to query to access that information?

Is there a FNMS database schema available which we can use to work out how to do that?

Thanks.

0 Kudos
1 Solution
mfranz
Level 15

Hi,

This is mapping Compliance Operators to Roles:

USE FNMSCompliance

SELECT
	co.OperatorLogin
	,ge.GroupCN Role
FROM MemberEx me
JOIN ComplianceOperator co
	ON me.TargetID = co.ComplianceOperatorID
		AND me.TargetTypeID = 16 -- ComplianceOperator
JOIN GroupEx ge
	ON me.GroupID = ge.GroupID

If you need the specific rights, you'll have too look into the following tables:

SELECT * FROM RoleRight
SELECT * FROM ActionClass
SELECT * FROM Resource

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

3 Replies
mfranz
Level 15

Hi,

This is mapping Compliance Operators to Roles:

USE FNMSCompliance

SELECT
	co.OperatorLogin
	,ge.GroupCN Role
FROM MemberEx me
JOIN ComplianceOperator co
	ON me.TargetID = co.ComplianceOperatorID
		AND me.TargetTypeID = 16 -- ComplianceOperator
JOIN GroupEx ge
	ON me.GroupID = ge.GroupID

If you need the specific rights, you'll have too look into the following tables:

SELECT * FROM RoleRight
SELECT * FROM ActionClass
SELECT * FROM Resource

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

Thank you for that. We'll give it a try and I'll let you know how it goes.

It works perfectly. Thank you 🙂