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

[STEVEG]

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.

[Marco_Tosin]

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.

[STEVEG]

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]

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.

[STEVEG]

We do not use our AD for Windchill.

[mmeadows-3]

Marco,

What are the defined criteria for your report?  When there are no joins between the tables, the connections are defined thru the criteria.

Thanks,

Matt

[Marco_Tosin]

Yes Matt, connection through criteria is a sophisticated way to bypass issue joining table. In my case these are the criteria