Skip to main content

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.

Hi @dmoore 

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


Terms & ConditionsCookie settings