snorroy
Occasional contributor

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

Accepted Solutions
mfranz
Shining star

Re: Query FNMS user entitlements

Jump to solution

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
Shining star

Re: Query FNMS user entitlements

Jump to solution

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

snorroy
Occasional contributor

Re: Query FNMS user entitlements

Jump to solution
Thank you for that. We'll give it a try and I'll let you know how it goes.
snorroy
Occasional contributor

Re: Query FNMS user entitlements

Jump to solution

It works perfectly. Thank you 🙂