-
Re: How to find deactivated users from Database
mcollinge Nov 29, 2017 6:49 AM (in response to Aqeel Burhani)1 person found this helpfulThere is a userEnabled field in the jiveUser table. It's not that hard to find
-
Re: How to find deactivated users from Database
Aqeel Burhani Nov 29, 2017 8:05 AM (in response to mcollinge) -
Re: How to find deactivated users from Database
SunilKr Feb 5, 2018 3:14 AM (in response to mcollinge)-
Re: How to find deactivated users from Database
gopi.gorantala Feb 5, 2018 3:55 AM (in response to SunilKr)Two ways:
1. access people screen/tab in admin console. uncheck the "include deactivate users" and you see a user count, now check all the checkboxes and the difference bewtween these two give you the actual deactivated count.
2. REST API, in Peson Object, you see "enabled" set to false for all disabled/deactivated users. You should iterate all the users and grab the count.
-
Re: How to find deactivated users from Database
SunilKr Feb 5, 2018 10:44 PM (in response to gopi.gorantala)Thanks Gopi for the response and yes by both way we can fetch the records.
Specific to REST API, we have filter "include-disabled" in PersonService that we need to set as true(default false to exclude deactivated users).
Example: ?filter=include-disabled(true)
And in Person object, by fetching "enabled" attribute value which is either true or false, we can find the active and deactivated user list.
-
Re: How to find deactivated users from Database
gopi.gorantala Feb 6, 2018 2:16 AM (in response to SunilKr)You don't need to use filters for this. /people will give you all users including disabled entries. /people?filter=include-disabled(true) won't make a difference in the resultset.
-
Re: How to find deactivated users from Database
Aqeel Burhani Feb 6, 2018 6:03 AM (in response to gopi.gorantala)I think you need to include that filter otherwise you will only get active users.
-
Re: How to find deactivated users from Database
SunilKr Feb 7, 2018 11:49 PM (in response to Aqeel Burhani)yes agree with Aqeel Burhani because by default /people service return only active users and if you need the disabled user, we need to include the filter /people?filter=include-disabled(true).
-
Re: How to find deactivated users from Database
gopi.gorantala Feb 8, 2018 1:38 AM (in response to SunilKr)I think I overlooked into the actual question asked. You both were right, a filter is needed. I was talking about per person check which is with /people/{userID} and check for enabled property.
-
-
-
-
-
-
-