Skip to main content
S
21-Topaz I
STEVEG21-Topaz I
21-Topaz I
October 15, 2019
Question

How to filter out a user from a report when the user is in a specific group

  • October 15, 2019
  • 1 reply
  • 2341 views

I created a report to find out when a user last logged in by using the "Audit Record" table. Now I want to filter out any user that is in a specific group. This group is called "Deactivated" and it would be the only group they are in if they are in fact deactivated. How can I create this filter in my report?

 

I tried putting a link the Audit Record table to the "User" table but it won't let me create one.

1 reply

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
October 16, 2019

Hi Steve,

I have a report that I use to count the number of monthly access of every user.

 

The report search on three tables: WTUser, AuditRecord and EventInfo.

 

There is no join between User and Audit tables and, despite this, it gives me exactly what I want.

 

If you want to filter disconnected user, I think you can simply use Disabled attribute on User table.

Marco
S
21-Topaz I
STEVEG21-Topaz IAuthor
21-Topaz I
October 16, 2019

The only thing I do is to add them to the Deactivated group and remove their email address.  Is there another way to set the user to Deactivated?

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
October 17, 2019

The way in which deactivated users are managed depends on a number of factors.

 

Do users connect to the Active Directory or WindchillDS for authentication?

 

How often a disabled user is reactivated?

 

In my case, authentication is done via the Active Directory and very rarely a disabled user has been reactivated.

 

In this case, when a user leaves the company, he is removed from the AD and deleted from Windchill.

 

In this way, from GUI beside the name of the user appears the written (deleted) and in the User table the attribute Deactivated is valorized to Yes.

 

Marco
Terms & ConditionsCookie settingsAccessibility statement