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.
Best answer by JohanLindstrom
View original
Userlevel 7
+22
Hi
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
Thank you very much for your assistance,
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.