Skip to main content
V
VR_400014-Alexandrite
14-Alexandrite
March 14, 2025
Solved

Get user license with indirectly assignment

  • March 14, 2025
  • 1 reply
  • 465 views

Version: Windchill 12.1

 

The goal is to compare what licenses are in use, and what the user have.

To do that I'm planning to compare what is assigned to them to the list from the Detailed License Usage from license management report.

 

But I only could find a way to get that for users who are directly assigned to a license group.

 

For those who were assigned to a new group and then this group was assigned to a profile group, I couldn't manage to get a report on what license they have.

 

I'm trying to to do that with the business report. I've looked the QML repositories but still haven't found a way to get those indirectly assignment.

 

Does anyone know a how to have that info?

Best answer by joe_morton

Hi,

Windchill query builder doesn't support recursive queries, so there's no easy way to cover the case of reporting users who may be in a group which is in a group, which is in a group, which is then in a license profile. As long as you limit the number of group levels, you could write multiple queries and aggregate them:

  • 1 for users who are directly added to the license profile
  • 1 for users who are in a group that is directly added to the license profile
  • 1 for users who are in a sub group, which is added to a group, which is directly added to the license profile
  • .... repeat for as many grouping levels as you use

 

You can try something like this to get started:

joe_morton_0-1742243408881.png

 

This returns Users that are in a wt.org.WTGroup that is in turn in another wt.org.WTGroup.

For me, this ran really slowly. It looks like every site level license group is in another site level license group. I added the Administrative Domains so I can specify that for the first group, the Administrative Domain should be our Organization's name (we have just 1). That significantly limited the results and made it run faster. Test it out.

 

joe_morton_1-1742243595397.png

 

1 reply

joe_morton
18-Opal
joe_morton18-OpalAnswer
18-Opal
March 17, 2025

Hi,

Windchill query builder doesn't support recursive queries, so there's no easy way to cover the case of reporting users who may be in a group which is in a group, which is in a group, which is then in a license profile. As long as you limit the number of group levels, you could write multiple queries and aggregate them:

  • 1 for users who are directly added to the license profile
  • 1 for users who are in a group that is directly added to the license profile
  • 1 for users who are in a sub group, which is added to a group, which is directly added to the license profile
  • .... repeat for as many grouping levels as you use

 

You can try something like this to get started:

joe_morton_0-1742243408881.png

 

This returns Users that are in a wt.org.WTGroup that is in turn in another wt.org.WTGroup.

For me, this ran really slowly. It looks like every site level license group is in another site level license group. I added the Administrative Domains so I can specify that for the first group, the Administrative Domain should be our Organization's name (we have just 1). That significantly limited the results and made it run faster. Test it out.

 

joe_morton_1-1742243595397.png

 

    Terms & ConditionsAccessibility statement