Skip to main content
Solved

Checking who is consuming FSM NAMED License

  • July 7, 2026
  • 2 replies
  • 51 views
W
Do Gooder (Customer)
Forum|alt.badge.img

Hi Experts 

 

I need some help in figuring out how the License Admin in FSM6 gets the Value of In Use and Available for Named Licenses. Is there a specific logic and which tables gets this value? 

 

Thank you in Advance. 

 

Best Regards

 

Widy

Best answer by roklde

Hi Widy,

this information is available in the person table, column metrix_user_type. You can use this query to fetch all person_ids with license type “named”:
 

select person_id from person where metrix_user_type = 'NAMED'

However, simply creating a person record with a license type isn’t enough to consume a license. The user must be set to active and login to the system to consume a license token. This is recorded inside the mx_t-table. 

Following query would provide you the named person records which also have logged into the system (=”in use” in the License Administration):
 

select person_id, status, last_logged_in from person
inner join mx_t on mx_t.mx_t_02 = person.person_id 
where person.metrix_user_type = 'NAMED';


Note: A single person can have several entries in mx_t as a token is generated per client type (e.g. smart client, mobile client, etc.).

The “available” in the License Administration comes from the bought licenses and is hardcoded in the license file provided by IFS.


Best regards
Roman

2 replies

roklde
Superhero (Employee)
Forum|alt.badge.img+27
  • roklde
  • Superhero (Employee)
  • Answer
  • July 14, 2026

Hi Widy,

this information is available in the person table, column metrix_user_type. You can use this query to fetch all person_ids with license type “named”:
 

select person_id from person where metrix_user_type = 'NAMED'

However, simply creating a person record with a license type isn’t enough to consume a license. The user must be set to active and login to the system to consume a license token. This is recorded inside the mx_t-table. 

Following query would provide you the named person records which also have logged into the system (=”in use” in the License Administration):
 

select person_id, status, last_logged_in from person
inner join mx_t on mx_t.mx_t_02 = person.person_id 
where person.metrix_user_type = 'NAMED';


Note: A single person can have several entries in mx_t as a token is generated per client type (e.g. smart client, mobile client, etc.).

The “available” in the License Administration comes from the bought licenses and is hardcoded in the license file provided by IFS.


Best regards
Roman

    W
    Do Gooder (Customer)
    Forum|alt.badge.img
    • wlpangarso
    • Author
    • Do Gooder (Customer)
    • July 15, 2026

    Hi Widy,

    this information is available in the person table, column metrix_user_type. You can use this query to fetch all person_ids with license type “named”:
     

    select person_id from person where metrix_user_type = 'NAMED'

    However, simply creating a person record with a license type isn’t enough to consume a license. The user must be set to active and login to the system to consume a license token. This is recorded inside the mx_t-table. 

    Following query would provide you the named person records which also have logged into the system (=”in use” in the License Administration):
     

    select person_id, status, last_logged_in from person
    inner join mx_t on mx_t.mx_t_02 = person.person_id 
    where person.metrix_user_type = 'NAMED';


    Note: A single person can have several entries in mx_t as a token is generated per client type (e.g. smart client, mobile client, etc.).

    The “available” in the License Administration comes from the bought licenses and is hardcoded in the license file provided by IFS.


    Best regards
    Roman

    Thank you Roman! 

    very helpful

     

    Best Regards

     

    Widy

      Terms & ConditionsAccessibility statement