We currently have a table that tracks user software here in our environment. the way we have it setup now is there is a record for each user with the name of the software. the only problem is, some pieces of software have 100 people with it installed, so there are a lot of entries for one piece of software.
Can anyone suggest another way to do this? we also need to track the number of licenses and how many licenses are being used.
I am a basic access user so something kind of easy to do. Thank You