Solved

How to query user license usage

  • 22 April 2021
  • 4 replies
  • 375 views

Userlevel 7
Badge +24

This is an apps 9 question but i think is equally valid for Apps 10 and later

 

Is it possible to write a sql query that pulls out a list of active users and their current IFS license usage?

icon

Best answer by ShawnBerk 22 April 2021, 19:13

View original

4 replies

Userlevel 7
Badge +28

@paul harland 

Is this what you are seeking?

SELECT fnd_license_api.get_licensed_full_users FROM DUAL; 

SELECT fnd_license_api.get_consumed_full_users FROM DUAL;

Userlevel 7
Badge +24

hi @ShawnBerk ,

no sorry i am looking for a list like

 

User A            Full

User B            Full

User C            ShopFloor

Userlevel 7
Badge +28

@paul harland 

Ahhh, like this then?

select * from INST1APP.fnd_licensed_role_user

Userlevel 7
Badge +24

great thank you Shawn, that will do the job.  

FND_FULL_USER is also a useful view

Reply