I think it'd be very handy to have a table or view that creates some consistency between the softwareUni and Serialnumber tables. I'm using lansweeper in another application to query whether or not a specific key is used while also allowing the logging of other software we own (also gained from lansweeper through the SoftwareUni table).
I think it'd just be very helpful to have some form of reference between the SoftID and the SerialID.Right now I'm trying to build it through the software table, problem is each unique instance of software is returning every licensed piece of software that relates to the Asset associated with the install. I'm looking at a query returning 47231 rows trying to thing how I can possibly make it into a distinct list of just titles and product names.
Anyone doe this before? is this a view that I can implement?
Cheers, Dan
