Inactive users Confluence

[Valeriy]

Hi!
I used this instruction, but I could not get a list of inactive users
https://confluence.atlassian.com/confkb/how-to-identify-inactive-users-in-confluence-214335880.html

I get the error message
Msg 207, Level 16, State 1, Line 3
Invalid column name 'username'.
Msg 207, Level 16, State 1, Line 6
Invalid column name 'successdate'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'successdate'.

[Igor M.]

Hello,

Can you confirm which version of Confluence you are running this against? 

Column username does not exist in the version above 5.2, so you need to use the second option of KB, like this:

SELECT u.user_name, d.directory_name, l.successdate
FROM logininfo l
JOIN user_mapping m ON m.user_key = l.username
JOIN cwd_user u ON m.username = u.user_name
JOIN cwd_directory d ON u.directory_id = d.id
WHERE successdate < '2016-01-01'
ORDER BY successdate;

I tested this on my 5.10.* and it returns results 

[Steven Behnke]

Pardon, but this is elementary. Ensure your column names are cased appropriately. IE SUCCESSDATE =/= successdate.