Good Morning - Is there a way to generate a report within IFS 9 to create a list of employees and what IFS License they have been assigned ie. either Full or Limited? Many thanks for your help.
Solved
IFS User License Report
Best answer by JohanLindstrom
And here is some example sql code if you want to make it into a quick report or similar:
select
t.identity "Identity",
t.description "User Name",
t2.role_scope "Licence Type"
from IFSAPP.FND_USER t
left outer join IFSAPP.FND_LICENSED_ROLE_USER t2 on t.identity = t2.identity
where t.active = 'TRUE'
order by t.identity
BR
Johan
+23Hi
yes, try this screen:
And then to this with rmb:
And here is some example sql code if you want to make it into a quick report or similar:
select
t.identity "Identity",
t.description "User Name",
t2.role_scope "Licence Type"
from IFSAPP.FND_USER t
left outer join IFSAPP.FND_LICENSED_ROLE_USER t2 on t.identity = t2.identity
where t.active = 'TRUE'
order by t.identity
BR
Johan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.