How to get Inactive users in a community using SQL

Today, a user requested us to get a list of all inactive users in her community. The community had 29000 + members and they had never cleaned up. As we are running 5.5 CR3, the wsadmin command to remove inactive users is not available (CommunitiesService.removeInactiveUsers(String “Uuid”, boolean skipLastModBump).  So Database was the only solution. Here’s …

How to get Inactive users in a community using SQL Read More »