Skip to main content
C
CA_1076744710-Marble
10-Marble
April 3, 2024
Solved

License Usage Report in Codebeamer

  • April 3, 2024
  • 1 reply
  • 1772 views

Is it possible to generate detailed License usage report to know full details of active users, logged in user, timings, location etc.

Best answer by Karol_Arorian

Hi,

I'm not aware of such a functionality OOTB in codebeamer but there are two ways to get some of these informations.

  1. In System Admin -> Server Status Dashboard there is "Logged In Users & Licenses Info" chart which will show you just the numbers.
  2. To get details of session history you could use System Admin -> iSql functionality and type there an SQL query.

 

SELECT * FROM public.session_history
ORDER BY login_time DESC

 

The result is a raw data from database so it's not user-friendly but it can help you.
The result could be also exported to excel - there is a button below the results table.

1 reply

K
Karol_Arorian12-AmethystAnswer
12-Amethyst
April 3, 2024

Hi,

I'm not aware of such a functionality OOTB in codebeamer but there are two ways to get some of these informations.

  1. In System Admin -> Server Status Dashboard there is "Logged In Users & Licenses Info" chart which will show you just the numbers.
  2. To get details of session history you could use System Admin -> iSql functionality and type there an SQL query.

 

SELECT * FROM public.session_history
ORDER BY login_time DESC

 

The result is a raw data from database so it's not user-friendly but it can help you.
The result could be also exported to excel - there is a button below the results table.

    C
    CA_1076744710-MarbleAuthor
    10-Marble
    April 4, 2024

    Hi,

    This is very helpful.

    Is there any documentation where i can see the table names(e.g public.session_history) and column names?

    This can help me fetch the data directly from database.

     

      K
      Karol_Arorian12-Amethyst
      12-Amethyst
      April 4, 2024

      No, I'm not aware of any documentation.

      Terms & ConditionsCookie settingsAccessibility statement