User assigned license & last login report

Question

Using the attached QML, I was able to retrieve the users assigned to their respective licenses. However, the report is also returning the associated team roles along with the license or group names to which the licenses are mapped.

Do you have any suggestions on how to exclude all team roles from the report? Although the criteria section technically allows filtering out roles, it is not practical to identify every possible role and create separate criteria entries for each one.

joe_morton · Accepted Answer

You'll have to update your report. Instead of reporting Users directly linked to the license group, you'll need to report users in a group in the license group. Ex: User -> Group -> License Group

Just keep in mind that once you make that update, the report won't return any information on a user who is directly assigned a license. Ex: User -> License Group

You'll also want to consider if you have subgroups. Ex: User -> Subgroup -> Main Group -> License Group

For the reporting to work, you may need to create several reports to cover all cases of license assignment that you use at your company. (Direct assignment, 1 level group, 2 levels groups)

The only other way (I know of) would be to create your own Java Method, and use that in your QML. That would be the way to have a single report that can recursively navigate group structures to get the final license assignment, regardless of how many group levels there may be.

Fadel · Answer

try this ,I used a dummy trick , all license groups starts with PTC:

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded