Here is some SQL I put together in response to the question "How do I list all active users and their departments?". I made the assumption that by "active users" one means those who have the "Login Enabled" privilege which is recorded as part of a bitmask in the UserPrivileges column in the KUAF table of the Livelink database. A value of 15 is "added" to the bitmask when this privilege is granted to users, and this is what the SQL checks for.
I would strongly recommend that you verify the output of the SQL since it has only undergone minimal testing here -- I leave it to the customer to verify the SQL with their own output and make any corrections to the SQL they find necessary.
select a.name, a.lastname, a.firstname, b.name "Department", a.userprivileges from kuaf a, kuaf b where bitand(a.userprivileges, 15) = 15 and a.type=0 and a.groupid=b.id
- Bhupinder
------------------------------------------------------Bhupinder Singh, B.Math., B.Ed.Senior Product Specialist, Customer SupportOpen Text Corporation, Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------
Livereport Department GroupsPosted by Treger, Ann Marie on 10/06/2006 01:23 PM I am looking to collect the "default" group or as sometimes refered to as "department" group, for all users. I have not been abe to gather this information except by using the "find user" and collecting the data into EXCEll spreadsheets. Very tedious.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.
