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:

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

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