List of all disabled/expired user account

Forum|Forum|10 years ago
July 15, 2016
4 replies
2970 views

Is There a way to generete a report or a list of all windchill users which have the account disabled or expired?

Does this list be retrived from windchill or from WindchillDS?

I try to do a report listing the user "Disabled", but this is not what I need; I need all the user in the LDAP with the account disabled or expired.

Query Builder.png

Does anyone know how can I have this information?

Thanks in advance

Other

Best answer by ChrisSpartz

Query builder will only query the Windchill database. The Windchill DB doesn't store information on whether LDAP accounts are disabled/expired. All the Windchill DB stores is the Disabled column on the WTUser table that you show above, which indicates that a user has been deleted from Windchill. In order to get a list of disabled/expired LDAP accounts, you will need to query the LDAP.

C

ChrisSpartz

Answer

13-Aquamarine

Query builder will only query the Windchill database. The Windchill DB doesn't store information on whether LDAP accounts are disabled/expired. All the Windchill DB stores is the Disabled column on the WTUser table that you show above, which indicates that a user has been deleted from Windchill. In order to get a list of disabled/expired LDAP accounts, you will need to query the LDAP.