Hi,

Is their a way I can extract the user id and domain each userid is associated to in a report.
Is this information stored in reportcaster table or some type of file, such as html or text?

thx

This message has been edited. Last edited by: Kerry,

Hi,

Please have a look to the file :

\ibi\WebFOCUS76\basedir

Regards.

John
userids are associated with GROUPS
and GROUPS are associated with DOMAINS
that's the way it works.
When you installed, you decided what your Managed Reporting Repository would be: ie, ORacle or whatever.
There are tables in that Managed Reporting Repository, such as:
WF_MRUSERS
WF_MRDOMAINS
WF_USRGRPTB
WF_GRMDOMTB
etc
Do a search on the tech support site for MANAGED REPORTING REPOSITORY
and ask whoever installed your site to point you to those files.
You'll find everything you need for user-group-domain

There is a program "MR Extract", which is available here:
\ibi\WebFOCUS76\utilities\mrextract.bat

Which should extract into a text file the information you are looking for.

You then should be able to use those text files to report off of.

However, if as Susannah pointed out, if your Managed Reporting information is in an external database it is probably easier to query against the repository tables directly.

the repos tables currently do NOT include the fex names.
In order to read the fexnames within any domain, you can write a master to describe the
/basedir/{domain}/{domain}.htm page.
works really well.
then you can avoid the mrextract utility thing.