select entity_name, entity_key, date_val from os_propertyentry where entity_key like '%user.last.login.date%' and date_val < (some date value);

select username, successdate from logininfo where successdate < (some date value);

select l.username, l.successdate 
	from logininfo l 
	join cwd_user u	on l.username = u.user_name
	join cwd_membership m on u.id = m.child_user_id
	where l.successdate < '<insert-date/range-here>'
	and m.parent_id =
		(select g.id 
			from cwd_group g 
			where g.lower_group_name ='confluence-users' 
			and g.directory_id=
				(select d.id 
					from cwd_directory d 
					where d.lower_directory_name = 'confluence internal directory')
		);

select u.lower_user_name, l.successdate
    from logininfo l
    join user_mapping um on l.username = um.user_key 
	join cwd_user u on u.lower_user_name = um.lower_username
    join cwd_membership m on u.id = m.child_user_id
    where l.successdate < '<insert-date/range-here>'
    and m.parent_id =
        (select g.id
            from cwd_group g
            where g.lower_group_name ='confluence-users'
            and g.directory_id=
                (select d.id
                    from cwd_directory d
                    where d.lower_directory_name = 'confluence internal directory')
        );