The objective of this storing of license usage data is to enable the management to analyze the usage of the licenses, if it's too occupied, we might be able to convince our management to purchase more licenses from PTC. This indirectly will increase the sales of PTC products.
The data should save in a format of Text / Excel / Access or MS SQL format for easy retrieval.
Table structure should have the following fields : Windows LIcenseType, Certificate, UserID, PC/Laptop name/Client, duration of occupying the license,Start Date&Time, End Data&Time, and other related fields.
It would be ideal that there is an report, which user is able to select the selection. Example can filter by Date (By selecting start date and end date).