In order to create a License Usage report you have to activate license tracking in Server information.

The report will be generated afterwords exporting data from the query output (designed of Oracle database):

SELECT a.USER_NAME, b.FIRST_NAME, b.LAST_NAME, a.APPLICATION, a.TYPE_OF_LICENSE, a.LAST_DATETIME FROM (SELECT USER_NAME, APPLICATION, TYPE_OF_LICENSE, TO_CHAR(TO_DATE(’01/01/1970 00:00:00′, ‘MM/DD/YYYY HH24:MI:SS’) + (MAX(TIME) / ( 60 * 60 * 24 )), ‘MM/DD/YY HH24:MI:SS’) as “LAST_DATETIME” FROM AR_SYSTEM_HISTORICAL_LICENSE_U WHERE APPLICATION = ‘BMC:Incident Mgmt’ OR APPLICATION = ‘AR Server’ GROUP BY USER_NAME, APPLICATION, TYPE_OF_LICENSE ORDER BY USER_NAME) a INNER JOIN CTM_PEOPLE b on a.USER_NAME = b.REMEDY_LOGIN_ID;