I have a group of students who frequently borrow help desk/spare equipment, and I'm looking for a way to track the usage history of these devices. Specifically, I'd like to know
Total checkouts for each spare device: How many times has each spare device been checked out?
Checkouts by user: For each spare device, can I identify the users who have checked it out?
User checkout history: Can I determine how many spare devices each user has checked out within a specified timeframe?
I'm hoping to use this information to identify students who may be hoarding spare devices or using them excessively. Any suggestions on how to achieve this using would be greatly appreciated.