Does any one know if there is a way to extact the domain names and focexec descriptions that appear on the MRE tree? I am developing a help system that allows users to search descriptions of focexecs and this information would be usefull.

Thank you in advance.

its just an html page
if you look at the directory for any given domain, eg 'untitled', the file untitled.htm contains all of what you see dislayed. the file is simple html; the view via mre is thru a skin.
take a copy of that html page into a text file and parse it out.

Thank you Suzannah. Is there a way to automatically expand the domains. We have numerous folders under each domain. The HTML is generated when each folder is expanded.

Have you looked at the ibi-provided utility program called "mrextract"? It creates tables from the html pages used in MRE that you can query. Its location moved slightly (I recall) between versions, but on 5.21 it is in /webfocus52/utilities. The doc for it is in "WebFOCUS Managed Reporting Administrator's Manual", chapter 10 in my version.

holy cow, Modesto! thats wicked cool to know about.

In versions 5.3 and 7.1, Chapter 10 contains the information on "mrextract". The DN for version 5.3 is 4500584.0904. The DN for version 7.1 4500690.0505.

Hope this helps.

Regards,
Jenn

Great to know that is there. Anything like that for Self Service?

Since self service is not stored in HTML, you don't need it. To report on app folders you use:

 <br />APP LIST HOLD<br />-RUN<br />TABLE FILE FOCAPPL<br />etc<br /> 

To report on fexes in folders you use:

APP QUERY appname HOLD<br />TABLE FILE FOCAPPQ<br />etc<br />  

You can save the results of the first query, and -READ them into variables, and do the second query in a DM loop.
To query master files you query
SYSTABLE (a pseudo-table) and SYSFILES.