For a variety of reasons, my company is rolling out chat gradually, rather than to everyone at once; one consequence of this is that we need a way for people to see who else has chat available, or who else is logged on.
I’‘d like to set up a page that’‘s basically like the Client Sessions page in the admin console (except it can be even more stripped down - no need for IPs or anything like that). Searching the forums revealed that there’‘s no straightforward way to get this from JM, and that the recommended solution is to use the presence plugin. Sounds good - get the list of users, check to see who’'s online - ready to roll.
The problem, however, is that we’‘re using AD/LDAP for authentication - so I don’‘t have a list of users to work off of. Querying the database (MySQL, though I don’‘t think it matters) doesn’‘t seem to be a good way out - jiveUsers doesn’‘t have anything useful (which makes sense - it’‘s all in LDAP), while jiveRoster has a lot of junk (mostly caused by user typos). I tried a few variations like “SELECT DISTINCT username FROM jiveRoster”, but they all seem to return way more users than have actually used the system (and some records that aren’'t valid usernames at all).
Am I missing something, or is there really no straightforward (i.e. 1-2 SQL queries) way of finding all valid users if you’'re using LDAP?
PS - To save everyone time: Yes, I do have alternate means of getting that information, but for reasons that don’‘t merit space here, I’'d prefer a more JM-based solution - if one exists.