sql

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 »

Duplicate users in IBM Connections 3 Homepage table

In IBM Connections 3.0.1 your network contacts are kept in the profiles database, but also in the homepage database. The reason for this is probably because you need them to show feeds for your network in the Homepage application and the applications are developed by different teams so the homepage team probably found it more convenient to …

Duplicate users in IBM Connections 3 Homepage table Read More »