Clearing the license usage log

Depending on how you use license usage data, you may want to occasionally clear the license usage log. For example, you may want to archive your organization’s license usage for a specific timeframe, such as on a monthly basis.

Database queries are used to clear license usage information from the server database. If you use the native SQLite database format, you need to install the sqlite3 command line utility to execute the queries. If you are not familiar with database queries, or your server database is stored in a different RDBMS, ask your DBA for help.

1. Click Server Options.

The Server Options dialog box opens.

2. Select the Log category.

3. Clear Log license usage.

4. Click OK to save the changes.

5. In the license server database, remove the rows from the following tables:

EVENT
EVENTDETAILS
EVENTUSER

6. If you want to maintain a record of license usage to the current date, use the following queries to copy data from the master tables to archive tables:

INSERT INTO Event_ARCHIVE (SELECT * FROM Event)
INSERT INTO EventDetails_ARCHIVE (SELECT * FROM EventDetails)
INSERT INTO EventUser_ARCHIVE (SELECT * FROM EventUser)

7. To delete data from the master table after it is archived, use the following queries:

DELETE FROM Event;
DELETE FROM EventDetails;
DELETE FROM EventUser;

8. To maintain unique identifiers for the archived data, use the following queries:

INSERT INTO Event_ARCHIVE(SELECT * FROM Event WHERE id < (SELECT MAX(id) FROM Event))
INSERT INTO EventDetails_ARCHIVE(SELECT * FROM EventDetails WHERE id < (SELECT MAX(id) FROM Event))
INSERT INTO EventUser_ARCHIVE(SELECT * FROM EventUser WHERE id < (SELECT MAX(id) FROM EventUser))
DELETE FROM Event WHERE id (SELECT MAX(id) FROM Event))
DELETE FROM EventUser WHERE id (SELECT MAX(id) FROM EventUser))
DELETE FROM EventUser WHERE id (SELECT MAX(id) FROM EventUser))

9. After the log is cleared, re-enable license usage logging. See Setting server log options.