Query to find users not in a group (livelink 9.5.0.1.152)

[shackle101]

Hi all looking for a query to find all users not in the "LL Menu - Standard Users Group" for livelink 9.5.0.1.152.

Can anyone help me out here?

Thanks!

 

[appnair]

what is that LL Menu - Standard Users Group a groups your company created?


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[shackle101]

That's correct all users are placed there that are non-admins.

 

[appnair]

Do you know that Kuaf and Kuafchildren
Is how livelink keeps track
Of users and groups I suggest that
You try it a bit or look in the
Kb for answers specific in yr situation

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[shackle101]

The group ID is 106007 and is in the Kuafchildern

I check the KB, and not finding much helpful.

Thanks.

 

[ggriffit]

You will need to start with getting all the data out of KUAFCHILDREN for your group, as this will show direct members who are users or groups - when linked to KUAF - if they are groups, you will need to requery the KUAF children table to get their members too. In oracle this would be a CONNECT BY PRIOR query, or similar in SQL Server.

As mentioned above, the Schema and the associated docs will help significantly

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/