system
October 23, 2002, 12:15pm
#1
I know this has been done to death but for the life of me I can’t find any reference here via search. (Admittedly, I need coffee.)
So if anyone can point me to the right posts, my need is this:
I need to be able to provide reports that show the following:
Which users are in which group? (Grouped by group name)
Which groups are the users in? (Grouped by user)
Which documents belong to which group? (Grouped by group name)
Which users access which document? (Grouped by user or document)
The repository is a pain in the arse to report from, so if anyone’s invented the wheel yet, I need a boost.
Thanks,
P.S. Oh, and my repository is in SQL Server 7, BO Version 5.1.x
Blake Sanders (BOB member since 2002-08-29)
system
October 23, 2002, 1:16pm
#2
Sounds like you want a universe off of the repository. There should be some samples on the BO CD.
Also Dave’s site has some sample ones. http://www.islink.com/isi_library_downloads_BO_supervisor.htm
Not sure if any are in SQL Server but you could modify one to work with your db.
Hope this helps!
Stacy Woodring (BOB member since 2002-08-15)
system
October 23, 2002, 1:39pm
#3
You have to basically query
obj_m_actorlink and obj_m_actor tables
Reema
reemagupta (BOB member since 2002-09-18)
system
October 23, 2002, 2:15pm
#4
Hmm lemme amend that… the users by group thing is easy to obtain. It’s the document to group links that I’m having trouble with.
Blake Sanders (BOB member since 2002-08-29)
system
October 23, 2002, 2:39pm
#5
I have a repository universe for SQL 7.0, BO 5.1.x - but I don’t think it will do what you need. You probably need to dechipher table OBJ_M_ACTORLINK… I’ll send it to and you can play with it…
Italo Sessegolo (BOB member since 2002-08-29)
system
October 24, 2002, 8:12pm
#6
Here is a topic that discusses some of the issues you’re facing…
Dave
Dave Rathbun (BOB member since 2002-06-06)
(BOB member since 2002-06-06)