postgres statement for null successdate

[Dana Grahf]

I am trying to get the number of users who have never logged into Confluence Server 6.6 - there are only 2 when I went through the tables.  The SucessDate is null which is expected but I can't figure out the postgres statement to query those 2 users.  I have tried SUCCESSDATE is NULL but to no avail

[Igor M.]

Hello,

You can try where li.SUCCESSDATE IS NULL depending on your query and which tables your running against. But you can also use this query:

select user_name from cwd_user where user_name not in
(SELECT cwd_user.user_name
FROM cwd_user, cwd_user_attribute
WHERE cwd_user_attribute.user_id = cwd_user.id
AND cwd_user_attribute.attribute_name = 'lastAuthenticated');

Taken from KB: How to check for users who never logged into Confluence