Knowledgebase

Search:     Advanced search

Clearing the License Usage Log

Article ID: 280  |  Last updated: 23 Dec, 2014

Note: This information only applies to Seapine License Server 2010.1 and later.

Depending on how you use license usage data, you may want to clear the license usage log from time to time. This can be helpful if you want to archive your organization’s license usage for a specific timeframe, such as on a monthly basis. Following are the steps for clearing the license usage log in native and RDBMS Seapine License Server databases.

Native database

  1. Disable license usage logging by starting the Seapine License Server Admin Utility, clicking Server Options, and clearing the Log license usage option in the Log category.
  2. Click OK to save the changes.
  3. Close the Seapine License Server Admin Utility.
  4. Remove the following files from the LicenseServerDb folder in the Seapine License Server application directory:
    • EVENT.TTT
    • EVENT.TTI
    • EVENTDETAILS.TTT
    • EVENTDETAILS.TTI
    • EVENTUSER.TTT
    • EVENTUSER.TTI
      Note: Copy these files if you want to archive license usage to the current date.
  5. Re-enable license usage logging in the Seapine License Server Admin Utility to track future license usage.

RDBMS database

  1. Disable license usage logging by starting the Seapine License Server Admin Utility, clicking Server Options, and clearing the Log license usage option in the Log category.
  2. Click OK to save the changes.
  3. Close the Seapine License Server Admin Utility.
  4. Remove the rows from the following three tables in the database:
    • EVENT
    • EVENTDETAILS
    • EVENTUSER

    Copy data from the master tables into archive tables if you want to maintain a record of license usage to the current date by using the following queries:

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

    To delete data from the master table after it has been archived, use the following queries:

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

    To maintain consistently 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))
  5. Re-enable license usage logging in the Seapine License Server Admin Utility to track future license usage.
Article ID: 280  |   Last updated: 23 Dec, 2014
Tags
license usage log

Prev   Next
License Server Cannot Query Active Directory Servers Using...     Backing Up License Server Databases