Need query to fetch total groups in livelink?

Nehal_Goswami

I need a query that can be used to fetch the total group in my Livelink 9.7.1 application. Along with that, it should also fetch the owners of each group whether deleted or existing.

Greg_Griffiths_(ggriffiths_-_(deleted))

You should be able to do the following :SELECT count(*) FROM kuaf WHERE type=1This will not include Project groups, such as CoOrds, Members, Guests or other special groups.If you run the following SQL it will show you all the information about each group :SELECT * FROM kuaf WHERE type=1In this result the LEADERID column is the group leader, this value is NULL if a Leader has not been set.If you ask you OT Account Manager they can provide you with an NDA, which when signed will give you a copy of the database schema which will help along with the helper documentation at https://knowledge.opentext.com/knowledge/llisapi.dll/fetch/2001/744073/2120338/2120999/6849437/Application_Note_-_Livelink_Schema_Companion_Reference_Guide_(LES_971)(Feb_2008_Version_2).pdf?nodeid=13682418&vernum=-2