I've been asked to make a simple custom report where you put in the computer(s) you want to report on and it would show the software name, license name, key, and expiration dates for each license the computer has. I have this working pretty well right now except that if any license is a part of a group with multiple licenses (say Adobe Pro individual licenses for certain machines), the report will show every single license in that group as applying to the chosen computer.
To give a better example. I have in my license management a group for Acrobat Pro X, inside I have License 1, 2, 3 each assigned to single computers, A, B, and C. When I run the report and ask it for all licenses assigned to Computers 1, 2, 3 I get the following output:
Computer A - License 1
Computer A - License 2
Computer A - License 3
Computer B - License 1
Computer B - License 2
Computer B - License 3
Computer C - License 1
Computer C - License 2
Computer C - License 3
When I would like it to show how they are really assigned:
Computer A - License 1
Computer B - License 2
Computer C - License 3
Please let me know if there is something I'm missing in the custom report that could fix this as its quite frustrating running a report against a large install base like office. Of note, all licenses have been assigned by making sure they showed up in "Installed Computers" and not by using the Managed Compuer (SoM) list.
Thank you for your help.