Groups User Belongs To LiveReport

I would like to create a LiveReport that duplicates the Admin feature of searching for a user, in Users & Groups, and then selecting Groups to see what groups they belong to. Has anybody found a way to do this?

Find more posts tagged with

Comments

Chad Latka

Message from Latka, Chad J. \(IT\) via eLinkI found something similar, but it is not quite it:https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2622786&objAction=viewThis is another post titled - " My Groups - Idriss Souary (DanskAdmin)11/12/2001 10:05 AM "-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, May 03, 2005 3:55 PMTo: eLink RecipientSubject: Groups User Belongs To LiveReportGroups User Belongs To LiveReportPosted by Latka, Chad on 05/03/2005 04:49 PMI would like to create a LiveReport that duplicates the Admin feature ofsearching for a user, in Users & Groups, and then selecting Groups tosee what groups they belong to. Has anybody found a way to do this? [To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Knowledge_Center_Administrator

Hi thereI use something like this on the KC:=======Inputs:=======Type: StringPrompt: Login====SQL:====select name from kuaf where id in (select id from kuafchildren start with childid in (select id from kuaf where lower(name) = lower(%1)) connect by prior id=childid) and type=1 and name not in ('Members','Guests','Coordinators') order by name=========Param %1: =========User Input 1==============Report Format:==============AutoLiveReportRegards,Dave

volvostephen

Message from via eLinkAnother (much more complicated) approach is to create a static table thatgets populated periodically (or by a trigger) that contains a list of everygroup a user is part of whether it be directly assigned or inherited as aresult of a group membership. This is what I have done - maybe an oddapproach but I had my reasons.In Livelink 9.1.2 there was a table called KUAFRightsList. This was sort ofwhat I mentioned above. When you upgrade to 9.1.3, this table is deprecatedbut still remains in the schema however it is no longer updated. Because wealready had quite a few LiveReports that used this table, I thought it wouldbe worthwhile to keep the table current so I built a script that runs eachday to re-create that table (see below).The benefit of the static table is you can use it in joins very easily andthe performance against it is phenomenal. It has come in handy for us formany reasons.Here is the script (SQL Server)------------------------------------------------------------if exists (select * from dbo.sysobjects where id =object_id(N'[livelink].[KUAFRightsList_NEW]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [livelink].[KUAFRightsList_NEW]GOCREATE TABLE [livelink].[KUAFRightsList_NEW] ( [RLID] [int] NOT NULL , [RLRightID] [int] NOT NULL , [RLProxyType] [int] NULL ) ON [PRIMARY]CREATE TABLE #tmp ( [RLID] [int] NOT NULL , [RLRightID] [int] NOT NULL , [RLProxyType] [int] NULL ) ON [PRIMARY]GO CREATE INDEX [KUAFRightsList_RLID] ON[livelink].[KUAFRightsList_NEW]([RLID]) ON [PRIMARY]GO CREATE INDEX [KUAFRightsList_RLProxyType] ON[livelink].[KUAFRightsList_NEW]([RLProxyType]) ON [PRIMARY]GO CREATE INDEX [KUAFRightsList_RLRightID] ON[livelink].[KUAFRightsList_NEW]([RLRightID]) ON [PRIMARY]GOdeclare @ID Intdeclare @c_curs cursorset @c_curs = cursor local FORWARD_ONLY STATIC for select ID from livelink.kuaf where type = 0 and deleted = 0open @c_curs fetch next from @c_curs into @fetch_status = 0) begin Insert into #tmp select @ID [RLID],A.ID [RLRightID], 0[RLProxyType] from livelink.kuafchildren A with (nolock) inner join livelink.kuaf B with (nolock) on A.ID =B.ID where A.ChildID = @Rowcount > 0 Begin insert into #tmp Select @ID [RLID],A.ID[RLRightID], 0 [RLProxyType] from livelink.KuafChildren A with (nolock) inner join livelink.kuaf B with (nolock) onA.ID = B.ID where B.Type = 1 and B.Deleted = 0 and A.ChildID in (select RLRightID from #tmpwhere RLID = @ID) and A.ID not in (select RLRightID from #tmpwhere RLID = @ID) end fetch next from @c_curs into @ID endclose @c_cursdeallocate @c_cursInsert into [livelink].[KUAFRightsList_NEW] select distinct RLID, RLRightID,RLProxyType from #tmpdrop table #tmpif exists (select * from dbo.sysobjects where id =object_id(N'[livelink].[KUAFRightsList_OLD]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [livelink].[KUAFRightsList_OLD]GOBEGIN TRANSACTION EXEC sp_rename 'livelink.KUAFRightsList', 'KUAFRightsList_OLD','object' EXEC sp_rename 'livelink.KUAFRightsList_NEW', 'KUAFRightsList','object'COMMIT---------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: May 4, 2005 8:10 AMTo: eLink RecipientSubject: Groups User Belongs To LiveReportGroups User Belongs To LiveReportPosted by Administrator, Knowledge Center on 05/04/2005 08:03 AMHi thereI use something like this on the KC:=======Inputs:=======Type: StringPrompt: Login====SQL:====select name from kuaf where id in (select id from kuafchildren start withchildid in (select id from kuaf where lower(name) = lower(%1)) connect byprior id=childid) and type=1 and name not in('Members','Guests','Coordinators') order by name=========Param %1: =========User Input 1==============Report Format:==============AutoLiveReportRegards,Dave[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Groups User Belongs To LiveReporthttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3971379&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe